(Msg. 1) Posted: Sun Jun 15, 2008 11:05 pm
Post subject: Creating an Outlook 2007 Distribution List Using MS Access Archived from groups: microsoft>public>access>formscoding, others (more info?)
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?!
(Msg. 2) Posted: Mon Jun 16, 2008 3:02 am
Post subject: Re: Creating an Outlook 2007 Distribution List Using MS Access [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 3) Posted: Mon Jun 16, 2008 8:53 am
Post subject: Re: Creating an Outlook 2007 Distribution List Using MS Access [Login to view extended thread Info.] Archived from groups: microsoft>public>outlook>program_vba (more info?)
And you can create a Recipient for use with AddMember by using the Namespace.CreateRecipient method.
"Michael Bauer [MVP - Outlook]" <mb.RemoveThis@mvps.org> wrote in message news:1f28zdiywfb7s$.1qohxhe2u8r5p.dlg@40tude.net...
>
>
> 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
(Msg. 4) Posted: Mon Jun 16, 2008 12:48 pm
Post subject: Re: Creating an Outlook 2007 Distribution List Using MS Access [Login to view extended thread Info.] Archived from groups: microsoft>public>access>formscoding, others (more info?)
Thanks Michael and Sue! I will give your suggestions a try!
Don
"Sue Mosher [MVP-Outlook]" <suemvp.RemoveThis@outlookcode.com> wrote in message
news:eSEoOA7zIHA.1236@TK2MSFTNGP02.phx.gbl...
And you can create a Recipient for use with AddMember by using the
Namespace.CreateRecipient method.
"Michael Bauer [MVP - Outlook]" <mb.RemoveThis@mvps.org> wrote in message
news:1f28zdiywfb7s$.1qohxhe2u8r5p.dlg@40tude.net...
>
>
> 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
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office