why not use the print dialog and allow selection

application.dialogs(xlDialogPrint).Show

--
HTH

Bob Phillips

"Gixxer_J_97" wrote in message
...
hi all,

i have a project that will be using two different printers when printing
documents. one will handle envelopes and the other printer will handle
everything else.

my problem is that the printers are not 'named' the same

ie on computer 1 the printer for envelopes is named:
\\server\printer name 1 on Ne03:

on computer 2 it is
\\server\printer name 1 on Ne02:

how can i code my printout sub so that it will use the correct name?

(i haven't tried yet but can i set activeprinter = \\server\sharename ?)

tia

J