At work a network printer is the default destination, which I have set up to
default to print 2-sided to a Store destination, mailbox 3 on the printer.
Documents I create print just fine, but I get many from others at work that I
have to manually change to print that way. I want to do this with just a
click of a button on my Excel menu bar (once I have the macro, that is no
problem).

I can't figure out how to do via a macro what I do manually through Print
Preferences set the destination to Store and choose Mailbox 3 if that is
not already chosen, select 2-sided printing, if not already, then return to
the Print box where I will manually choose the number of copies and hit OK to
print.

I can't find or figure out if there are Excel VBA commands for this, and
Sendkeys only gets me part way there. At 20 or more times a day doing this
manually, any programming help would be greatly appreciated.

You may want to add a printer (different name) using the same printer but
with a different setup

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AZSteve" wrote in message
...
At work a network printer is the default destination, which I have set up
to
default to print 2-sided to a Store destination, mailbox 3 on the printer.
Documents I create print just fine, but I get many from others at work
that I
have to manually change to print that way. I want to do this with just a
click of a button on my Excel menu bar (once I have the macro, that is no
problem).

I can't figure out how to do via a macro what I do manually through Print
Preferences set the destination to Store and choose Mailbox 3 if that is
not already chosen, select 2-sided printing, if not already, then return
to
the Print box where I will manually choose the number of copies and hit OK
to
print.

I can't find or figure out if there are Excel VBA commands for this, and
Sendkeys only gets me part way there. At 20 or more times a day doing
this
manually, any programming help would be greatly appreciated.

My default printer already has everything I want. It's just that when I get
documents from others, it uses their print setup instead of mine.

I have also run into this problem when I set up applications for others to
use. If I don't first change my printer setup to be more generic (print
instead of sending to my printer mailbox), when they use it and print it will
go to my mailbox instead of using their default setup.

"Don Guillett" wrote:

You may want to add a printer (different name) using the same printer but
with a different setup

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"AZSteve" wrote in message
...
At work a network printer is the default destination, which I have set up
to
default to print 2-sided to a Store destination, mailbox 3 on the printer.
Documents I create print just fine, but I get many from others at work
that I
have to manually change to print that way. I want to do this with just a
click of a button on my Excel menu bar (once I have the macro, that is no
problem).

I can't figure out how to do via a macro what I do manually through Print
Preferences set the destination to Store and choose Mailbox 3 if that is
not already chosen, select 2-sided printing, if not already, then return
to
the Print box where I will manually choose the number of copies and hit OK
to
print.

I can't find or figure out if there are Excel VBA commands for this, and
Sendkeys only gets me part way there. At 20 or more times a day doing
this
manually, any programming help would be greatly appreciated.

.