RalphS007
asked on
Access/Excel/Outlook
I was asked to pull data from an access 2007 database and import the contact info into outlook as a distribution list. I've created a CSV file to do the import but how do i get it into outlook?
In any event, you can surely import a list of "Contacts" as a CSV file, but not a "Distribution List" specifically...
JeffCoachman
JeffCoachman
Pardon me for jumping in here ...
Helen Feddema has an example that does what you want:
Create Distribution List from an Excel Worksheet
It can be found here:
http://www.helenfeddema.com/CodeSamples.htm
It is #61 in the section Excel >>> Outlook.
Helen Feddema has an example that does what you want:
Create Distribution List from an Excel Worksheet
This sample includes an Excel worksheet with a list of names and email addresses, and a saved VBA module containing a procedure that creates an Outlook Distribution List from data in the worksheet. Works in Office 2003, and probably in 2000, 2002 and 2007 as well.
It can be found here:
http://www.helenfeddema.com/CodeSamples.htm
It is #61 in the section Excel >>> Outlook.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
RalphS007,
I believe you accepted the wrong post.
My post was just to say that I was glad another suggestion was made.
Please click the "Request Attention" link and ask that post #34962363 be accepted as the solution.
Jeff
I believe you accepted the wrong post.
My post was just to say that I was glad another suggestion was made.
Please click the "Request Attention" link and ask that post #34962363 be accepted as the solution.
Jeff
These must be created IN Outlook.
You can however, just import the "Contacts" (obviously containing the email addresses) into Outlook.
Then you will have to create the Distribution list in Outlook normally.
But lets see what another Expert posts...