Problem with email address

  • Thread starter Thread starter Tony Gilbert
  • Start date Start date
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
 
If you're creating the messages with Outlook objects, then you can use the
Recipient.Resolve method to resolve a name to the proper address and find
out if it worked or not.

FYI, there is a newsgroup specifically for general Outlook programming
issues "down the hall" at microsoft.public.outlook.program_vba
 
Back
Top