VBA to read data from Outlook email attachment

[tod]

This seems impossible. However, I've thought that before only to have
someone show me how easy it is. Soooo....

I get an email each day with an Excel workbook attached. The workbook
contains data on the second worksheet that I copy and paste into my
own workbook. It's a pain to do this every day. I don't have much
control over the source or I would have them post it some place
instead of emailing it. Is there a way to have VBA open an email, open
the attachment, read the data, close the attacment and close the
email?

tod

 

[Shatin]

Maybe you'd find some useful info on this page:

http://www.fontstuff.com/outlook/oltut01.htm

 

[Kalle]

Activate Outlooklibrary and watch out for:

Outlook.MailItem.AttachmentRead

that will do the trick...

 

[Dick Kusleika]

tod

See here

http://www.dicks-clicks.com/excel/olAutomating.htm

and more specifically here

http://www.dicks-clicks.com/excel/olRetrieving.htm#Save Attachments

Once you have the attachment saved, you can open it and copy and paste all
through a macro.

 

[Ron de Bruin]

Hi Tod

If you mean Outlook Express instead of Outlook
(great two programs with almost the same name)

Then look on this site
http://www.oehelp.com/DBXtend/Default.aspx