I would like wordmerge program to print without stopping to show dialog box stating that it will merge with SQL... so and so file and then display the merged document and I have to press Printer icon to print it. Is it possible with wordmerge to have the task completely seamless, no stopping anywhere?

Yes, that is what I am looking for. Thanks Erika, for your suggestion and help.

Erika,
Where did I go wrong? It did not work. Let me confess, I do not know anything about VBA.  So most likely I might have missed some simple steps. Sorry but you will have to hold my hand on every step if I ever hope to get it to work.

Private Sub Document_Open()
Dim DSName As String

' Change this to use a different data file
DSName = "MergeData.txt"

    ActiveDocument.MailMerge.OpenDataSource "C:\Sesame2\Docs\" + DSName
    ActiveDocument.MailMerge.Destination = wdSendToPrinter
    ActiveDocument.MailMerge.Execute
    Application.Quit wdDoNotSaveChanges
   
End Sub

   1. Copy the code above.
   2. Open the document.
   3. Hit Alt+F11 to open the Visual Basic Editor (VBE).
   4. On the left, double-click the document you opened.
   5. Underneath it, double-click "ThisDocument".
   6. Paste the code into the window that appears at right.
   7. Hit the Save diskette on the toolbar and close the VBE.

Am I supposed to place anything in Word document, such as Document_Open ( )?
ActiveDocument.MailMerge.OpenDataSource "C:\Sesame2\Docs\" + DSName - Is this line is redundant as the document was saved with this mergedata information from the subject merge data file already specified when the word document was created?

When I open the document, I expected it to print automatically. Other question: If the document on open, prints and closes without saving, how can I ever edit it? You will have to forgive me to ask you stupid question like this but I do not know jack about this VBA business!!!

Thanks. When I open the document, first it gives the SQL merging warning since I did not change the Registry setting yet, and then it opens in the normal way with merged fields displayed properly but does not take the next step of printing and closing the document.

With Low Security setting it works fine. With Medium Security setting it works but gives one more dialog box to deal with - Enable or Disable Macro.

The following workaround was suggested to deal with the above Macro dialog box.  So far so good. Opening while pressing shift key disable the Macro as you suggested.  Still will have to deal with SQL warning! Appreciate all your help. Is there any method other than Registry modification? Just wondering.

Quote:


Thanks for all your help. When you have to print hundred of single document daily such interruptions in the form of warning and dialog box really become annoying at best.

Here's the link:
Using SelfCert to Create Digital Certificates in a Network Environment