I don't use XL2000, so I'm not sure the code I use will work. You will need
to add a reference in the VBE to the Outlook object model version you are
using. There are many excellent examples of code that will help you do what
you describe at Ron de Bruin's web site http://www.rondebruin.nl/tips.htm
and http://www.rondebruin.nl/sendmail.htm