I'm looking for free software that will allow me to import all my e-mail addresses in one field from my database. If it can be done automatically, then even better. I want to be able to send e-mail to everyone in my email address field. Can Outlook do anything like this? If anybody knows of a way, I'd be all ears. Thanks a bunch.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Email address update 1
- Thread starter DrDan1
- Start date
-
1
- #2
Gotta give a bit of an explanation, do you mean CF? Is it a column of the db, is the email address the only value of the column?
Gotta know stuff like this.. ALFII.com
---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.
Gotta know stuff like this.. ALFII.com
---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.
- Thread starter
- #3
Sorry. Yeah, I'm using CF. It is a column in my database and the email addy is the only value in the column. I'm using Access 2000, although I might change to MySQL.
I'm looking for any way to accomplish this. I'm new this sort of thing. All I've ever really done is work with Access. Now with trying to put the data on the web, it's a whole new ballgame.
Was wondering if I maybe need mass mailer software or something and have CF update it. If it can't be done using CF... well I'll consider anything. As long as it's cheap or preferably free.
Thanks
I'm looking for any way to accomplish this. I'm new this sort of thing. All I've ever really done is work with Access. Now with trying to put the data on the web, it's a whole new ballgame.
Was wondering if I maybe need mass mailer software or something and have CF update it. If it can't be done using CF... well I'll consider anything. As long as it's cheap or preferably free.
Thanks
Code:
<CFQUERY name="getEmails" datasource="#request.dsn#">
SELECT * FROM EmailTable
</CFQUERY>
<CFMAIL query="GetEmails" to="#emailAddress#" from="#myAddress#" subject="Hey Dan, how ya doing?" server="smtp.server.com">Contents Here</CFMAIL>---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.
Don't know.. but google searches of:
"cfmail is limited"
"cfmail can only"
"cfmail can't"
"cfmail" "send over"
surely one of these would have hit it and all returned no results..
One method might be to group ten or so at a time.. you could do this by adding up a running variable like...
<CFSET cnt="">
<CFOUTPUT query="getEmails">
<CFSET cnt=listappend(cnt,EmailAddress)>
<CFIF listlen(cnt) eq 10>
...sendmail code... use #cnt# as the to email
<CFSET cnt=0>
</CFIF>
</CFIF>
<CFIF cnt neq 0>...sendmail code one more time using cnt as to the to value again because the number of email addresses was not divisible by ten for the last set.....</CFIF>
ALFII.com
---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.
"cfmail is limited"
"cfmail can only"
"cfmail can't"
"cfmail" "send over"
surely one of these would have hit it and all returned no results..
One method might be to group ten or so at a time.. you could do this by adding up a running variable like...
<CFSET cnt="">
<CFOUTPUT query="getEmails">
<CFSET cnt=listappend(cnt,EmailAddress)>
<CFIF listlen(cnt) eq 10>
...sendmail code... use #cnt# as the to email
<CFSET cnt=0>
</CFIF>
</CFIF>
<CFIF cnt neq 0>...sendmail code one more time using cnt as to the to value again because the number of email addresses was not divisible by ten for the last set.....</CFIF>
ALFII.com
---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.
- Status