The most important first step is to state what your goal is, because
there appear to be multiple ways to do what you want. Saying you want
to dump emails into a text file is limiting your goal to just one
particular solution.

There are also some details missing. You want to place the text of the
email into Excel, just the Body? What about the headers? Do they all
need to be in one row or column?

There's a tip here that might get you started.

http://www.exceltip.com/st/Log_files...Excel/467.html

It would be simple to loop through a folder in Outlook, assign the
Body of each email to a string, and then write the string to a text
file using the macro code in that link.

HTH,
JP

On Sep 11, 2:57*pm, Rob wrote:
Hi,

I need to dump emails in a specific folder into a text file. I get about
10-20 of these emails per day. *

I will then use VBA code to handle the text file and import the data into
excel. *I just don't know how to handle the messages in outlook. *How would I
write this code?

Thanks,