Solved

How check for a successful SEND using CDO?

Posted on 2004-03-29
12
303 Views
Last Modified: 2008-03-06
Hi Experts,

A Form has to be submitted.

When using aspmail, something like this can be done:
  if Mailer.SendMail then
        response.write ("Your message was sent")      
    else
        response.write ("Your message was not sent. ")
        response.write ("The error was: " & Mailer.Response)
    end if


But how do I check if the message was sent successfully using CDO?

Set objMessage = Server.CreateObject("CDO.Message")
With objMessage

      .To       = ...
      .From     = ...
      .Subject  = ...
      .TextBody = ...
      .Send
End With

Set objMessage = Nothing

What to do after objMessage.Send ?

Thanks a lot!
0
Comment
Question by:Alwin
  • 5
  • 4
  • 2
  • +1
12 Comments
 
LVL 31

Expert Comment

by:alorentz
Comment Utility
You can either check for err.number, or check the SMTP logs for successful mail.  I don't think CDO provide such functionality internally.
0
 
LVL 20

Accepted Solution

by:
jitganguly earned 250 total points
Comment Utility
Do this

Set objMessage = Server.CreateObject("CDO.Message")
With objMessage

     .To       = ...
     .From     = ...
     .Subject  = ...
     .TextBody = ...
     .Send
End With

If err.number <> 0 Then
   Response.Write "Error in Sending "
   response.end
End if

generally when it fails, it goes to badmail folder. You may want to manipulate that
0
 
LVL 21

Expert Comment

by:ap_sajith
Comment Utility
Here is the code which reads through the badmailfolder and retrieves the recipients list....

<%
Dim objFSO,objFold,objfile
CONST FolderPath="F:\Inetpub\Mailroot\Drop"
'** CREATE THE FSO **
Set objFSO=Server.CreateObject("Scripting.FileSystemObject")
'** CREATE FOLDER
Set objFold=objFSO.GetFolder(FolderPath)
' ** OPEN EACH MAIL **
For each objMail in objFold.Files
     Set objfile=objFSO.OpenTextFile(FolderPath&"\"&objMail.Name, 1,false)
     do while objfile.AtEndOfStream = false
          lnNo=objfile.Line
          ' ** LINE 2 DISPLAYS THE RECIPIENT **
          If lnNo=2 Then              
               Response.Write objfile.ReadLine              
          ' ** LINE 4 DISPLAYS THE TIME **
          elseif      lnNo=4 Then              
               Response.Write objfile.ReadLine
               Response.Write("<br>")
          else
               objfile.skipLine
          End If          
     Loop
     objfile.Close
     Set objfile=Nothing
Next

Set objFold=nothing
Set objFSO=nothing
%>

You'll have to modify the folder path to your Badmail directory.
The output is returned to the browser... However, with slight modification, you can make the script to write to a text file and forward the text file to your business users.

Cheers!!
0
 

Author Comment

by:Alwin
Comment Utility
Hi,

I cannot access any badmail folder, this form (website) is not hosted on my own server, but somewhere else.
So far the err.number seems to offer the best solution.

By the way, how to know what the CDO errorcode is?
The errorcodes description can be found here:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cdosys/html/_cdosys_error_codes.asp

Or is this only for win2000 and not for winNT?

Thanks
0
 
LVL 31

Expert Comment

by:alorentz
Comment Utility
You don't need to know the error codes in ASP, just that it's not zero:

if err.number <> 0 then
   'there was an error in the page
   response.write err.number & ": " & err.description
end if
0
 
LVL 20

Expert Comment

by:jitganguly
Comment Utility
Why 'B' ?
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 31

Expert Comment

by:alorentz
Comment Utility
@Alwin - Note that I said check err.number in the first post.  And, B grades are never good when someone gives you the right answer.  Learn to use the board properly or Experts will not help you!
0
 

Author Comment

by:Alwin
Comment Utility
Hi alorentz,

I know that you were the first to mention err.number.
But when I asked about CDO error codes you said that I don't need to know about CDO error codes.
I said CDO error codes and not err.number

I wondered of I could use CDO errorcode to be able to give the right feedback in case of error.

If I ask about something then I don't expect to get "you don't need to know" as an answer.

Thats's why

Regards,
Alwin

0
 
LVL 31

Expert Comment

by:alorentz
Comment Utility
That's because there's no such thing as CDO error codes!
0
 

Author Comment

by:Alwin
Comment Utility
Hi jitganguly

Never knew that A or B was so important.
Sorry about that.

Using the err.number is a good solution, but I was not convinced that there are no better solutions.
That's why I gave you "good"

Sorry again.
I 'll remeber it for the next time.

Regards,
Alwin


0
 

Author Comment

by:Alwin
Comment Utility
0
 
LVL 31

Expert Comment

by:alorentz
Comment Utility
Never used them, don't think they are for ASP....they look more SMTP or MFC based.  
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now