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:
In a new Outlook message, I Paste them into the To field. They’ll start off in a column like you see here:
But in a matter of seconds, they’ll resolve to the normal semicolon-delimited format, and you’re ready to send:
It definitely beats trying to retype them by hand, or reformat them in Notepad…
One Minute Office Magic 