T
Tony Gilbert
I have an Access database that is scheduled to run a few times a day.
The code in the database loops through the records of a table, where
there is a field with the mail address and a field with the mail body
content. The mail addresses come from an external application. They
are addresses of colleagues, in "address book" format, e.g. "Doe, John
[FINIM]" (NOT the "external" address (e-mail address removed)). The
procedure is supposed to mail everything out with Outlook 2000, and
then close Outlook.
As long as the addresses are correct, it works fine. But from time to
time, there is a mail address that is NOT found in the address book
(please don't answer we should make sure the addresses are correct -
that is beyond my influence..). The mail then gets stuck in the outbox
(preventing any other messages to be send), my procedure exits to its
error handler and an attempt there to close Outlook fails. After a
couple of scheduled executions, the server shows multiple instances of
Outlook and multiple copies of the same mail that could not be send.
The problem would be solved if I can just test IF a mail address is
found in the address book before I use the Send method of the Mail
object. Does anybody have a function that can do this?? Many thanx.
Tony
The code in the database loops through the records of a table, where
there is a field with the mail address and a field with the mail body
content. The mail addresses come from an external application. They
are addresses of colleagues, in "address book" format, e.g. "Doe, John
[FINIM]" (NOT the "external" address (e-mail address removed)). The
procedure is supposed to mail everything out with Outlook 2000, and
then close Outlook.
As long as the addresses are correct, it works fine. But from time to
time, there is a mail address that is NOT found in the address book
(please don't answer we should make sure the addresses are correct -
that is beyond my influence..). The mail then gets stuck in the outbox
(preventing any other messages to be send), my procedure exits to its
error handler and an attempt there to close Outlook fails. After a
couple of scheduled executions, the server shows multiple instances of
Outlook and multiple copies of the same mail that could not be send.
The problem would be solved if I can just test IF a mail address is
found in the address book before I use the Send method of the Mail
object. Does anybody have a function that can do this?? Many thanx.
Tony