Download Attachment from Email and extract Data

[DavidWaldo]

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]

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]

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]

I did just that , works like a charm.