cfpop returns a query object which can be looped through to get each email, which is contained within a single row. Do a test on the email and look at body, textbody, and htmlbody to see which you want. Once you know what you want to send to the DB, just loop over the query and run a cfquery to insert as normal.
On Tue, Mar 17, 2009 at 12:45 PM, Jason Congerton < ja...@jasoncongerton.co.uk> wrote: > > Hi > > I have had look via google and found no answers, has anybody ever needed to > read the contents of an email and enter them into a database. > > The subject line will contain a unique identifier and emails will be fired > into a single account. > > I need to get the body contents and enter them into a database aginst the > unique id in the subject line. > > I know i will need cfpop to read the mail, just not sure how to access the > contents. > > Many thanks > > Jason > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320579 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
