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?