Creating an Outlook 2007 Distribution List Using MS Access

[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

 

[Michael Bauer [MVP - Outlook]]

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:

 

[Don]

Thanks Michael and Sue! I will give your suggestions a try!

Don




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