Manually Uploading distribution lists as Contact Groups

In Outlook, Open your Contacts

Open a distribution list to upload by double clicking on it.

On the distribution list window that opens, click on Windows icon and choose Save As (circled in image below).


Choose Save as type Text Only and to your desktop.


Open Excel

In Excel 2007, go to Data tab and choose “From Text” above Get External Data

Choose Desktop

Highlight the file you saved to the desktop and click Import

 

Choose Delimited and click Finish



Click Ok to import data
 

Your data should now be in 2 columns which you should name “Name” and “Email Address” and delete unnecessary rows at the top.

Save the document as a CSV(Comma Delimited) file type

 

Click Ok to the error message about multiple sheets


Click Yes to Compatible with CSV message


Click No to Save Changes Message


In Gmail, Go to Contacts and click Import


Click Browse to select the file.  Choose the CSV file you just saved and click Open



Check box “Also Add these Imported Contacts to” New Group or select the existing group to add to

Click Import

If you chose New Group, you will be prompted to enter the group name & click OK.

Your results will be displayed



ą
Jessica Daniel,
Sep 17, 2009, 2:43 PM
ą
Jessica Daniel,
Sep 17, 2009, 2:43 PM
ą
Jessica Daniel,
Sep 17, 2009, 2:44 PM
ą
Jessica Daniel,
Sep 17, 2009, 2:44 PM
ą
Jessica Daniel,
Sep 17, 2009, 2:44 PM
ą
Jessica Daniel,
Sep 17, 2009, 2:44 PM
ą
Jessica Daniel,
Sep 17, 2009, 2:44 PM
ą
Jessica Daniel,
Sep 17, 2009, 2:44 PM
ą
dist2.JPG
(32k)
Jessica Daniel,
Sep 17, 2009, 2:43 PM
ą
dist3.JPG
(16k)
Jessica Daniel,
Sep 17, 2009, 2:43 PM
ą
dist4.JPG
(42k)
Jessica Daniel,
Sep 17, 2009, 2:43 PM
ą
dist5.JPG
(33k)
Jessica Daniel,
Sep 17, 2009, 2:43 PM
ą
dist7.JPG
(11k)
Jessica Daniel,
Sep 17, 2009, 2:43 PM
ą
dist8.JPG
(35k)
Jessica Daniel,
Sep 17, 2009, 2:43 PM
ą
dist9.JPG
(27k)
Jessica Daniel,
Sep 17, 2009, 2:43 PM
Comments