Yes, you can use the CFPOP and get the mail message and database
the subject, from, to, message.
Using the query name for the CFPOP tag, then have it POP a particular
message.
<cfpop action="GETALL" name="get_mail" messagenumber="1404"
server="my.pop3.com" username="myname" password="mypass">
So then you can use the query and database it:
<cfquery name="ins_mail" datasource="mydatasource">
Insert into
tblMail(Mail_from,Mail_to,Mail_Subject_Mail_Message_ID,Mail_Message)
Values=('#get_mail.from#','#get_mail.to#','#get_mail.subject#',#get_mail.mes
sagenumber#,'#get_mail.body#')
</cfquery>
This is in fact if the CFPOP returns a mail message from messagenumber=1404.
If you are getting ALL messages, wrap the CFQUERY around with <CFLOOP
Query="get_mail"> </CFLOOP>
HTH
----- Original Message -----
From: "Claremont, Timothy S" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 28, 2000 12:08 PM
Subject: Mail / Database Integration
: I've been wondering if e-mail sent to a specific account could have its
text
: entered automatically into a database? For example, subject gets stripped
: and loaded in a SUBJECT field; text between the keywords SUMMARY and
: SUMMARY END gets loaded into a SUMMARY field , etc.
:
: Got any thoughts to point me in the right directions?
:
: --------------------------------------------
: Tim Claremont
: Xerox Corporation
: --------------------------------------------
: --------------------------------------------------------------------------
----
: Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
: To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
