Wrox Programmer Forums
|
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old September 28th, 2006, 08:08 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default CDONTS via Outlook

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

 
Old October 12th, 2006, 08:02 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

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 = "MemberServices@hfrrf.org"
        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

 
Old October 12th, 2006, 08:03 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

??? 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
 
Old October 12th, 2006, 08:17 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

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

 
Old October 12th, 2006, 08:38 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

My suggestion would be to set up an alias on your mail server, for example: mailinglist@domain.com 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
 
Old October 12th, 2006, 09:11 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

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

 
Old October 12th, 2006, 09:29 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

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
 
Old October 12th, 2006, 09:58 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

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

 
Old October 12th, 2006, 10:18 AM
Wrox Author
 
Join Date: Oct 2005
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

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
 
Old October 12th, 2006, 11:46 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 196
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

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.






Similar Threads
Thread Thread Starter Forum Replies Last Post
using CDONTS maunishq ASP.NET 1.0 and 1.1 Basics 1 August 23rd, 2007 09:35 AM
cdonts p2ptolu Classic ASP Databases 1 March 8th, 2005 11:48 AM
CDONTS mikedeepak Classic ASP Components 3 August 26th, 2004 06:52 PM
CDONTS preeti Wrox Book Feedback 1 August 11th, 2004 09:39 AM
CDONTS asims12 Classic ASP Basics 1 November 13th, 2003 10:25 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.