Import CSV attachments from Outlook to single Excel workbook

[Kdburchette2]

Hello,

I have search far and wide to find a solution to this but was unable to. Maybe I am using the wrong keywords. If someone could point me in the right direction I would be truly grateful.

I am trying to create an Excel macro to import CSV attachments from multiple emails into a single worksheet for review.

The emails will be stored in a specific sub folder called "Entry Request". Each email has only one attached file

Each CSV file can have any number of roles and does not have headers.

I would also Like to include a way to save the single sheet as one CSV file so it can be imported into the system.

Thank you for any recourses you can point me to. I have googled this issue to death and have not found a solution.

 

[rlv01]

Opening or importing a CSV file is a common exercise and there are many threads here that discuss it. If you don't have much interest in coding it yourself, you might want to have a look at this:

https://www.rondebruin.nl/win/addins/rdbmerge.htm

 

[Kdburchette2]

Thank you for your response. I actually stumbled on that site myself today. I have been tweaking and mixing several things to achieve my end goal. So far so good but still more to go. Thanks.