How to capture merge range?

[Dudely]

I'm using excel file one as the data file for a mail merge.

I need to capture the range of records that is being merged, and at
some point afterwards, open excel file two, copy the range of records
that was merged from file one to file two, and add in the current date
so that I have a record of when the merge was done.

Thank you in advance for any help

 

[macropod]

Hi Dudely,

Are you using vba to drive the merge? Or just the standard mailmerge facilities built into Word? If it's the former, you'll already
have some way of determining the mailmerge record range. If it's the latter, you'll need to build an interface to capture the merge
record range. In either case, the date can be obtained from the OS.

There's plenty of code about for automating Excel from Word, or vice-versa, depending on your preferences.

 

[Dudely]

Just standard mail merge.

I know how to get the date, I was just trying to be complete.

Thank you

Hi Dudely,

Are you using vba to drive the merge? Or just the standard mailmerge facilities built into Word? If it's the former, you'll already
have some way of determining the mailmerge record range. If it's the latter, you'll need to build an interface to capture the merge
record range. In either case, the date can be obtained from the OS.

There's plenty of code about for automating Excel from Word, or vice-versa, depending on your preferences.

--
Cheers
macropod
[MVP - Microsoft Word]

I'm using excel file one as the data file for a mail merge.

I need to capture the range of records that is being merged, and at
some point afterwards, open excel file two, copy the range of records
that was merged from file one to file two, and add in the current date
so that I have a record of when the merge was done.

Thank you in advance for any help- Hide quoted text -

- Show quoted text -

 

[macropod]

Hi Dudely,

Depending on how much detail you want, try something based on:

Sub Test()
MsgBox Date & vbCrLf & Time & vbCrLf & Now
End Sub

--
Cheers
macropod
[MVP - Microsoft Word]


Just standard mail merge.

I know how to get the date, I was just trying to be complete.

Thank you

Hi Dudely,

Are you using vba to drive the merge? Or just the standard mailmerge facilities built into Word? If it's the former, you'll
already
have some way of determining the mailmerge record range. If it's the latter, you'll need to build an interface to capture the
merge
record range. In either case, the date can be obtained from the OS.

There's plenty of code about for automating Excel from Word, or vice-versa, depending on your preferences.

--
Cheers
macropod
[MVP - Microsoft Word]

I'm using excel file one as the data file for a mail merge.

I need to capture the range of records that is being merged, and at
some point afterwards, open excel file two, copy the range of records
that was merged from file one to file two, and add in the current date
so that I have a record of when the merge was done.

Thank you in advance for any help- Hide quoted text -

- Show quoted text -