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" <(E-Mail Removed)> wrote in message news:u%23cMf$(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:u%23cMf$(E-Mail Removed)...
>>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" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:u%23cMf$(E-Mail Removed)...
>>>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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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" <(E-Mail Removed)> wrote in message
>>> news:u%23cMf$(E-Mail Removed)...
>>>>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
>>>>
>>>
>>
>