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?

JHDepew wrote:

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 FileSave 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 FIleOpen. 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.
--
Brian Tillman [MVP-Outlook]

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?

"Brian Tillman" wrote in message
...
JHDepew wrote:

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 FileSave 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 FIleOpen. 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.
--
Brian Tillman [MVP-Outlook]

Hotkey wrote:

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?

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.
--
Brian Tillman [MVP-Outlook]