Outlook Printer Macro

R

Rob F

Hi

At work I've got macros for Word and Excel, assigned to a
toolbar button, which change the default printer to a
different one (our colour printer), prints out whatever
I've got open, and then changes the default printer back
(to the monochrome one) again.

I'd like to be able to do this in Outlook too. For
example if I've got an email in my inbox highlighted I'd
like the macro to be able to print that on the colour
printer. But I can't seem to get it to work!

The existing macros I use are:
WORD...
ActivePrinter = " [PRINTER 2] "
Application.PrintOut
ActivePrinter = " [PRINTER 1] "

EXCEL...
Application.ActivePrinter = " [PRINTER 2] "
ActiveSheet.PrintOut
Application.ActivePrinter = " [PRINTER 1] "

Can anyone help, please?

Rob F
 
S

Sue Mosher [MVP]

Outlook does not provide any objects for controlling the printer. A possible workaround might be to save the message as a document (MailItem.SaveAs), then open that document in Word and use your Word macro.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
 
G

Guest

Thanks, Sue.

Seems strange that it can't be done but there we are!

I'll stick to CTRL+P and selecting the printer manually.

Cheers

Rob F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing and re-setting the default printer 2
Outlook 2003 and Macro 1
NetWork Printer Selection Problems 1
Excel 2010 print settings 1
Bargain Cheap Colour Laser Printer 5
Default Printer 1
Printing 2
Outlook macro help please 23

Top