Recorded Macro to Print Merge to Printer Requires SendKeys

• Microsoft Word for Windows, versions 1.0, 1.1, 1.1a, 2.0, 2.0a, 2.0a-CD, 2.0b, 2.0c, 6.0, 6.0a, 6.0c
• Microsoft Word for Windows 95, versions 7.0, 7.0a
• Microsoft Word 97 for Windows

SUMMARY

In order to use a macro to send a merged a document directly to the printer, the macro must include the SendKeys macro command. Without the SendKeys macro command, the Print dialog box remains on the screen.

MORE INFORMATION

Visual Basic for Applications

Add a SendKeys statement to send the {enter} key to the Print dialog box. The SendKeys statement should precede the Mail Merge statements, as in the following Visual Basic for Applications example;

   Sub MergeAndPrint()
      SendKeys "{enter}"
      With ActiveDocument.MailMerge
         .Destination = wdSendToPrinter
         .Execute
      End With
   End Sub

   Sub MergeToDocAndPrint()
      With ActiveDocument.MailMerge
         .Destination = wdSendToNewDocument
         .Execute
      End With
      ActiveDocument.PrintOut
   End Sub

WordBasic

Word 6.x, 7.x:

Add a SendKeys statement to send the {enter} key to the Print dialog box. The SendKeys statement should precede the MailMergeToPrinter statement as in the following example.

   Sub MAIN
      SendKeys "{enter}"
      MailMergeToPrinter
   End Sub

   Sub MAIN
      MailMergeToDoc
      FilePrint
      FileClose 2
   End Sub

If a macro is recorded to merge a document to the printer, the macro has the following commands (there may be different values for the parameters, depending on your choices in the dialog boxes):

   Sub MAIN
      FilePrintMerge .MERGERECORDS = 0, .From = "", \
      .To = "", .PRINT
      FilePrint .Type = 0, .NumCopies = "1", .Range = 0,\
      .From = "", .To = "", .Reverse = 0, .Draft = 0,\
      .UpdateFields = 0, .PaperFeed = 8, .Summary = 0, \
      .Annotations = 0, .ShowHidden = 0, .ShowCodes = 0,\
      .FileName = ""
   End Sub

For the macro to work correctly, the following command must be inserted before the FilePrintMerge command:

   SendKeys "{enter}", -1

If you want to print more than one copy of your merged document, use the following SendKeys command to modify the Copies box in the Print dialog box:

   SendKeys "N{ENTER}", -1

REFERENCES

"Microsoft Word for Windows Technical Reference," pages 88-90 "Microsoft Word for Windows and OS/2 Technical Reference," pages 251-253

Kbcategory: kbusage kbmacro KBSubcategory: kbmerge