View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BN-CD BN-CD is offline
external usenet poster
 
Posts: 1
Default E-Mail as Hyperlink


I have a macro that generates an investigation form, saves it to th
network. I would like to place a button on the worksheet to send th
worksheet as a hyperlink. This way when the people who receive it ca
fill it out and just save it when they are complete.
I have read through several (seems like 100's:( ) posts and help file
but can't seem to find the right code to make an e-mail with
hyperlink. Being new to writing macros I'm pretty much confused at thi
point. (too much research...LOL)

Everything I have tried makes the workbook an attachement not
hyperlink.

Thanks in Advance

--
BN-C
-----------------------------------------------------------------------
BN-CD's Profile: http://www.excelforum.com/member.php...fo&userid=3537
View this thread: http://www.excelforum.com/showthread.php?threadid=55148