AndyTampa
Board Regular
- Joined
- Aug 14, 2011
- Messages
- 199
- Office Version
- 365
- 2016
- Platform
- Windows
I've searched the forum but can only find references to sending workbooks as email attachments in Outlook. What I want to do is the opposite.
I have to create reports from other reports that I receive in email. Those source reports are generated by a proprietary application overnight after the day is over. It sends the reports as file attachments. The subject lines of the emails are always the same except that the number of results found is appended to it. I take these reports (.csv files), open them in Excel, generate Pivot tables, and make new reports from them. I'm trying to automate as much of this as possible with macros.
I have several ideas but I don't know if they are feasible. I'm not asking for someone to write the macros for me. I just need to know what is possible before I waste alot of time on something that's impossible.
1) Can an Excel macro open Outlook, look in a particular folder of my inbox, find emails with a subject line where the first x characters match a particular string of text, and open the attachment before continuing on?
2) Can an Excel macro instruct the user what steps to take while it pauses and waits for a particular keystroke or sequence to continue?
3) Can an Outlook macro open an attachment into Excel and then call the Excel macro to begin? (This way is not ideal since my Daily report uses 4 emailed reports plus a PDF report.)
4) Does anyone know of a way to import the data from a PDF file to Excel?
Of course, any tips or ideas you can provide would be appreciated.
I have to create reports from other reports that I receive in email. Those source reports are generated by a proprietary application overnight after the day is over. It sends the reports as file attachments. The subject lines of the emails are always the same except that the number of results found is appended to it. I take these reports (.csv files), open them in Excel, generate Pivot tables, and make new reports from them. I'm trying to automate as much of this as possible with macros.
I have several ideas but I don't know if they are feasible. I'm not asking for someone to write the macros for me. I just need to know what is possible before I waste alot of time on something that's impossible.
1) Can an Excel macro open Outlook, look in a particular folder of my inbox, find emails with a subject line where the first x characters match a particular string of text, and open the attachment before continuing on?
2) Can an Excel macro instruct the user what steps to take while it pauses and waits for a particular keystroke or sequence to continue?
3) Can an Outlook macro open an attachment into Excel and then call the Excel macro to begin? (This way is not ideal since my Daily report uses 4 emailed reports plus a PDF report.)
4) Does anyone know of a way to import the data from a PDF file to Excel?
Of course, any tips or ideas you can provide would be appreciated.