Importing email addresses from Excel

5 pts.
Tags:
Email management applications
Microsoft Excel
Outlook
I have a list of email addresses and names in Excel that I would like to send an email using outlook. Is there an easy way to do this?

Answer Wiki

Thanks. We'll let you know when a new response is added.

In Microsoft Outlook, how can I import address information from an Excel workbook into my Contacts list?

Follow the steps below to import Excel data into Outlook:

1. Arrange the Excel data in the traditional database format; i.e., give each column field titles and make each row a record.

2. Change the field titles in the worksheet so that they match those in your Outlook Contacts list.

3. To display the Name dialog box, press Ctrl-F3. Use this dialog box to assign the name Contacts to the entire range of contacts data.

4. Open Outlook, and from the File menu, select Import and Export… .

5. In Outlook 98, 2000, 2002, or 2003, select Import from another program or file. In Outlook 97, select Import from Schedule+ or another program or file. Click Next.

6. Select Microsoft Excel. Click Next.

Note: You may get the following prompt: “Microsoft Office Outlook cannot start the required translator. This feature is not currently installed. Would you like to install it now?”

If you do, click Yes to continue.

7. From the Import a File page, make your desired selections, depending on how you want to handle duplicates. To navigate to the Excel file you are importing, click Browse… .

8. Select the file, then click OK. Back in the Import a File dialog box, click Next.

9. In the Select a destination folder window, select the Contacts folder. Click Next.

10. On this last page, you will see two buttons:

* Map Custom Fields… : Click if you want to change the “field mapping”, i.e., the selection of which columns in your Excel file match up with which data in Outlook’s contacts. For example, one of your Excel file columns might read “Home”, and you’ll have to map that in Outlook to either “Home Address” or “Home Phone”, accordingly.

* Change Destination… : Click if you want to change the destination folder. Since you are importing contacts, and since you already selected the destination folder in the last step, you only need to click this button if you made a mistake or want to double-check that you’ve selected the right one. Otherwise, you can ignore it.

When you are done, click Finish, and wait for Outlook to complete the task. To check the results in Outlook, open your Contacts folder.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Schmidtw
    Is the file formatted like the typical Excel export format? If it is not, Excel probably wont be able to import it. -Schmidtw
    11,330 pointsBadges:
    report
  • 126
    i dont think so u r procedure is right
    170 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following