Extract CSV files from messages

[RichardSchollar]

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

 

[Brian Tillman]

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

 

[RichardSchollar]

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

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

I found code I can adapt to my needs here:

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

and use a DOS command to consolidate the files.

Thanks for the suggestion though!

Richard