Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2014, 07:02 AM
Jvallee Jvallee is offline Mailmerge printing with field names Windows 7 64bit Mailmerge printing with field names Office 2013
Novice
Mailmerge printing with field names
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding names to sheet for printing WV8VFD Excel 4 12-01-2013 11:02 PM
Mailmerge printing with field names Yes/No field does not work in mailmerge Abacus1234 Mail Merge 10 10-14-2013 06:37 AM
Merge Word documents using a mailmerge field Concertina Mail Merge 3 02-18-2013 04:12 AM
Mailmerge printing with field names auto insert names from list for printing andreipopa2k Word 1 12-09-2011 01:51 PM
Printing document with style names Steve_D Word 0 12-10-2009 09:23 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft