how can I create a distrubtion list from excel

G

Gene

I have a list of email addresses I'd like to use for a distribution list
without having to re enter them one at a time. is there a way to cut & paste
that field into a list for Outlook. I have Office 2003 suite and Outlook
2007 (my company thinks that's the best good combination - but that's another
topic)
 
J

Jarek Kujawa

one way:

addresses being located in column A, starting from A1

in B2:

=A1&";"&A2

in B3:

=A3&";"&B2

copy down

select the last cell in the range
copy->PasteSpecial->Values it
edit the cell by pressing F2 or clicking on the formula bar
copy the string and paste Outlook message

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I easily create an Outlook distribution list from excel? 1
Adding email addresses from Excel into Outlook 1
Distribution list from Excel 2
can i create a distribution list between excel and outlook? 8
Distribution list with a distribution list problem 3
Create a distribution list by copying names from e-mail 5
how do I create email list from individual emails in Excel cells? 2
How do I create an Outlook distribution list from an Excel column 2

Top