By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,711 Members | 2,158 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,711 IT Pros & Developers. It's quick & easy.

Mail Merge From Access To Word Using Specific Printer and Papertray

P: n/a
This code, opens a mail merge and prints to my default printer.

How can I modify this code to print to a specific printer on the
network and a particular printer tray?

Dim WordObj As Word.Document
Set WordObj = GetObject("C:\MyMerge.doc")

WordObj.MailMerge.Destination = wdSendToNewDocument

WordObj.MailMerge.Execute
WordObj.Application.Options.PrintBackground = False
WordObj.Application.ActiveDocument.PrintOut
WordObj.Application.Quit wdDoNotSaveChanges
Set WordObj = Nothing

Thank you,
Brian

Apr 19 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
There's an article on AccessWeb about this:

http://www.mvps.org/access/reports/rpt0009.htm

Apr 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.