Mail Merge Recipient List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark - 05 Apr 2005 13:25 GMT

How do I retrieve the list of recipients from a mail merge?

Reply to this Message

Doug Robbins - 05 Apr 2005 18:23 GMT

Use the same datasource to create a Directory type mailmerge in the
mailmerge main document of which, you have each of the field names in the
cell of a one row table with nothing else in the document. When you execute
that mailmerge to a new document, it will contain a table with a row
containing the data for each recipient.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> How do I retrieve the list of recipients from a mail merge?

Reply to this Message

Mark - 05 Apr 2005 18:49 GMT

What if you don't know what original datasource was?

> Use the same datasource to create a Directory type mailmerge in the
> mailmerge main document of which, you have each of the field names in the
[quoted text clipped - 3 lines]
>
> > How do I retrieve the list of recipients from a mail merge?

Reply to this Message

Peter Jamieson - 06 Apr 2005 10:12 GMT

If you open the existing merge document, then use Save As to save it under a
different name, you should be able to change the merge document type to
directory (e.g. using the Mailmerge toolbar) without disconnecting the data
source, in which case you do not need to know what the data source is,
although it obviously still needs to be there.

Other ways to discover the name of the data source (some may not work in
Word 2002 and may even crash it):
a. drag Tools|Customize|category All Commands|command MailMergeHelper to a
toolbar and use it
b. open the VBA editor and execute the following command in the Immediate
pane

print ActiveDocument.MailMerge.DataSource.Name

c. use File|Save As to save your document as a Web page, then open the HTML
file as a text file and look for the block of mailmerge-related information
that should be near the top.
d. Look in Word Help|About|"System Info..."|"Office 2003
Applications"|"Microsoft Office Word 2003"|"Mail Merge" (this can be slow,
though.)

Peter Jamieson

> What if you don't know what original datasource was?
>
[quoted text clipped - 6 lines]
>>
>> > How do I retrieve the list of recipients from a mail merge?

Reply to this Message