Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 04-16-2014, 05:38 AM
macropod's Avatar
macropod macropod is offline Mailmerge printing with field names Windows 7 32bit Mailmerge printing with field names Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 



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 07:25 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