View Single Post
 
Old 06-27-2013, 01:13 PM
ChuckDrago ChuckDrago is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2013
Posts: 2
ChuckDrago is on a distinguished road
Question add hyperlink in body of Outlook email

First of all my salutation to all (I'm a new member, coming from the Excel forum).
My macros control the generation, editing, printing and routing of a Word document (Job Description, or JD). A segment of the process is to send the JD to principals, for approval. The Open macro recognizes the receiver by checking his/her login, extracting his/her title and execute the corresponding Case select to present the user the appropriate UserForm, containing all commands available at that particular stage.

Excuse the verbosity, but I wanted to present the overview of the app. The problem is that attached documents only open as read-only and when the receiver clicks on Enable Editing, the initial macros are skipped and not executing the appropriate case.

Now the real question: Instead of attaching the JD to the automated email, I'd like to add a hyperlink pointing to its file location, so that the principal clicks on it and it opens as desired. That hyperlink should be inserted in the body of the email text, within the Outlook object. Or, if anyone knows of a better placement, I'll take any and all advice.

The objective is to use VBA and avoid having users type the path and filename, since they are available via ActiveDocument.Name and FullName for the whole path.

Thanks a bunch!
Chuck
Reply With Quote