PDA

View Full Version : [SOLVED] Download Attachment from Email and extract Data



DavidWaldo
03-22-2017, 01:27 AM
Hello again,
Yet, again I need help. In my newest project I need to extract data from email in outlook.
Every day i recieve an email from my busines partner - its and automated email with phone numbers & names and adresses. Email has a same name every day (***_date) and contains an excel sheet named a same way. Inside the sheet are the data i need to paste to my workbook. Now I do it manualy every day - but I would like to write an macro to do it.
What i do not know is how to call the outlook and open attached excel workbook, everything else (Timer, copying data etc. I know how to do).
Any help around?
Thanks very much.

DavidWaldo
03-22-2017, 01:41 AM
Or would it be better to write macro for Outlook to save the attachments to a file every time the email is recieved?? And excel workbook to just copy from those?

mdmackillop
03-22-2017, 11:38 AM
Would it be better to write macro for Outlook to save the attachments to a file every time the email is received?
I would go for this option.

DavidWaldo
03-23-2017, 03:17 AM
I did just that :D, works like a charm.