Tuesday, February 11, 2014

Steps To Import Contacts From Excel Spreadsheet To Outlook

Microsoft Excel can be termed as a spreadsheet application which comprises of advanced features such as graphical tools and pivot tables. These enable users to organize, store and manipulate data in Excel. A spreadsheet in Microsoft Excel can hold different types of data, such as text, numbers or formulas. Sometimes, you would like to import the contacts that you have stored in Excel to Microsoft Outlook, for emailing. Instead of manually re-typing these contacts, you can import all of them together to Outlook. If you face issues regarding this, you can always seek help with Outlook tech support.

You can also try the following instructions to import contacts from Excel spreadsheet to Outlook, before contacting technical support.
  • In the first step, ensure that you have a header row in your Microsoft Excel Sheet. Now, if the full contact name is in one cell, you need to break the name into separate cells.
  • Once you enter the name, you need to highlight the entire full name column. Now, go ahead to Data, Text and then to Columns, which would bring up the wizard.
  • Now, go to the Original data type option and select delimited. Then, click the box next to SPACE. Now you will see an option asking how you want it to be formatted. Here, click on the TEXT option.
  • Now, the wizard would ask you if you want to replace the destination cells, so you if you have already inserted the columns, click on Yes.
  • Now, again open the Microsoft Excel sheet, and highlight all the data that you want to import into Outlook. In the next step, you should click on Insert, Name followed by Define, and then Save the Excel file and exit. Meanwhile, if you have any queries, you can also call the technical support number to get help with Outlook issues.
  • In the next step, you need to import the contact information in Outlook. For this, you need to click on the option File, Import/Export, followed by Import from another program or file, and then Excel.
  • Now, you can check the Define mapped fields option to start the import of your contacts to Microsoft Outlook.
These steps would help you to successfully import contacts from an Excel spreadsheet to Microsoft Outlook. To get more information on Excel, feel free to contact our technical support team.

No comments:

Post a Comment