[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Need step by step directions for importing an Excel spreadsheet (with 8 columns that contain info such as name, title, cell phone, home phone, etc.) into Outlook 2007 contact list

Posted on 2009-12-21
5
Medium Priority
?
293 Views
Last Modified: 2012-05-08
Need step by step directions for importing an Excel spreadsheet (with 8 columns that contain info such as name, title, cell phone, home phone, etc.) into Outlook 2007 contact list so that the data is imported into the correct Outlook 2007 fields.

Please give me a step by step list on how to do this.
0
Comment
Question by:Knowledgeable
  • 2
  • 2
5 Comments
 
LVL 15

Accepted Solution

by:
MYCU earned 2000 total points
ID: 26099222
0
 
LVL 10

Expert Comment

by:jfromanski
ID: 26099285
Open your Outlook, From File menu select Import and Export, select Export to file, select Microsoft Excel format, enter filename, eg. export.xls, Finish. Open this .xls file in Excel, delete it's contens leaving only field names intact, open your Execel spreadsheet and copy/paste colums to export.xls. Save export.xls and back in outlook File/Import and export, then import yor data.
0
 

Author Comment

by:Knowledgeable
ID: 26100077
jfromanski,

You provided me with the Export process.

What I am trying to do is to IMPORT an existing Excel spreadsheet into my Outlook 2007 contacts.

This Excel spreadsheet contains 8 columns that contain info such as name, title, cell phone, home phone, etc. I need to be able to import this data into the Outlook 2007 contact list so that the data is imported into the correct corresponding Outlook 2007 fields (name, title, cell phone, home phone, etc).
0
 
LVL 15

Expert Comment

by:MYCU
ID: 26100370
The link I provided tells you how to do that. You need to select to map custom fields so that the fields in your excel spreadsheet get added to the correct fields in the Outlook Contact.
0
 
LVL 10

Expert Comment

by:jfromanski
ID: 26102262
Export process was for prepare "good" Excel template, without field mapping. Having this template paste your data into right columns, then import them.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
This article will help to fix the below errors for MS Exchange Server 2016 I. Certificate error "name on the security certificate is invalid or does not match the name of the site" II. Out of Office not working III. Make Internal URLs and Externa…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question