Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Access/Excel/Outlook

Posted on 2011-02-18
5
Medium Priority
?
285 Views
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?
0
Comment
Question by:RalphS007
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 
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...
0
 
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...

JeffCoachman
0
 
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:
http://www.helenfeddema.com/CodeSamples.htm

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


0
 
LVL 74

Accepted Solution

by:
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...

;-)

Jeff
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35332850
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I discuss my selections of the Top Four free Outlook OST File Viewers available. Open, view and read even damaged OST files by using these tools. They all provide a clear preview of all data such as emails, notes, tasks, calendars, e…
Are you looking for the options available for exporting EDB files to PST? You may be confused as they are different in different Exchange versions. Here, I will discuss some options available.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

636 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