I need to open the spreadsheet, save as a file on my hard drive, set a print
range, reduce the font, print and exit the file. This is not obviously
rocket science and it has worked sometimes but I want it to work after I open
the attachment which I get a least once or twice a day and doing the same
thing is redundant. Thanks

"Jarek Kujawa" wrote:

what is this macro supposed to do?
what are you trying to accomplish?
pls provide more details as your explanations are vague

On 23 Kwi, 14:53, lschuh wrote:
I am trying to create a macro that will run after I open the attachment from
an email received in outlook. I don't know where to save the macro to as my
personal.xls is quite full of macros already. I tried to run it in "this
workbook" but can't seem to find it. Can you help?