Making a Word mailmerge template merge when it opens.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dixie - 18 Aug 2006 00:20 GMT

I have a lot of mailmerge templates which merge to data in a small tab
delimited text file on the local drive. When these documents open, I seem
to have to click a button to make them merge with the data in the file.

Is there some simple code I can add to the documents that will make them
merge automatically without the button press?

dixie

Reply to this Message

Dixie - 18 Aug 2006 00:27 GMT

By that, I mean that when I open the document, I want it to look like it
does when you click the <<ABC>> View merged data button and the fields are
filled with the merged data.

Surely there is some simple code that can be put into the document to make
the merge happen automatically?

dixie

>I have a lot of mailmerge templates which merge to data in a small tab
>delimited text file on the local drive. When these documents open, I seem
[quoted text clipped - 4 lines]
>
> dixie

Reply to this Message

Doug Robbins - Word MVP - 18 Aug 2006 04:43 GMT

Using the following code in an autonew macro in the template will cause the
merge to be executed to a new document

With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.Execute
End With

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

> By that, I mean that when I open the document, I want it to look like it
> does when you click the <<ABC>> View merged data button and the fields are
[quoted text clipped - 13 lines]
>>
>> dixie

Reply to this Message

Dixie - 18 Aug 2006 04:56 GMT

I'm not used to programming Word. How do I create an autonew macro and when
does it run?

dixie

> Using the following code in an autonew macro in the template will cause
> the merge to be executed to a new document
[quoted text clipped - 22 lines]
>>>
>>> dixie

Reply to this Message

Graham Mayor - 18 Aug 2006 06:27 GMT

You call the macro Autonew and save it *IN THE DOCUMENT TEMPLATE* not
normal.dot
http://www.gmayor.com/installing_macro.htm It runs when you create a new
document.

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I'm not used to programming Word. How do I create an autonew macro
> and when does it run?
[quoted text clipped - 35 lines]
>>>>
>>>> dixie

Reply to this Message