View Single Post
 
Old 04-16-2014, 07:02 AM
Jvallee Jvallee is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Apr 2014
Posts: 5
Jvallee is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
OK, the issue you're having has nothing to do with mailmerge, but with the macro in your mailmerge main document.

The first executable line in your macro is:
Dialogs(wdDialogFilePrint).Show
Unless you cancel out of that, it prints your mailmerge main document. That explains why you're getting a file with the fieldnames being printed. In any event, you don't need that line, because the rest of the macro sends the actual mailmerge output to the printer.

Finally, given that you're using a macro to drive the process, there's no need for your mailmerge main document to be anything other than a normal document (i.e. one that wouldn't give the SQL prompt when you open it).
I need to be able to ask the user which printer they want to use.. that is why I added the printer dialog.
The macro that merges just has sendtoprinter and I do not know how to specify their choice.
I'm not sure why you think this should be a normal doc. If I don't attach a data file, how will the doc know what the field names are?
Reply With Quote