![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |