Hi all - me again,

At the mo I seem to be doing a lot to get Access to communicate with 
other MS Products.

Have done a bit of work on communicating with Outlook but heres one for 
you all out there.

Is there a way I can get Access to programmatically create a new 
Distribution List and then Add Various Members to this list.

Basically a colleague of mine has to create a new distribution list and 
about 350 names in there, the names all exist in an Excel Spreadsheet but 
these cant be copied and pasted into the list, but what i think may be 
possible if for these names to be pasted into code.

something along the lines of 
  Add Member = Members Name and then we can have a list of these and 
everytime a new fee Earner appears we just add an extra line of code and 
run the process again or something along those lines - havent quite 
decided yet.

Anyway has anyone out there communicated with Outlook using the 
Distribution List, i know it exits has i have seen it in the Classes but 
cant figure out how it works.

thanks
Alankar

Is there a way I can get Access to programmatically create a new
Distribution List and then Add Various Members to this list.

Try the Helen Fedema site at

http://www.helenfeddema.com/

and look in 'code downloads'  for Outlook to Access



*************************************************************************

This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-832-8686   Internet  http://www.cis.co.uk   E-mail
cis@c...

CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

********************************************************************************

> 
Is there a way I can get Access to programmatically create a new
Distribution List and then Add Various Members to this list.

Try the Helen Fedema site at

http://www.helenfeddema.com/

and look in 'code downloads'  for Outlook to Access

Thank you this is an excellent site and provides some really good code 
but doesnt provide the use of the distribution list in MS Outlook through 
MS Access.

so if anybody else can help out there please do.


*************************************************************************

This e-mail may contain confidential information or be privileged. It is 
intended to be read and used only by the named recipient(s). If you are 
not the intended recipient(s) please notify us immediately so that we can 
make arrangements for its return: you should not disclose the contents of 
this e-mail to any other person, or take any copies. Unless stated 
otherwise by an authorised individual, nothing contained in this e-mail 
is intended to create binding legal obligations between us and opinions 
expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by 
the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 
3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 
2369965  - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 
3390839 - for ISAs and investment products bearing the CIS name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-
832-8686   Internet  http://www.cis.co.uk   E-mail cis@c...

CIS Deposit and Instant Access Savings Accounts are held with The Co-
operative Bank p.l.c., registered in England and Wales number 990937, 
P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by 
CIS Policyholder Services Limited as agent of the Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

**************************************************************************
******