View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Valeria[_2_] Valeria[_2_] is offline
external usenet poster
 
Posts: 24
Default how to send a workbook shortcut as attachement in an e-mail from a userform

Dear experts,
I am working on a userform and I would like to put in
there a label - when the user clicks on it, an e-mail
message opens that has as an attachment the shortcut to a
certain workbook on a server.
The "to" field should be populated but the user should
have the possibility to change the names if he/she wants
to. Also the subject line should populated. There should
also be a little message in the body of the e-mail.

I do not know how to achieve this - could you please help
me?
Many thanks in advance!
Best regards,
Valeria