This article will outline the steps to import contacts stored in Microsoft Excel to your Contacts on your device. Note that this will work for both Pocket PCs and Smartphones. Before we start, make sure that you clear your Excel spreadsheet of any unwanted or unnecessary info.
Open your spreadsheet
Select all data
With your list selected, create a Name Range (Insert > Name > Define) and give it any name you want.
Save and Close Excel
Open Outlook on your computer
Click File > Import & Export (I&E)
In I&E wizard, select Import from another program or file. Click Next.
In Import a file window, select Microsoft Excel.
Browse to the location where you saved your Excel file. Click Next.
Select the destination folder, which should be your default Contacts folder. Click Next.
Check the Name range you defined in Excel.
Click the Map Customs Fields button.
Drag values from the source file on the left & drop them on the appropriate destination field on the right. Click OK.
Click Finish. Outlook imports the file.
Connect your device to your PC and synchronize.
No comments:
Post a Comment