Anyway To Export Email To Folder Including Attachments?

I have a system I have created overtime that puts email data onto an Excel spreadsheet. This is great but what I would also like to do after this has run is extract the emails including any attachments from Outlook into a new folder on my Windows PC.

When the email is on the Excel spreadsheet, and then the email and attachments are extracted to a folder on my PC I would like a unique ID (maybe the date of the email, or just a random number) to be added to the email which will then auto send a link address back to the spreadsheet beside the email that has been extracted and also add the unique ID to the spreadsheet. Sounds a bit confusing and I hope this makes sense (Is this possible?)

People will reply to the emails, and I would also like the reply emails to an original one (that should have the unique ID listed above) uses the same ID it gave the original email. Again sorry if this sounds confusing, happy to go into more detail if need be.

Kind of new to stuff like this so any help would be great.


Here is the code I have written so far;

Please Login or Register  to view this content.

Please Login or Register  to view this content.

http://www.excelforum.com/excel-prog...-a-folder.html