| |
cvrk3
Google Guru
Joined: 05 Jul 2004
Location: India
16443.40 GC$
Items
|
 Posted: Wed Jul 28, 2004 4:43 am Post subject: help on gmail |
 |
|
|
How to import addresses from other mails to gmail?
| Quote: | You can import address books from Outlook, Yahoo!, orkut and other services to your Gmail account by uploading CSV (comma separated values) files.
To import contacts to Gmail:
1. Create a custom CSV file or export the address book from your other webmail provider or email client as a CSV file. (Additional information on exporting and creating or altering .csv files is listed below.)
2. Log into Gmail and click 'Contacts' at the top of the page. The Contacts list will open in a new window.
3. Click 'Import Contacts.'
4. Click 'Browse' and locate the CSV file you wish to upload from your computer.
5. Select the file and click 'Import Contacts.' After successfully uploading the document, a dialogue box displays the number of new entries that were added to your Contacts list.
Gmail only imports contacts that contain email addresses. If some entries aren't included in your Contacts list, Gmail will tell you why these entries were left out.
Because Gmail does not offer group or distribution list functionality at this time, this information won't be transferred from other address books into your Gmail Contacts list.
Please note that if you import information about a contact that matches the email address of an existing entry, only the most-recently uploaded version of that entry will remain in your Gmail Contacts list.
Exporting CSV files:
Here's how to export or find additional information on exporting the address book from other webmail services and email clients:
* Yahoo!: To import your Yahoo! Mail address book, save your file as a Yahoo! CSV. Instructions are available in the Yahoo! Address Book help section at: http://help.yahoo.com/help/us/ab/impexp/
* Hotmail: Here's one way to export your contacts from Hotmail to Gmail:
o Sign in to your Hotmail account
o Click on the Contacts tab
o Click "Print view"
o Align the cursor with the checkbox next to the first name
o Hold down the cursor and select all the entries
o Hold down the 'Control + c' keys to copy the list
o Open Microsoft Excel (or a similar spreadsheet program that supports comma separated values)
o In Excel, select cell A1 (The top square on the left side)
o Hold down the 'Control + v' keys to paste (Don't use 'Paste Special')
o Now 'Save as' and select the type 'CSV (Comma delimited)' and make a note of where you saved the file
* Microsoft Outlook and Outlook Express: Here are some general directions to follow. Instructions vary by version. For more detailed instructions, open 'Help' in Outlook or Outlook Express and type 'export' in the search box. Look for topics that include 'export wizard,' 'export information,' 'exporting contacts' or 'exporting address book contacts' in the title.
From Outlook:
o Select File > Import/Export > Export from the main menu
o Choose Comma Separated Values (Windows) > Select "Contacts" > Save exported file
From Outlook Express:
o Select File > Export > Address Book from the main menu
o Select Text File (Comma Separated Values)
o Click Export
* orkut: After you log in to your account, click 'Friends' on the top navigation. From there, click on 'Download your contacts' on the bottom of the page to save your contacts as a CSV file.
* AOL: AOL does not have address book export functionality, so you may have to create a custom CSV file if you use this service.
* Others: Refer to your service or client help section for information on how to export your address book. If you have trouble uploading a file into Gmail, you may need to open the file in Excel, alter the columns and/or headers, and then save the file as .csv.
How to create (or alter) a CSV file:
Creating a CSV file allows you to upload several contacts at once. Spreadsheet programs like Microsoft Excel make it easy to create CSV files.
Your CSV file should be formatted as a table and must include a header, or first line, that defines the fields in your table. Gmail accepts many common header fields (name, email address, birthday, etc.). Here are some additional things to keep in mind as you create your file:
* The file must include a field for the email address
* The 'Name' field can be specified as one column, such as:
header >
contact info. >
name
Jane Doe
or as separate fields for the first, middle and last name, such as:
header >
contact info. >
first name middle name last name
Jane Doe
* Other fields, such as nickname, street address, phone number, birthday, etc., are placed in the 'Notes' section
* Fields can be listed in any order
Here's an example of a sample file that can be created using Microsoft Excel:
header >
contact info. >
First Name
Last Name
Email Address
Street Address
Phone
Jane
Doe
GoogleGal@gmail.com
623 East 68th Street, Apt. 3-B, New York, NY
(212) 555-9975
By saving this table as .csv and importing it to Gmail, one entry – for Jane Doe – is added to your Contacts list.
After you've entered all of your contacts into a table, save the document and select CSV (Comma delimited) (*.csv) as the file type you would like to save. as the file type. If you are prompted to verify your selection, click Yes or OK.
For more information about CSV files, open 'Help' in Excel.
Once you've saved the file, you're ready to import your contacts to Gmail.
|
|
|
| Back to top |
|
|
Sponsored Links
|
| Posted: 29 Aug 2008 5:47 pm Post subject: Advertisements |
|
|
|
|
|
|
| Back to top |
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Host your free forums with Invision Plus.net forum web hosting with your own subdomain.
alexisBlue v1.2 // Theme Created By: Andrew Charron // Icons in Part By: Travis Carden |
|
|
|
|
