MAIL database

Results 1 to 2 of 2

Thread: MAIL database

  1. #1
    Dano Guest

    Default MAIL database

    I have some code that reads an email address from a database, sends the email, then reads the next email address, sends, etc. But I want to send all the emails out in a mass mailing. The current code is as follows: <BR><BR>Do Until MailList.EOF <BR> MyMail.To = MailList("email") <BR> MyMail.Send <BR> MailList.MoveNext <BR>Loop <BR><BR>My coding is a bit rusty, can someone please help to add the email addresses together and when at eof, send all the email at once.

  2. #2
    Join Date
    Dec 1969

    Default RE: MAIL database

    Dim ToList<BR><BR>While not MailList.EOF<BR> ToList = MailList("email") & ";"<BR> MailList.MoveNext<BR>Wend<BR><BR>MyMail.To = ToList<BR>MyMail.Send

Posting Permissions

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