Do I have to have Exchange Server loaded in the server to be able to send e-mail using CDONTS? Our web server does not currently have MS Exchange Server loaded but it is loaded on a different server which we are using for office e-mail.

The reason I am asking this is because we send out mass e-mail to our members from time to time using SMTP. I noticed that some e-mail are getting delayed and sometimes it gets rejected eventually and it does not give me a specific reason why it can't be delivered. I was wondering if using MS Outlook via Exchange Server would prevent this from happening. There are about 2000 e-mail addresses in this group and about 25 - 35 are getting delayed and eventually getting rejected. I have checked the e-mail addresses and they are valid. Has anybody encountered this problem and will using an Outlook application solve it? I guess this is a two part question.

Cheers
jmss66

Anybody willing to help me solve my SMTP bulk e-mailing problem?

Below is the code:

<%



SUBMITTED = Request.Form("SUBMITTED")
If SUBMITTED = "TRUE" Then
    COMMENTS = Request.Form("COMMENTS")


        ' build email message
        MM = Chr(10) & Chr(13)
        MM = COMMENTS

        ' build mailing list

        Set oRSMem=Server.CreateObject("ADODB.Recordset")
        sqlString= "SELECT EmailAddress FROM Member WHERE MailingList = True;"
        oRSMem.Open sqlString, objConn
        MailList = ""

        Do While NOT oRSMEM.EOF
           MailList = MailList & oRSMem("EmailAddress") & ";"
           oRSMem.MoveNext
        Loop

        oRSMem.Close
        Set oRSMem = Nothing

        Set objMsg = Server.CreateObject("CDONTS.NewMail")
        objMsg.From = "[email protected]"
        objMsg.BCC = MailList
        objMsg.Subject = "Fund News Update"
        objMsg.Body = MM
        objMsg.MailFormat = 0
         If Session("UploadFileName") <> " " Then

          ' Start parsing Data from Session("UploadFileName")

           Dim strData
           Dim intIndex
           strData = Split(Session("UploadFileName"), ",")
           Do until intIndex = Session("IntCounter")
              objMsg.AttachFile "C:\inetpub\wwwroot\hfrrf\upload\" & strData(intIndex)
              intIndex = intIndex + 1
           Loop

        End If
        objMsg.Send
        Set objMsg = Nothing

        URL = "Administrator.asp"
        Response.Redirect(URL)

End If
%>
<H3>Mass Mailing</H3>
<FORM ACTION="Administrator_email.asp" METHOD=POST>
<INPUT TYPE=HIDDEN NAME="SUBMITTED" VALUE="TRUE">


<H4>Comments:</H4>

<P><TEXTAREA NAME="COMMENTS" ROWS="5" COLS="30"><%=COMMENTS%></TEXTAREA>
<P>
<INPUT TYPE=SUBMIT VALUE="Send ">
<INPUT TYPE=RESET VALUE="Reset">

</FORM>

Thanks

??? What is your problem?

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

My problem is, when I send e-mail to our members, not all of them are getting them and there is no rhyme or reason. On my original post, I was thinking of re-writting the program to go through MS Outlook so our Exchange Server will take care of sending it. The again, now, probably there is someone who can help me figure out why some e-mail are not getting delivered even though they have valid e-mail addresses. There must just be about 25-35 out of probably close to 2000 members in our mailing list.

I posted my code because there might be something in my program that does not work for mass e-mail sending and somebody might want to give me a suggestion on handling this matter.

Thanks

My suggestion would be to set up an alias on your mail server, for example: [email protected] and try sending an email to that alias and see if all of your members recieve the email. (Which they should)

Currently what you are doing is writing out all of your mailing list users and sending one email; I have had a similar problem when I was using SQL to send emails, for some reason there would be a few emails that wouldnt get sent. (I could never explain it but figured that the Mail Spool was getting overloaded)

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

Hmmm...interesting. So you had the same problem before. Let me try by breaking the e-mail into probably two or three groups. Will that help?

Also, I can try your suggestion about the alias on our exchange server, my questions are, how do I populate the alias with member's e-mail that opted to receive them. We have about 5,000 members and not all of them wants to receive e-mail so my program only includes members that opted to join our mailing list.

Is there a place on the website or a book I can read to learn how to go about it or if you could please give me a sample code so I can understand and be able to write the program. I really do appreciate all the help you have given me.

Thanks

As far as your current user base, you are going to have to create the alias on Exchange and then select what email address it will send to =\

As far as a process that, if a user elects to recieve emails, I do not know how you would go about interfacing with exchange to add that user to the alias group =\

I did a real quick search and I am not seeing any pertient results as to how you would go about doing this (but of course it can be done as most sites that have newsletters do the same thing, or about the same thing anyway)

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

I am sorry, about the questions I asked. I was not clear. I already wrote the program so members can join or not on the mailing list. My problem is how do I add or populate the distribution list I will create in the exchange server?

Here is a kinda pseudo code of what I wanted to do writing the code in ASP and accessing the distribution list in Exchange to delete current members and re-populate it (there might be others who just joined).


Read database mailing list table to create the e-mail distribution.
"mlist" is a field in the table. I check this to find out if they want to be sent e-mail.

  Read till EOF
   if mList = true then
      EmailList = EmailList & emailaddress & ";"
      movenext
   end if
  loop to next record

  EmailList will be ported to the Alias distribution list in the exchange server

Or

  Read till EOF
   if mList = true then
      add members e-mail address to the the Alias Distribution list
      movenext
   end if
  loop to next record


I will write all this in ASP not unless you have a better suggestion. Also, what do you think about my earlier question about breaking the e-mail I send into 3 or 4 groups. I can also re-write the program to send it to them one by one. Would that be any better or will it even be disastrous?

Thanks

Thats what I am saying, I don't know of anyway to directly interface with Exchange Server to add the users email to the alias.

As far as sending the emails 1 at a time, I am not sure if you will have any better results, exchange is still going to need to send 5000 emails. (Yes in the case of the alias Exchange is going to still send 5000 emails, but that list is stored on the Exchange server itself and shouldn't have a problem)

So I am not sure.

-------------------------
I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.

^^Thats my signature

I understand what you are saying now about not knowing how to interface directly to the Exchange Server to add the e-mail addresses.

Currently I am just using SMTP to send the mail. I guess that's why not all e-mails are getting delivered because it gets overloaded. I will research on the interface part and will let you know how it goes.

Thank you so much for your help.