Hi Steve

Have you set the reference to Outlook in that other workbook also ?
You must do that in every workbook or you can use Late binding.
See my site for a example

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


"Steve" wrote in message ...
I used a macro from Ron's website to mail each worksheet to the email
address in cell a1. I ran this macro and it worked perfectly for one
workbook BUT... when I tried to use it for another workbook I got the
follwing error message "Microsoft Visual Basic Compile Error Can't find
project or library Ok Help".

Help me please... do I have to check some more references in the VBA tools?

Thanks,

Steve