send hyperlink from excel file

[striker83716]

Hi all and thanks for your help in advance.

What I would like to do is create a button on an Excel worksheet that does the following.
Starts an email & inserts a hyperlink in the body of the email.

This hyperlink will take the receipent of the email back to the excel workbook.

This code will be originally in a xlt file and of course the hyperlink will need to change with the renaming of the xls files. I am just stating this so that I do not get ideas of using a "static" hyperlink address.

Thanks guys, I really enjoy the site and have been able to find most of my answers from searching, but have not come up with anything for this problem.

Rob

 

[striker83716]

I failed to mention that the location of the xlt file and the xls files will be on the company network.