ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel opening outlook emails (https://www.excelbanter.com/excel-programming/374384-excel-opening-outlook-emails.html)

Lime

Excel opening outlook emails
 
Hello,
Is it possible to create a macro in excel to open all the emails in a
certain outlook folder (all which have Excel attachments) and have the macro
copy the second row of every workbook attachment to a Master excel sheet? If
so can someone please start me off with some code?

Any and all help is appreciated

Thanks,
Lime

Ron de Bruin

Excel opening outlook emails
 
Hi Lime

See Dick's site for a example
http://www.dicks-clicks.com/excel/olRetrieving.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Lime" wrote in message ...
Hello,
Is it possible to create a macro in excel to open all the emails in a
certain outlook folder (all which have Excel attachments) and have the macro
copy the second row of every workbook attachment to a Master excel sheet? If
so can someone please start me off with some code?

Any and all help is appreciated

Thanks,
Lime





All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com