Hi I got it to work finally, for those of you who are interested:
<CFQUERY NAME="GetEmail" DATASOURCE="jgrn123" USERNAME="jgrn123" DBTYPE="ODBC"
PASSWORD="">
SELECT Email
FROM list
</CFQUERY>
<CFMAIL QUERY="GetEmail"
FROM="[EMAIL PROTECTED]"
TO= "#Email#"
SUBJECT="Newsletter"
>
#Form.Experience#
Thank you for subscribing to our newsletter!
</CFMAIL>
<h1>Your Newsletter has been sent out!</h1>
<br><br>
<a href="newsletter.htm"><FONT SIZE="4">BACK TO Newsletter page</A></FONT><BR><BR>
Jeff Beer <[EMAIL PROTECTED]> wrote:A couple things to look at:
1. Is your e-mail server actually at www.juliagreen.com? Usually it
would be mail.something.com, etc.
2. You are using a FROM address with a different domain than the mail
server you specified in the SERVER attribute. Usually, the FROM address
must exist on the mail server.
-----Original Message-----
From: Julia Green [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 05, 2003 7:54 PM
To: CF-Talk
Subject: Re: Multiple Emails -- HELP!!!!
I can't -- my ISP controls the ColdFusion. I tried just sending a form
with ColdFusion and it worked. Can someone just give me some
straightforward code? Hi everyone --
Yet another simple problem. I have a database filled with two emails,
and this
used to work, and now doesn't for some reason, and a form called
srchasp.htm
with a textbox called Experience. How do I get emails from the database
to
send anything I type in the textbox called Experience once I submit I
found this on
the web
and now I can't find it again. The emails just don't get there...
Julia Green
DBTYPE="ODBC" PASSWORD="">
SELECT Email, LastName
FROM list
Your Newsletter has been sent out!
BACK TO Newsletter
page
FROM= "[EMAIL PROTECTED]"
SUBJECT= "Newsletter"
SERVER="www.juliagreen.com"
>
Thank you for subscribing to our newsletter!
#Form.Experience#
Julia Computer Consulting
Web Design @ Reasonable Prices
Email: [EMAIL PROTECTED]
www.juliagreen.com
Phone: 617-926-3413
Cell: 617-596-6003
Fax: 1-617-812-8148
Jochem van Dieten wrote:Julia Green wrote:
> No it just goes to the newsletter sent screen.
Set the logging to a higher level in the CF Administrator and enable the
logging of sent messages. That way you should either get an entry in the
mailsent.log that the mail was succesfully sent, or an error in the
mail.log.
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
