Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Contacts (http://www.outlookbanter.com/outlook-using-contacts/)
-   -   Can I import an Excel doc into a distribution list? (http://www.outlookbanter.com/outlook-using-contacts/68830-can-i-import-excel-doc.html)

Ports March 18th 08 08:29 PM

Can I import an Excel doc into a distribution list?
 
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\)[_108_] March 18th 08 08:33 PM

Can I import an Excel doc into a distribution list?
 
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


..
"Ports" wrote in message
...
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




Karl Timmermans March 19th 08 05:42 AM

Can I import an Excel doc into a distribution list?
 
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


"Ports" wrote in message
...
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




Jami ... October 8th 08 09:46 PM

Can I import an Excel doc into a distribution list?
 
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 he

http://office-outlook.com/outlook-fo....php/m/220384/

Diane Poremsky [MVP] October 9th 08 04:38 AM

Can I import an Excel doc into a distribution list?
 
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: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com

Outlook Tips by email:


EMO - a weekly newsletter about Outlook and Exchange:


You can access this newsgroup by visiting
http://www.microsoft.com/office/comm...s/default.mspx or point your
newsreader to msnews.microsoft.com.


"Jami ..." wrote in message
...
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 he

http://office-outlook.com/outlook-fo....php/m/220384/




All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com