How do I export a distribution list from my address book to Excel?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JHDepew - 10 Jan 2008 17:22 GMT

Hello. I know I can export my entire Contacts folder of addresses to an Excel
file but does anyone know how to export ONLY one individual distribution list
to Excel?

Reply to this Message

Brian Tillman - 10 Jan 2008 20:15 GMT

> Hello. I know I can export my entire Contacts folder of addresses to
> an Excel file but does anyone know how to export ONLY one individual
> distribution list to Excel?

Open the DL and choose File>Save As. Choose the "Text Only (.txt)" file
type. Give it a name and click OK. This creates a Tab Separated Values
file that Excel can read. Start Excel, click FIle>Open. Select the file
type "Text Files (*.prn; *.txt; *.csv)", browse to and select the file you
saved, and click Open. The "Text Import Wizard" will appear. In the "Start
import at" drop-down, change the value to "7" (or wherever the first row of
your names start), and click Finish.

Signature

Brian Tillman [MVP-Outlook]

Reply to this Message

Hotkey - 30 Jan 2008 20:23 GMT

I'm trying to upload a distro list to GMail. I've followed steps below and
saved out the file as various csv files but GMail rejects them as not
recognized.

If I make a "test" file by exporting all contacts from Outlook 2003 to a csv
file - it works fine.

So how do I get the contents of a distro list in a csv format that works?

>> Hello. I know I can export my entire Contacts folder of addresses to
>> an Excel file but does anyone know how to export ONLY one individual
[quoted text clipped - 7 lines]
> "Start import at" drop-down, change the value to "7" (or wherever the
> first row of your names start), and click Finish.

Reply to this Message

Brian Tillman - 31 Jan 2008 13:56 GMT

> I'm trying to upload a distro list to GMail. I've followed steps
> below and saved out the file as various csv files but GMail rejects
[quoted text clipped - 5 lines]
> So how do I get the contents of a distro list in a csv format that
> works?

Save the DL as a text file, which will be a tab-separated values file. Open
that file in Excel and save it as a comma-separated values file. Then use
that with gmail.

Signature

Brian Tillman [MVP-Outlook]

Reply to this Message

Rate this thread: