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?
RalphS007Asked:
Who is Participating?
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
<Pardon me for jumping in here ...>
No need for a pardon.
;-)

I knew that this was not possible with the Outlook Import utility directly.
But if custom code exists...

;-)

Jeff
0
 
Jeffrey CoachmanMIS LiasonCommented:
AFAIK, you can't import a "distribution list" to Outlook.
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...
0
 
Jeffrey CoachmanMIS LiasonCommented:
In any event, you can surely import a list of "Contacts" as a CSV file, but not a "Distribution List" specifically...

JeffCoachman
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Pardon me for jumping in here ...

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.


0
 
Jeffrey CoachmanMIS LiasonCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.