Hi!

Take a look at this:

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

Ron is the undisputed expert at integrating Excel and email.

Biff

"billy2willy"
wrote in message
...

I have different departments (about 18) that I report on, but have them
combined in one workbook. I would like to send them the applicable
worksheet as an attachment and just the worksheet that applies to them.
Is there some way I can load a different email address for each
worksheet, press a button and have them all sent at once, only
containing the applicable information for their department?


--
billy2willy
------------------------------------------------------------------------
billy2willy's Profile:
http://www.excelforum.com/member.php...o&userid=21648
View this thread: http://www.excelforum.com/showthread...hreadid=386336