View Single Post
  #2  
Old June 16th 08, 07:02 AM posted to microsoft.public.access.formscoding,microsoft.public.outlook.program_vba
Michael Bauer [MVP - Outlook]
external usenet poster
 
Posts: 1,885
Default 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

Ads