Extract CSV files from messages
 

On a daily basis I get sent anywhere from 10 to 40 emails each in a
completely standard format and each with a csv file attached. These
mails are directed to a separate mailbox within Outlook.

I would like to automate (via VBA) extracting and consolidating all
the CSV files into one central file from which I will do further
processing.

I am comfortable with VBA (but not at all using it in Outlook - I am
from an Excel background), but I have no idea how to start on this.
Even getting to the point where I can simply get all the required csv
files saved down to a central location (ie windows folder, for
example) would be a great help.

Can anyone assist?

Thanks for any replies!

Richard

Extract CSV files from messages
 

RichardSchollar wrote:

I would like to automate (via VBA) extracting and consolidating all
the CSV files into one central file from which I will do further
processing.

It might be cheaper in the long run to get an attachment-processing app.
See this:
http://www.slipstick.com/addins/attachments.asp
--
Brian Tillman [MVP-Outlook]

Extract CSV files from messages
 

On 18 Sep, 21:59, "Brian Tillman" wrote:
RichardSchollar wrote:
I would like to automate (via VBA) extracting and consolidating all
the CSV files into one central file from which I will do further
processing.

It might be cheaper in the long run to get an attachment-processing app.
See this:http://www.slipstick.com/addins/attachments.asp
--
Brian Tillman [MVP-Outlook]

Ah, but where would the fun be in that? ;-)

I found code I can adapt to my needs he

http://www.outlookcode.com/codedetail.aspx?id=70

and use a DOS command to consolidate the files.

Thanks for the suggestion though!

Richard