Access automating Outlook using VBA no longer working

[jaminjay]

Good day all!

I have some code that has been working well for some time (until
recently).

I have a Distribution List set up in Outlook to send automated emails
from Access with. To ensure the emails are always sent to the right
people, without editing the code, I could just update the list and it
would all be fine.

Recently, I wanted temporarily to change the list, so I copied, renamed
it and made the necessary changes. This new list did not work (and I
was on holiday during its time of use). I have now returned and the
old list is to be used again, so I have renamed the lists accordingly,
but this new error still occurs.

Outlook pops up its usual "A program is trying to automatically send
email on your behalf" and I click 'Yes' and it then tells me "Outlook
does not recognize one or more names" and stops (as in many other posts
I've read around the web) at the '.Send' command. I have not seen this
behaviour before, and I have noted that all of my MS templates (Word,
Excel, etc.) and Outlook shortcuts have disappeared, so maybe the
system has been updated and that is the cause of the drama. Either
way, I need to find a solution to the issue.

I have followed the advice on many other posts but none seem to correct
my problem.

This is a frustrating problem and any help would be greatly
appreciated.

benJamin

 

[Sue Mosher [MVP-Outlook]]

The error message means simply that one or more addresses cannot be resolved to an SMTP or other valid addresss. If you change your code to display the message if it gets that error, you should quickly be able to see which are the problem addresses.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[jaminjay]

Thankyou for your reply.
All of the addresses work correctly. I know this because I manually
sent the email to the Distribution List manually after changing the
programmatic email to send only to my own address and then forward it
to the list (which includes my address). No undeliverable reports,
etc., are returned, and the physical actions to be taken occur (on
receipt of the mail).

Any other thoughts?

benJamin

 

[Sue Mosher [MVP-Outlook]]

Sending manually is one good troubleshooting step, but I would still try what I suggested so you can better what's happending when you send programmatically.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

Thankyou for your reply.
All of the addresses work correctly. I know this because I manually
sent the email to the Distribution List manually after changing the
programmatic email to send only to my own address and then forward it
to the list (which includes my address). No undeliverable reports,
etc., are returned, and the physical actions to be taken occur (on
receipt of the mail).

Any other thoughts?

The error message means simply that one or more addresses cannot be resolved to an SMTP or other valid addresss. If you change your code to display the message if it gets that error, you should quickly be able to see which are the problem addresses.

 

[jaminjay]

Oh, I think I read the post slightly bungledly... ;-)

To display the prepared message will bring it up as if it's a manual
send? I'll try that and give it a whirl...

benJamin

 

[jaminjay]

Thankyou for your assistance.

For some reason, the database became corrupt and I had to rebuild it
from the previous release file. The new machine I am running a new
connection to the same Exchange account may also have contributed to
the issue having been resolved without further testing.

Benjamin