POP3 message body text to database

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
mpopkin
Newbie
Posts: 15
Joined: Wed Dec 17, 2008 5:56 pm

POP3 message body text to database

Post by mpopkin » Mon Apr 11, 2011 6:40 pm

Hi All,

I was wondering if anyone else might have some pointers as how to extract the plain message body text. I need to write it into an MDB database memo field downstream.

I'm using RetrievePOP3 to get the messages out, but there doesn't look to be a consistent place to pick up the message body. The BODY sections only show up sporadically depending on the source message layout/content.

I'm thinking of perhaps parsing it out of the full message somehow, but there aren't a lot of good resources for doing this.

Any thoughts?

Thanks!

User avatar
JRL
Automation Wizard
Posts: 3526
Joined: Mon Jan 10, 2005 6:22 pm
Location: Iowa

Post by JRL » Mon Apr 11, 2011 7:22 pm

See http://en.wikipedia.org/wiki/MIME
There might be an easy way but if your emails are coming from various sources... I will be surprised.

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts