This topic is locked

Send Mass Email

7/16/2008 7:14:27 PM
ASPRunnerPro General questions
W
wisdom2009 author

Hi,
I would like to send mass emails using ASP and smtp server . i have a table where i saved the emails and names. what i would like is to create a form where i can write what i would like to send them in HTML format , when i click on send all the users on the table will receive emails including their name, per example will say Hi Joe....... i wish someone could help me.
ooh also if it is possible to include a field to show if the email go through or not.
Thanks

J
Jane 7/17/2008

Hi,
use Before record added event and Send email with new data action on the Events tab.

To select names and emails from another table use following code:

str = "select UserName, UserEmail from TableName"

Set rs = server.CreateObject("ADODB.Recordset")

rs.open str,dbConnection

while not rs.eof

'send your email here

'rs("UserName") - name of user

'rs("UserEmail") - user email

wend

rs.close

set rs=nothing


Also I recommend you to have a look at the HTML Email Template article:

http://www.asprunner.com/forums/index.php?showtopic=6409