How to automate a merge data into master merged document

[Caroline Williams]

How do I automate merged data to appear every time I open
the master merge document. For example, when I click on
the document I want all the merged data to appear
automatically instead of selecting merge to new document
every time. Is this possible?

Thanks in advance,
CVW

 

[Graham Mayor]

A merge has three parts
1 A data file
2 A template - your master merge document.
3. The merge itself.

*All* the merge data is only available when you complete the merge. If you
want access to that merged data merge to a new document then save the
document and refer to that.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[CAROLINE WILLIAMS]

Thanks, but do you know why I can't just open the open the master merge
file and have the data already merged automatically instead of always
selecting merge to new document. I have seen it where I have a master merge
file which I downloaded with the data and header info and I just open the
document and it auto merges the data into the document without selecting
merge to a new document. How can this be automated in that way?

Thanks in advance,
Caroline

 

[Doug Robbins - Word MVP]

To do that, you would have to save the mail merge main document as a
template and have an autonew macro in it that contained the following
commands:

With ActiveDocument.MailMerge
If .State = wdMainAndDataSource Then
.Destination = wdSenttoNewDocument
.Execute
End If
End With


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP