Instead, Outlook uses the field Home Phone.ĭrag Home Ph from the pane on the left and drop it on Home Phone in the right pane. This doesn't have an exact match in Outlook.
For example, in the following example, in your import file the contact's home phone number is in a column named Home Ph.
EXPORTING OUTLOOK CONTACT GROUPS MANUAL
You'll probably need to do some manual mapping. If one matches a column in the CSV file, you'll see your column under Mapped from.
Under To, you see the standard fields that Outlook uses for contacts. Under From, a box shows the column names from your CSV import file. Step 3: Map your CSV file columns to Outlook contact fieldsĬlick the Map Custom Fields button. Make sure the check box next to Import "M圜ontacts.csv" (assuming that's your file name) is selected.ĭon't click Finish yet, because you need to "map" some of the columns in your CSV file to the contact fields in Outlook. If you want a different folder, scroll to find the folder you want to use. Outlook will import only new contacts.Ĭlick Next and choose where you want to store your new, imported contacts. If you're confident the information for existing contacts in Outlook is the same as the contacts in your import file, you can choose not to import duplicates. If you already have information on some of the same contacts in Outlook, choose to create duplicates instead.Ĭreating duplicates is the safer option. Replacing duplicates deletes existing contacts, if Outlook finds a match for the contact's name (or some other field, as explained in the section about mapping, below). Under Options, choose whether to replace duplicates (existing contacts), create duplicate contacts, or not import duplicates. This starts the Import and Export Wizard.Ĭhoose Import from another program or file and click Next.Ĭhoose Comma Separated Values and click Next.Ĭlick Browse and locate the saved CSV file. In Outlook, click File > Open & Export > Import/Export. Now, you can start the import process in Outlook. xlsx file) closes, but no changes are made to it. When Excel tells you "Some features in your workbook might be lost", click Yes to save the current worksheet as a CSV file. The message refers to a limitation of the CSV file nothing will happen to your original workbook (the. If Excel tells you "The selected file type does not contain workbooks that contain multiple sheets," click OK. In the Save as type box, choose CSV (MS-DOS) (*.csv), give it a file name, and click Save. In your workbook, click the worksheet with the contact information you want to import. Outlook can't import workbooks with multiple sheets, but it can import comma-separated value (.csv) files. Step 1: Save your contact information from Excel in a file that Outlook can import Map the Excel spreadsheet columns to the appropriate Outlook fields. Get your contact data ready to be imported. But, you can do it by following these four steps: Unfortunately, Outlook can't automatically create a contact group from a list of contacts in Excel. With a contact group, you can send emails and meeting invitations to people without having to add each name every time. Then you can create a contact group (formerly called a "distribution list") using the imported contact information. If you have a lot of business or personal contacts that you keep in an Excel spreadsheet, you can import them straight into Outlook.
0 kommentar(er)
