A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Access automating Outlook using VBA no longer working



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old April 26th 06, 08:44 AM posted to microsoft.public.outlook.program_vba
[email protected]
external usenet poster
 
Posts: 4
Default Access automating Outlook using VBA no longer working

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

Ads
  #2  
Old April 26th 06, 05:36 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Access automating Outlook using VBA no longer working

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

wrote in message ups.com...
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

  #3  
Old April 27th 06, 09:54 AM posted to microsoft.public.outlook.program_vba
[email protected]
external usenet poster
 
Posts: 4
Default Access automating Outlook using VBA no longer working

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

  #4  
Old April 27th 06, 10:20 AM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Access automating Outlook using VBA no longer working

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
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

wrote in message oups.com...
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?


"Sue Mosher [MVP-Outlook]" wrote in message ...
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.


wrote in message ups.com...
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

  #5  
Old April 28th 06, 08:29 AM posted to microsoft.public.outlook.program_vba
[email protected]
external usenet poster
 
Posts: 4
Default Access automating Outlook using VBA no longer working

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

  #6  
Old May 9th 06, 02:04 AM posted to microsoft.public.outlook.program_vba
[email protected]
external usenet poster
 
Posts: 4
Default Access automating Outlook using VBA no longer working

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

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to access a PST I created but no longer have permission for David K Outlook - Installation 2 April 16th 06 07:21 PM
Using VBA for Outlook and VBA for Access within Access Sardonic Outlook and VBA 1 March 17th 06 01:34 PM
Automating folder export from Outlook to Access [email protected] Outlook and VBA 1 March 6th 06 07:15 PM
Delete Custom Outlook Control thru Access VBA Sue Mosher [MVP-Outlook] Outlook - Using Forms 0 January 20th 06 06:29 PM
Hotmail no longer allows email access via Outlook Express for free email accounts? Christina Outlook Express 3 January 11th 06 05:49 AM


All times are GMT +1. The time now is 08:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.