Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word

LinkBack Thread Tools Display Modes
Old 06-27-2013, 01:13 PM
ChuckDrago ChuckDrago is offline Windows 7 64bit Office 2010 64bit
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!
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Format email body-Using Excel VBA to send mail Claytocb Excel Programming 1 01-31-2013 11:58 PM
Outlook not sending body of email sbertram Outlook 0 08-30-2012 11:50 AM
Hyperlink to direct email JaHoffman Word 5 07-05-2012 08:09 AM
cannot access hyperlink in email mdrvo Outlook 1 05-31-2010 12:35 PM
Cannot hyperlink from an email karen1430 Outlook 0 11-25-2007 03:54 PM

All times are GMT -7. The time now is 08:27 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft