I have created an excel sheet with lots of different email addresses. I am now wanting to either create a distribution list in outlook with these or simply send an email to all the addresses in excel. Is this possible? Thank you!!
Seven years ago I was trying to do something similar:
thread707-495489
You can copy and paste from excel into your email "To" field.
Have you tried doing this into your ADD distribution list option in your email client/address book?
It is easy to create a distrbution list from email addresses in Excel for Outlook 2003 (it may work with other versions of Outlook as well).
In Excel, make sure the person's name and email address are in consecutive cells like this:
NameEmail
Joe Schmoe jschmoe@ schmoeco.com
Mary Schmoe mschmoe@ schmoeco.com
Copy all of the data in the Name and Email fields.
Create a new - or open an existing - distribution list.
Click the Select Members button
On the resulting screen, you will see a Members-> button with a text input box for either typed email addresses or selections from your contacts list. Put your cursor in the box and Ctrl-V to Paste. All of the email info will be pasted in the box. The column headings will also come over, so go to the top of the list and delete those. Click OK and your distribution list is generated with both the person's name and email address.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.