Getting a list of email addresses in Excel into Outlook

This little trick is handy if you have a list of email addresses in Excel, and you want to use that list to send everyone an email using Outlook. It’s really nothing more than copy and paste!

In this example, I have four email addresses in Excel. I’ve highlighted them and did a Copy command:

excel-emailaddressestooutlook-20170718-1

In a new Outlook message, I Paste them into the To field. They’ll start off in a column like you see here:

excel-emailaddressestooutlook-20170718-2

But in a matter of seconds, they’ll resolve to the normal semicolon-delimited format, and you’re ready to send:

excel-emailaddressestooutlook-20170718-3

It definitely beats trying to retype them by hand, or reformat them in Notepad…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s