Email automatically out of excel

[Sabine]

I have a workbook with approx. 200 tabs that I would like
to send individually via email(different email address per
tab. Is there a way to do this? I could also separate the
tabs into separate workbooks. Email system is outlook.
..

 

[John Wilson]

Sabine,

E-Mail from Excel with Outlook????
You're in luck.
Ron has a whole page devoted to the subject and even an
Add-In to automate the process.

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

John

 

[John Wilson]

Sabine,

Just realized that you wanted the 200 tabs to 200 different people.
Not sure if the Add-In will do this but it surely can be done with VBA
and the link I gave you will give you a very good start on how.

John

 

[Frank Kabel]

Hi Sabine
maybe the information on Ron's site will help you:
http://www.rondebruin.nl/sendmail.htm

Frank