Can I import an Excel doc into a distribution list?

[Ports]

I have an Excel doc with names and email addresses. I would like to make
that into an Outlook distribution list. Is that possible? I tried to follow
the import an Excel doc instructions, but to no avail.

Using: Outlook 2003, Excel 2003, Vista

 

[Judy Gleeson \(MVP Outlook\)]

You sound very confused. Excel has spreadsheets and Word has Documents. So
start by explaining what you actually have that you want to import to
Outlook. We aren't looking over your shoulder so it's hard to get advice
here without clearly explaining what's going on.

What have you treid so far and exactly what went wrong?

Here are some tips about how to post questions:
http://support.microsoft.com/?id=555375

Regards

Judy Gleeson
MVP Outlook
Trainer and Consultant www.pragmatix.com.au


..

 

[Karl Timmermans]

Q: "Can I import an Excel doc into a distribution list?"
A. No. There is no facility to import any kind of data to a PDL - Personal
Distribution List (either new or one that exists) in any version of Outlook

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com

 

[Jami ...]

That is only half true. There is no "click here and it's done" option in Outlook to do this. However, I was looking for this info as well and stumbled upon a pretty neat solution. It involves a VBA solution in Excel. I have applied this today and it works like a charm. You can find the information here:

http://office-outlook.com/outlook-forum/index.php/m/220384/

 

[Diane Poremsky [MVP]]

No need to use VBA, unless you need it automated. Just copy the email
address column and paste into the Members field.
http://www.outlook-tips.net/archives/2004/20041105.htm

--
Diane Poremsky [MVP - Outlook]



Outlook Tips by email:
(e-mail address removed)

EMO - a weekly newsletter about Outlook and Exchange:
(e-mail address removed)

You can access this newsgroup by visiting
http://www.microsoft.com/office/community/en-us/default.mspx or point your
newsreader to msnews.microsoft.com.


in message
news:[email protected]...