Transferring data from .CSV excel files to Outlook contacts

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

skidave32289 - 14 Oct 2005 05:24 GMT

I wish to quickly and easily tranfer data from a .CSV file to Outlook
contacts in a distribution list. I sell my own software and I can download a
.CSV file that has all customer information (including customer name and
e-mail address) and open it up with excel. Is there any way to pick two
columns (name and e-mail address) and have it automatically imported to
outlook as contact entries in a distribution list? I have a total of over 300
sales and it would take forever to manually copy and paste each e-mail
address and name.

Thanks!
David

Reply to this Message

Sue Mosher [MVP-Outlook] - 14 Oct 2005 13:36 GMT

Why do you want a distribution list? I would import the contacts into their own folder, then for mail shots, use mail merge. No DL needed.

Signature

Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

>I wish to quickly and easily tranfer data from a .CSV file to Outlook
> contacts in a distribution list. I sell my own software and I can download a
[quoted text clipped - 7 lines]
> Thanks!
> David

Reply to this Message

skidave32289 - 15 Oct 2005 17:34 GMT

How would I do this? I was thinking of using a distribution list because I
wanted to have a separate list for each one of my programs so I could send an
email (i.e. for a program update) to all members of a specific list. I
thought mail merge was only for making addresses for snail mail.

David

> Why do you want a distribution list? I would import the contacts into their own folder, then for mail shots, use mail merge. No DL needed.
>
[quoted text clipped - 9 lines]
> > Thanks!
> > David

Reply to this Message

Sue Mosher [MVP-Outlook] - 15 Oct 2005 19:06 GMT

If you look at the output options for a Word mail merge, you'll see that there are three -- new document, printer, and e-mail.

Signature

> How would I do this? I was thinking of using a distribution list because I
> wanted to have a separate list for each one of my programs so I could send an
[quoted text clipped - 16 lines]
>> > Thanks!
>> > David

Reply to this Message

skidave32289 - 15 Oct 2005 23:18 GMT

Thanks-this has solved my problem.

David

> If you look at the output options for a Word mail merge, you'll see that there are three -- new document, printer, and e-mail.
>
[quoted text clipped - 18 lines]
> >> > Thanks!
> >> > David

Reply to this Message