Mail Merge Recipient List

[Mark]

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

 

[Doug Robbins]

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.

--
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

 

[Mark]

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

 

[Peter Jamieson]

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