I've an excel file and they are a lot of informations on it, included emails
addresses.

I'd like to retrieve those emails addresses automatically from the selected
worksheet, detecting the "@" caracter and then export to outlook or ";"
separated list wich I will use to send emails.

How to do so ? It's there an easy way ?

Bob

Hi Bob

This macro will collect them all
http://www.rondebruin.nl/find.htm#Copy

You can save the file (csv ) and import in Outlook


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Bob Bedford" wrote in message ...
I've an excel file and they are a lot of informations on it, included emails addresses.

I'd like to retrieve those emails addresses automatically from the selected worksheet, detecting the "@" caracter and then export
to outlook or ";" separated list wich I will use to send emails.

How to do so ? It's there an easy way ?

Bob