Word Automation printing question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bikini Browser - 02 Jan 2006 06:54 GMT

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.

Reply to this Message

Alex Ivanov - 02 Jan 2006 07:27 GMT

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

Signature

Please reply to NG only. This email is not monitored.
Alex.

> Hello and thank you for reading my question... I'm not a programmer. I am
> only doing the research for my team.
[quoted text clipped - 19 lines]
> Thanks in advance....
> Dale in San Juan Puerto Rico.

Reply to this Message

Doug Robbins - Word MVP - 02 Jan 2006 07:47 GMT

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

Signature

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

Reply to this Message