someone point in the right place please

Hi

Hint - try recording a macro and change the printer.

It should look something like

Application.ActivePrinter = "\\BFMANSFIELD\Xerox Phaser 8200DP on Ne02:"


If you want to change the printer back in code then

Dim CurrentPrinter as string

CurrentPrinter=Application.ActivePrinter

Application.ActivePrinter = "\\BFMANSFIELD\Xerox Phaser 8200DP on Ne02:"


'DO YOUR PRINTING HEAR

Application.ActivePrinter=CurrentPrinter


or similar


MTB