Word 2003 - setting default Merge options

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Candace - 19 Jul 2007 13:58 GMT

When I click on the "Merge to New Document" button on the mail merge toolbar,
I get a dialog box asking whether I want to merge "All", "Current record",
etc. Is there anyway to set it up so that it automatically merges "All"
without prompting me?

Reply to this Message

Doug Robbins - Word MVP - 22 Jul 2007 08:15 GMT

Create the following macro in the Normal.dot template, or better in a
template that you save in the Word Startup folder so that it is loaded as an
addin

Sub MailMergeToDoc()

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

End Sub

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

> When I click on the "Merge to New Document" button on the mail merge
> toolbar,
> I get a dialog box asking whether I want to merge "All", "Current record",
> etc. Is there anyway to set it up so that it automatically merges "All"
> without prompting me?

Reply to this Message

Candace - 23 Jul 2007 10:52 GMT

This sounds like a great solution, but I'm unfamiliar with the process.
Do I need to use "Visual Basic editor" (on the "Macro" dropdown) to
accomplish this?
Where does it give me the option to choose the "Word Startup folder"?
If the instructions to create a macro in a template are too detailed, is
there a KB article that I can refer to?

> Create the following macro in the Normal.dot template, or better in a
> template that you save in the Word Startup folder so that it is loaded as an
[quoted text clipped - 14 lines]
> > etc. Is there anyway to set it up so that it automatically merges "All"
> > without prompting me?

Reply to this Message

Doug Robbins - Word MVP - 23 Jul 2007 11:27 GMT

See the article "What do I do with macros sent to me by other newsgroup
readers to help me out?" at:

http://www.word.mvps.org/FAQs/MacrosVBA/CreateAMacro.htm

You can check the location of the Word Startup folder by selecting Options
from the Tools menu and then going to the File Locations tab.

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

> This sounds like a great solution, but I'm unfamiliar with the process.
> Do I need to use "Visual Basic editor" (on the "Macro" dropdown) to
[quoted text clipped - 23 lines]
>> > etc. Is there anyway to set it up so that it automatically merges "All"
>> > without prompting me?

Reply to this Message