|
| 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
June 16th 08, 04:05 AM
posted to microsoft.public.access.formscoding,microsoft.public.outlook.program_vba
|
|||
|
|||
Creating an Outlook 2007 Distribution List Using MS Access
Quite some time back I put together some VBA code to create an Outlook 2003
distribution list from an MS Access 2003 database. Pretty straight forward: name and e-mail. In short, the code created an empty distribution list and blank message. It then added recipients to the message, then added the recipients to the distribution list. In Outlook 2007, 'Recipient' is now read-only which appears to break the code that worked under 2003. I have tried all sorts of variants of the code trying to take into account the changes for Outlook 2007. Best I can tell, short of creating a contact, then adding the contact to the distribution list, there does not seem to be a simple way of just taking e-mail addresses and names to create a distribution list. I tried some Google searches, but did not have any luck there either. Anyone know of any samples out there? Anyone willing to throw me a bone (hopefully with some code on it!) on this one?! Thanks!! Don 
|
|
#2
June 16th 08, 07:02 AM
posted to microsoft.public.access.formscoding,microsoft.public.outlook.program_vba
|
|||
|
|||
|
Creating an Outlook 2007 Distribution List Using MS Access
There's still the AddMember and AddMembers methods, that has not been changed. -- Best regards Michael Bauer - MVP Outlook : VBOffice Reporter for Data Analysis & Reporting : Outlook Categories? Category Manager Is Your Tool: : http://www.vboffice.net/product.html?pub=6&lang=en Am Sun, 15 Jun 2008 23:05:43 -0400 schrieb Don: Quite some time back I put together some VBA code to create an Outlook 2003 distribution list from an MS Access 2003 database. Pretty straight forward: name and e-mail. In short, the code created an empty distribution list and blank message. It then added recipients to the message, then added the recipients to the distribution list. In Outlook 2007, 'Recipient' is now read-only which appears to break the code that worked under 2003. I have tried all sorts of variants of the code trying to take into account the changes for Outlook 2007. Best I can tell, short of creating a contact, then adding the contact to the distribution list, there does not seem to be a simple way of just taking e-mail addresses and names to create a distribution list. I tried some Google searches, but did not have any luck there either. Anyone know of any samples out there? Anyone willing to throw me a bone (hopefully with some code on it!) on this one?! Thanks!! Don
|
|
#3
June 16th 08, 01:53 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Creating an Outlook 2007 Distribution List Using MS Access
And you can create a Recipient for use with AddMember by using the Namespace.CreateRecipient method.
-- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Michael Bauer [MVP - Outlook]" wrote in message .. . There's still the AddMember and AddMembers methods, that has not been changed. -- Best regards Michael Bauer - MVP Outlook : VBOffice Reporter for Data Analysis & Reporting : Outlook Categories? Category Manager Is Your Tool: : http://www.vboffice.net/product.html?pub=6&lang=en Am Sun, 15 Jun 2008 23:05:43 -0400 schrieb Don: Quite some time back I put together some VBA code to create an Outlook 2003 distribution list from an MS Access 2003 database. Pretty straight forward: name and e-mail. In short, the code created an empty distribution list and blank message. It then added recipients to the message, then added the recipients to the distribution list. In Outlook 2007, 'Recipient' is now read-only which appears to break the code that worked under 2003. I have tried all sorts of variants of the code trying to take into account the changes for Outlook 2007. Best I can tell, short of creating a contact, then adding the contact to the distribution list, there does not seem to be a simple way of just taking e-mail addresses and names to create a distribution list. I tried some Google searches, but did not have any luck there either. Anyone know of any samples out there? Anyone willing to throw me a bone (hopefully with some code on it!) on this one?! Thanks!! Don
|
|
#4
June 16th 08, 05:48 PM
posted to microsoft.public.access.formscoding,microsoft.public.outlook.program_vba
|
|||
|
|||
|
Creating an Outlook 2007 Distribution List Using MS Access
Thanks Michael and Sue! I will give your suggestions a try!
Don "Sue Mosher [MVP-Outlook]" wrote in message ... And you can create a Recipient for use with AddMember by using the Namespace.CreateRecipient method. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Michael Bauer [MVP - Outlook]" wrote in message .. . There's still the AddMember and AddMembers methods, that has not been changed. -- Best regards Michael Bauer - MVP Outlook : VBOffice Reporter for Data Analysis & Reporting : Outlook Categories? Category Manager Is Your Tool: : http://www.vboffice.net/product.html?pub=6&lang=en Am Sun, 15 Jun 2008 23:05:43 -0400 schrieb Don: Quite some time back I put together some VBA code to create an Outlook 2003 distribution list from an MS Access 2003 database. Pretty straight forward: name and e-mail. In short, the code created an empty distribution list and blank message. It then added recipients to the message, then added the recipients to the distribution list. In Outlook 2007, 'Recipient' is now read-only which appears to break the code that worked under 2003. I have tried all sorts of variants of the code trying to take into account the changes for Outlook 2007. Best I can tell, short of creating a contact, then adding the contact to the distribution list, there does not seem to be a simple way of just taking e-mail addresses and names to create a distribution list. I tried some Google searches, but did not have any luck there either. Anyone know of any samples out there? Anyone willing to throw me a bone (hopefully with some code on it!) on this one?! Thanks!! Don
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Creating Distribution Lists in Outlook 2007 from Contact List | parkmp1 | Outlook - Using Contacts | 8 | June 4th 08 11:24 AM |
| Creating distribution list by searching from outlook 2007 contacts | mshah75 | Outlook - Using Contacts | 7 | April 24th 08 02:41 PM |
| Creating a distribution list... | snailkiller | Outlook - Using Contacts | 5 | September 3rd 07 06:41 PM |
| Creating one distribution list from another | gollyg | Outlook - Using Contacts | 5 | August 1st 07 05:48 AM |
| Creating A New Distribution List | Kelly V. | Outlook - Using Contacts | 1 | December 15th 06 01:50 AM |
Hybrid Mode
