View Single Post
 
Old 06-28-2013, 06:51 AM
ChuckDrago ChuckDrago is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2013
Posts: 2
ChuckDrago is on a distinguished road
Default Insert a hyperlink in body of email

Hi everyone,

I have a Word document that includes its emailing to an approver, who is supposed to either approve (sign) or reject it with comments. Everything is VBA coded and works to perfection, save one detail: if I send the document as an attachment, it goes only as a read-only and when the user enables editing it screws up my macro control.

Therefore, I'd like to sent it as a hyperlink instead, and in the process I'd like this to be a fully automated action. That is: I can build the full path to the document by just using ActiveDocument.FullName but I do not know how to insert such string as a hyperlink in the body of the email without the emailer's having to type it.

Any help will be much appreciated.
Chuck
Reply With Quote