Checkout the below link

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

If this post helps click Yes
---------------
Jacob Skaria


"Sverre" wrote:

Is it possible to send different sheets from a workbook to different
e-mailadresses-
on one command
example:
Sheet 1 to email 1
Sheet 2 to email 2

Du I have to create a new woorkbook or is it possible to do this directly from
the woorkbook with the collection of sheets.