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

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

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

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

Thanks Ron, I guess if you do not know of a way, there probably isn't one.

Would love to use Outlook 2007, but client still uses Excel 2003.

PWS



"Ron de Bruin" wrote in message
...
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