Solved: Help with Automating Mail Merge

[TCMills]

I am an extreme newbie on Office Products. I am using Word2003 with a txt file for the mailmerge datasource.

I have tried to step through the
Automating Mail Merge KB article - ran into the SQLSecurityCheck issue, and fixed that.

When I open the word document after saving the macros, nothing happens. The file looks just like it looked when I saved it before adding the macros.

Here is the file that I am using for testing....

July 27, 2005



?Salutations? ?Title? ?LastName?,



Thanks for the $?DonationAmount?.

------------------------------------

The variables above all appear in my merge txt file.

Thank you in advance for any help that you may be able to give me.

Teresa

[MOS MASTER]

Hi and welcome to vbax!

Ok you are not telling exactly what you have done...
So I'm going to try to tell how I think you should have done things to get the automation done. (From the top so I could miss out on stuff)

• First Open Word
• Go to Tools | Macro | Security
• Second Tab set securtiy to medium!! (Important)
• Now open your mailmerge document.
• Can you do a manual mailmerge? Answer yes? Great your up for the code. Answer No? Wel attach your database (Txtfile) to the document and try out things manually first. All Ok? let's proceed.
• Now Open the editor Press ALT+F11
• You should see the project explorer on your left. Not? (Press CTRL+R)
• Now click on the + sign next to the project that has the same name as your document: eg Project mailmerge
• The Word objects will unfold.
• Double click on Class Module ThisDocument
• Paste this code in the code pane: (Can't see the pane? Press F7)

[VBA]Option Explicit
Private Sub Document_Open()
DoMailMerge
End Sub
Public Sub DoMailMerge()
Dim DocName$
DocName = ActiveDocument.Name
'Do mailmerge
With ActiveDocument.MailMerge
.Destination = wdSendToNewDocument
.Execute
End With
'Close mailmerge document
Windows(DocName).Close wdDoNotSaveChanges
End Sub

[/VBA]

• Now Close the editor and save the document.
• Close this document and reopen it Choose yes when asked to activate Macro's
• By now you should see a newly created document with the merge data in it.

Btw..the code closes the mailmerge document after it has created a new merge document.

That should be it with the information given.

HTH,

[TCMills]

Thank you - the security setting fixed the problem

Go to Tools | Macro | Security
Second Tab set securtiy to medium!! (Important)
It works like a charm now.

[MOS MASTER]

Hi Teresa,

Excellent...you're welcome!