Instead, Outlook uses the field Home Phone.
See screenshot: And now you will see the specified text file is imported and placed at the specified range.
If youre always emailing the same group of people, you can create a contact group (previously called a distribution list) that includes all of the recipients by jsp for dummies pdf using a previous email that you sent to them.Make sure all columns from the CSV file are mapped to the desired Outlook address book fields.This will usually be your Contacts folder.Select the Outlook folder you want to import the contacts to; this will usually be your Contacts folder.Then you can create a contact group (formerly called a distribution list) using the imported contact information.One at a time, drag the rest of the values from the left pane to the appropriate Outlook fields in the right pane.Step 1: Save your contact information from Excel in a file that Outlook can import Outlook cant import workbooks with multiple sheets, but it can import comma-separated value (.csv) files.Contacts should be selected by default.Button the select the desired file.In either case, make sure you do not select the row containing the headers.The keyboard shortcut for this is: ctrlshiftl.
In the window that opens, right-click inside the Members box, and click Paste, or press CtrlV.
Note: Some locales use different list separators by default.
Outlook will import only new contacts.
This starts the Import and Export Wizard.
Press ctrlc to copy the selected cells.But you can find a suitable match in Outlook by doing this: Scroll down in the pane on the right, and you'll find Other Address, which has a plus sign ( ) next.Click Save and Close.You can create new mappings by dragging the column title to the desired field.In the pane on the left, drag Cell Ph and drop it on Mobile Phone in the right pane.Launch Microsoft Excel, and click.At the top of your Outlook ribbon, choose.Use the, browse button the select the desired CSV file.To learn how to use your new contact group, see.