#Add new contacts to outlook from excel how to#
Whether you use contact groups or simple categories to group contacts, Outlook can help you save time by emailing any size group.įor more information about contact groups and categories, and Bcc, check out the links in the Course Summary.By Michael Bose A Guide on How to Import Contacts to Outlook 365Įmail users usually save the addresses of other users to a contact list or address book. To send email to the contact group, type the group name on the To line, or type it on the Bcc line if you want to hide the addresses from recipients. Select all the contacts in the list and add them to Members. Open the address book list and select the contacts folder we created. Type a name, click Add Members, and From Outlook Contacts. The Excel list is now added to your contact folder as new contacts.įinally, let’s add the contacts to a new group, and we can add it to the new folder. We don’t need to worry about mapping the other columns now. That’s probably because Outlook was looking for E-mail with a dash, and our 'email' column doesn’t have a dash.īut, we can add the mapping manually by dragging email from the list on the left and dropping it on the Outlook e-mail field. Let’s see how Outlook plans to map the email addresses. Here, the contact name field is correctly mapped from the Excel Name column. This is where we need to go to make sure the information is mapped correctly from the Excel columns to the Outlook contact fields.
Select Import from another program or file, select Comma Separated Values, browse for the Excel CSV file we just created, and for a destination folder, select the one we just created.
Now, click FILE, Open & Export, and Import/Export. We’ll place the Excel list in this folder to keep it separate from the other contacts. In People, right-click the Contacts folder you want to add the Excel list to, and create a New Folder. Save the mailing list as a new file in the CSV format and click Yes. Type a file name, click Save as type, and then select CSV (Comma delimited). In Excel, click FILE, Save As, and choose a location. So, this process works for quickly adding addresses to a contact group.īut, if you also want to create Outlook Contacts from the Excel list, then you need to follow a different process and import the Excel file. You can do the same thing to quickly copy email addresses from other sources, like email, text files, or Word documents. The names are added to the contact group. Then, in Outlook, click the Members text box, Paste the text, and click OK. Now, select the names and addresses in both columns, and Copy them to the clipboard. Next, open the workbook in Excel and arrange the worksheet so that the user Name column is adjacent to the Email address column.įor example, you can select the columns that are between the two, right-click the selection, and click Hide.ĭon’t worry. Type a name for the group, click Add Members, and From Outlook Contacts. In Outlook, click People, select a Contacts folder, and add a New Contact Groupto the folder. Well, here is a really fast way to do that using contact groups. Let’s say you periodically send email to a mailing list that you maintain in an Excel workbook.
0 kommentar(er)
