Hi all,
Is it possible to select a specific printer profile using VBA or a macro? I send an Excel file by email to multiple users, I would like to print the returns Duplex and stapled. Have done the code, but some returns have the correct profile saved, others go to Default Settings. I have at the moment the Printer Dialog box open automatically so I can manually select the correct Profile, but it would be better automatically.
Thanks for any help or suggestion.
Dan

Excel 2010
Network Printer - Canon