Saving email bodies as text files in Hard Drive in Outlook

**Legacial** · 06-23-2011, 08:51 AM

Hi guys,
I'm fairly new to Outlook VBA programming so I'm in a bit of a fix. I've been trying to find a macro that can automatically save the emails in my inbox folder to another folder that i created on my hard drive named 'Documents\Outlook_Mail\Data' as text files so that I can import them into a database. I want to save the body part of the emails, not the attachments.
I scoured the net and found this macro but it keeps sending me the following error: "This folder doesn't exist". I guess problem is how I've set the object folder.

Please Login or Register  to view this content.

Could anyone assist me with this code? I would highly appreciate your assistance. Or if possible, help me with another piece of code that can function in the way specified. Thanks in advance

**Domski** · 06-23-2011, 09:10 AM

How about this?

Please Login or Register  to view this content.

Dom

**Legacial** · 06-24-2011, 04:04 AM

It works perfectly!! Thanks!!

Just one more question, I also wanted to place the files in monthly folders such that every file saved on the hard drive will go to that month's folder, e.g. files received today will go to the June_2011 folder. Do you know a way of doing this?

**Domski** · 06-24-2011, 04:39 AM

Try this:

Please Login or Register  to view this content.

It will also check if a folder exists for the month and create one if not.

Dom

**Legacial** · 06-24-2011, 05:56 AM

I'm sure the code works just fine but when I try running it it brings up a pop-up that says "Outlook cannot complete the save due to a file permission error".what might the problem be, because I have the required access to the mail in outlook.

**Domski** · 06-24-2011, 06:51 AM

Oops.

This:

Please Login or Register  to view this content.

should be:

Please Login or Register  to view this content.

Dom

**Legacial** · 06-24-2011, 08:25 AM

It works beautifully!! Thanks so much!!

**Domski** · 06-24-2011, 08:53 AM

Cool, if you are happy with the solution please mark the thread as solved.

f your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

Dom