Posted on 2011-02-18
Medium Priority
Last Modified: 2012-05-11
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?
Question by:RalphS007
  • 4
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34927521
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...
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34962250
In any event, you can surely import a list of "Contacts" as a CSV file, but not a "Distribution List" specifically...

LVL 21
ID: 34962363
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:

It is #61 in  the section Excel >>> Outlook.

LVL 74

Accepted Solution

Jeffrey Coachman earned 200 total points
ID: 34967536
<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...


LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35332850

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.


Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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.

Join & Write a Comment

If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
Though there are a few manual ways to import PST files to Office 365 , third-party PST to Office 365 import tools are preferred over them due to various reasons.  Consequently, many tools or services are available for the same. Here, we pick the to…
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question