Pull data from email text

**ghladik** · 10-03-2013, 04:23 PM

I am not sure if this is possible but we receive an email with chat message transcripts after each conversation has ended. I have about 2,000+ conversations I want to log the initial question in either Excel or Access. Does anyone have a good way of doing this? The initial question is located in the same location of every email message. The message comes in in two formats, the standard Outlook message format and an attached .txt file.

Any ideas would be appreciated.

I just need the part that immediately follows the: "Your Question:..."

See attached for sample.
ATT00001.txt

**alansidman** · 10-03-2013, 04:29 PM

Have you looked at External data on the ribbon and selecting outlook and then selecting the fields you wish to import/Link to either Access or Excel?

Alan

**ghladik** · 10-03-2013, 04:33 PM

I have not- just playing with it now and the problem I have is the content of what I am trying to pull is in the middle of the body of the message. I don't know VBA or any script.

**ghladik** · 10-03-2013, 04:34 PM

I found this link from a previous post that I think is after the same thing I am, only I want all of my "questions" in one spreadsheet.

(sorry it came from the other forum)
http://www.mrexcel.com/forum/excel-q...mail-body.html