Hi Paul

No good way that I know of.
But I not spend much time looking for that

Now with Outlook 2007 CDO is not needed anymore because
there are no security warnings anymore if your AV is ok

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Paul W Smith" wrote in message ...
It's not really the Email address, what I am wanting to know is if there is
a test to know that the Email was actually sent.

I could write a function that returns true or false, but in my limited
experience the .send line of code executes without error, but the Email does
not get sent.

Do you know of a way of testing if the Email gets sent?

I copy myself on as a BCC but this is a manual test not one I can check in
code.

PWS



"Ron de Bruin" wrote in message
...
Test if there is a mail address in the cell in the loop

If cell.Value Like "?*@?*.?*" Then



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Paul W Smith" wrote in message
...
I am using Ron de Bruin's quite excellent code.

Howveer is it possible to test to know if am Email was actually sent? As
an example if iMsg.To is set to 0, I am looping through a set of email
addresses stored in a DB, and the query returns 0 when no Email address
is present, no Email is sent but the code does not error when using 0 as
a To address.

If the answer is I have to test every variable and that I am on-line to
know something has been sent then let me know. However I am sure the
question I am asking has been asked many times so I wonder what the
answer is.

PWS