Hi

If you use Outlook ?
http://www.rondebruin.nl/sendmail.htm


Use links in the body

..Body = "file://Yourcomputer/YourFolder/Week2.xls"

If there are spaces use %20
..Body = "file://Yourcomputer/YourFolder/Week%202.xls"

Example for a file on a website
..Body = "http://www.rondebruin.nl/files/EasyFilter.zip"



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



"BN-CD" wrote in message
...

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

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

Thanks in Advance!


--
BN-CD
------------------------------------------------------------------------
BN-CD's Profile: http://www.excelforum.com/member.php...o&userid=35374
View this thread: http://www.excelforum.com/showthread...hreadid=551489