I would like to write code that would send a specific workbook to a specific person. However, there are 20 workbooks that go to 20 different people. How can I replace "activeworkbook" in the SendMail syntax with the specific name of a file (that isn't the open active workbook).

I sure appreciate any guidance you can give me.

-Beverly