Mass Mailer

Results 1 to 2 of 2

Thread: Mass Mailer

  1. #1
    Join Date
    Dec 1969

    Default Mass Mailer

    Hello all,<BR><BR>I have a very simple Access 2K DB with a table named "Customers" and a column titled "EMailAddress". I want to be able to send a newsletter to every address in my "EMailAddress" column. I think it can be done using a DO WHILE loop, however, I am not too good with coding.<BR><BR>Does anyone have any sample code or any pointers??? <BR><BR>I really appreciate it!!

  2. #2
    Join Date
    Dec 1969

    Default RE: Mass Mailer

    Try something like this<BR><BR>SQL="SELECT email FROM Customers" <BR>set list=conn.execute(SQL)<BR><BR>do while not list.eof<BR>Set objNewMail = CreateObject("CDONTS.NewMail")<BR> objNewMail.From = "yourmail@here"<BR> objNewMail.To = list(0)<BR> objNewMail.Subject = "Your subject here"<BR> objNewMail.Body = message<BR> intMsgImportance = 0 &#039Low<BR> objNewMail.Send<BR><BR>list.movenext<BR>loop

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts