Thread: Mailing Excel workbooks that are not active workbook
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Mailing Excel workbooks that are not active workbook
You can't use SendMail Beverly for this
If you use Outlook then look at this example
http://www.rondebruin.nl/sendmail.htm#file


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Beverly" wrote in message ...
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


Reply With QuoteReply With Quote