Import contacts to outlook from excel6/26/2023 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. |