Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Outlook E-mail to Excel

Status
Not open for further replies.

ptrifile

Technical User
Aug 10, 2004
457
US
I receive emails daily that contain copied spreadsheets from Excel into the body of the email. I would like to be able to select multiple emails and send the "spreadsheet(s)" to one excel file. Essentially taking multiple emails (body) into one excel file.

I have found some VBA code that works on single emails but nothing that will take multiple emails and put the spreadsheets from the body of the email into one excel file.

Any help at all is much appreciated!

Thank you,

Paul
 
Since you are talking VBA, you may have a better luck asking this question at forum707

Please, provide the code you have (for one e-mail) and I am sure someone could add a simple loop to deal with multiple e-mails.


---- Andy

There is a great need for a sarcasm font.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top