Excel Attachment in Outlook

[Mister H]

Hi:

First off my apologies if I should not be posting this here.

I am trying to find out if it is possible to run a macro in Outlook that will print the sheet titled Journal in the attached Excel file.

I am trying to make someone's job easier. Currently they receive emails with an Excel spreadsheet attached. They open the email and then select the sheet titled Journal, print it and then close the email. The only reason they open the email is to print the sheet titled Journal.

I was thinking that it might be possible to select a folder in Outlook and print the sheet titled Journal for each email with in that folder.

Any redirection to posts in any forum would be appreciated. I tried Googling it but could not pinpoint the solution. I guess my serach criteria is too vague and it brings back a lot of deadends.

SO, I thought I would turn to the Excel Experts of the World.

Is the above doable

THANKS for any assistance or redirection you can offer,
Take Care,
Mark

 

[Tom Urtis]

If it were me, I'd write the macro in the Excel workbook, not as a macro in Outlook, whereby the act of opening the file prompts a message question, asking if you want to print the Journal sheet. You could click Yes or No. That way, users who just open that file for the purpose of printing the sheet get what they want by clicking Yes, and users who don't want anything printed get what they want by clicking No. My 2 cents anyway.

 

[Mister H]

PRINT Excel Attachment in Outlook

THANKS for the input Tom. That would save a bit of time but the user would still have to click Yes after opening each file. The person I am trying to help needs to open up about 50 to 75 files a day. Once they print the Journal they need to verify that it is correct then they reopen the file and upload the Journal information to another system. I of course did not mention that in my first post. Sorry.

I thought I saw something somewhere (a long time ago) where Outlook would print the attachments within a folder in Outlook. I just can't seem to find that code. I have never used VBA in Outlook before but I am hoping that it can be manipulated like the VBA for Excel. I will keep looking around for that code but so far, no luck...

Again THANKS for your suggestion Tom.

Take Care,
Mark