Supposing I had a list of email addresses in an Excel spreadsheet, which I pulled from a database. I need to do a mail merge with each of these email addresses, such that each recipient only sees their own email address in the To: field.



I do have each of these email addresses in my contacts (I think), because each of them has sent an email to me. But I think I also need to get them into a distribution list.

Is there any way I can populate this distribution list by grabbing them all of them at once, from Excel, and pasting them in? It appears that every option offered by Outlook requires doing it one. address. at. a. time. And it's a hundred email addresses... could be a thousand next time. What to do?

Is there some reason you want a distribution list? You cannot use a dist list as the data source for a mail merge. You can use the Excel file as the data source or, if you want the email addresses to be in Outlook, you can import the Excel file to a subfolder in Contacts and use that subfolder as the data source.

Of course, if you decide you don't care about their email address being in the To box, you can skip the mail merge and just use a dist list to fill in the Bcc box instead of the To box.