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.