• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

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?
0
RalphS007
Asked:
RalphS007
  • 4
1 Solution
 
Jeffrey CoachmanCommented:
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 CoachmanCommented:
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 CoachmanCommented:
<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 CoachmanCommented:
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

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now