Word Automation printing question

[Bikini Browser]

Hello and thank you for reading my question... I'm not a programmer. I am
only doing the research for my team.

I have a MS Access 2003 application....

Step 1: I am merging data from MS Access to Word, and this is fully
automatted. It works fine.

Step 2: I want to automaticaly print that final merged document to a
specified printer (not the default printer) without any print preview of any
kind. (I don't know how to do this step.)

In other words...
From the MS Access application, click one button and the merge happens, then
I want it to print the merged document to a specified Printer.

I don't know how to do that.

Does any one have a KB Artical with sample code to help me with my
requirements?

Thanks in advance....
Dale in San Juan Puerto Rico.

 

[Alex Ivanov]

doc.Application.ActivePrinter = "HP LaserJet IIISi on \\printers\laser"
doc.printout

 

[Doug Robbins - Word MVP]

See the article "Changing the selected (current) printer in Word without
changing the system default printer" at:

http://www.word.mvps.org/FAQs/MacrosVBA/ChangeCurPrinter.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP