Create outlook email distribution list from excel
Note that the copied data contains OLE information and if the other program supports OLE, you may paste the data as contacts, not plain text data. See Adding Extended MAPI Fields to Microsoft Outlook for instructions to add the from address field to the view.Ĭreating and copying from a table view is a cool trick that can be used in place of export to create contact lists for use outside of Outlook, including as a data source for a mail merge when your Outlook and Word versions are mismatched.īecause only the fields used in the view are copied, you can easily control the data you are copying.
You do not need a display name column, just the email address. You can use this method with any semi-colon delimited list of addresses or when the addresses are on separate lines.
If you paste them into Word or an Outlook message or Notes field, you need to use Paste Special, as Text.
Once you have the list of addresses, you can convert it to a distribution list one of two ways. Outlook should warn you if you are creating duplicates, but if not, there are duplicate contact remover utilities at Remove Duplicate Contacts from Microsoft Outlook. We have a VBA sample that can create contacts using sender's addresses or look for these utilities at Data Entry and Updating Tools for Microsoft Outlook. While this is still much too slow if you have a large number of emails, there are several add-ins that will capture the addresses and create contact records for you. Rather than copying and pasting addresses, just right click on the sender's address, either in the preview pane or open message, and choose "Add to contacts". Is there a simple, fast way capture all of the addresses at once? The final result is a Contact Group directly created from an Excel list.I have several hundred emails archived in Outlook and I want to create a mass distribution list without opening each email and pasting the addresses into my address book.