We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

How check for a successful SEND using CDO?

Alwin
Alwin asked
on
Medium Priority
633 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!
Comment
Watch Question

Top Expert 2004

Commented:
You can either check for err.number, or check the SMTP logs for successful mail.  I don't think CDO provide such functionality internally.
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
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!!

Author

Commented:
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
Top Expert 2004

Commented:
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
Why 'B' ?
Top Expert 2004

Commented:
@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!

Author

Commented:
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

Top Expert 2004

Commented:
That's because there's no such thing as CDO error codes!

Author

Commented:
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


Author

Commented:
Top Expert 2004

Commented:
Never used them, don't think they are for ASP....they look more SMTP or MFC based.  
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.