move contents of a column

[ashkaan57]

Hi,
I have a spreadsheet that has customer info including email addresses.
Is there a way to make a email (Outlook) distribution list using the
email column or just be able to send emails to all the addresses listed
in that column?

TIA.

 

[Gord Dibben]

You can email directly from Excel easily uisng code from Ron de Bruin's site.

http://www.rondebruin.nl/sendmail.htm

Also his SendMail add-in is quite handy for the task described.

If you wish to add the list to your Outlook address book see a method at this
google search thread.

http://snipurl.com/pssw


Gord Dibben MS Excel MVP