Default printer

brucemc · #1 06-10-2009, 05:04 PM

Is there a way to change the printer that MS Word 2007 uses from the system default? My main aim is to be able to have MS Word direct to a different printer when I am using it's Envelope creation when I am simply printing a #10 envelope (Mailings:Envelopes:Print), which would be even better to be able to specify, but I don't want to ask for too much...

shg · #2 06-10-2009, 05:30 PM

You mean via VBA? Maybe like this:

Code:

Dim sPrtr       As String

Sub SelEnvPrtr()
    sPrtr = Application.ActivePrinter
    Application.ActivePrinter = "my envelope printer"
End Sub

Sub SelDefPrtr()
    Application.ActivePrinter = sPrtr
End Sub

brucemc · #3 06-10-2009, 06:31 PM

I'm sorry if I posted in the wrong area/forum; I'm just looking for a regular use solution! Some setting in Word to over-ride the default WXP printer setting.

shg · #4 06-10-2009, 08:37 PM

No, where you posted was fine.

Just set it in the user interface when you go to Print, and the set it back to the default when you're done.

Welcome to the Excel Forum

Forum Statistics