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