Sending Batch e-mail

Results 1 to 2 of 2

Thread: Sending Batch e-mail

  1. #1
    Join Date
    Dec 1969

    Default Sending Batch e-mail

    Hi<BR>Can&#039;t get this figured out...code keeps sending the e-mail to the same person for the number of record in die db!eg. 3 records in database, thus same person receive e-mail 3 times!!<BR><BR>Any suggestions?<BR>&#060;%<BR>while not FTest.eof<BR>Set MyMail = Server.CreateObject("CDONTS.NewMail")<BR>MyMail.Bo dyFormat = cdoBodyFormatHTML<BR>MyMail.MailFormat = cdomailformatMime<BR>MyMail.From = ""<BR>MyMail.To = Session("Email")<BR>MyMail.Subject = "Male Ensamble Performances"<BR>MyMail.Body = "Dear" + " " + Session("Name") + Session("Message")<BR>MyMail.Send<BR>FTest.movenex t<BR>Set MyMail = Nothing<BR>loop<BR>%&#062; <BR><BR>Thanks!<BR>J

  2. #2
    Join Date
    Dec 1969

    Default RE: Sending Batch e-mail

    You&#039;re re-using the Session variable within a loop.<BR>EITHER keep the loop and use recordsert values e.g. FTest("Name")<BR>OR kill the loop and just use the session values.

Posting Permissions

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