![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |