Macro to select a non-default printer

[Madge]

I have used the 'record a macro' facility to select a non-default printer and
print the document on screen created Word (Office XP). However, when I view
the code, there is nothing in there relating to the printer selection. Can
anyone tell me how to do this please?

 

[Jay Freedman]

I have used the 'record a macro' facility to select a non-default
printer and print the document on screen created Word (Office XP).
However, when I view the code, there is nothing in there relating to
the printer selection. Can anyone tell me how to do this please?

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

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Madge]

Sorry, I've found the answer to this - in part at least - on another post
which I hadn't found in my first trawl. However, if I've printed on my
non-default printer and then want to print the next document on my default
printer, do I have to use another, identical, macro to switch back, as the
non-default printer stays 'selected' until I exit Word otherwise?

 

[Madge]

Thanks Jay, but please see my second post in this thread - which this
document doesn't answer.

 

[Jay Freedman]

Yes, that would be necessary.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all
may benefit.

 

[Doug Robbins - Word MVP]

You could combine it all into the one macro that selected the printer that
you want to be used for the document, printed out the document and then
changed the printer back to the default printer.

--
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

 

[Graham Mayor]

See http://www.gmayor.com/fax_from_word.htm which explains how to do this.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Madge]

Thank you to all who responded. I have used Graham's code as it is short and
sweet and missed out all the additional stuff which the 'record a new macro'
button incorporates!