Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-27-2013, 01:13 PM
ChuckDrago ChuckDrago is offline add hyperlink in body of Outlook email Windows 7 64bit add hyperlink in body of Outlook email Office 2010 64bit
Novice
add hyperlink in body of Outlook email
 
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
add hyperlink in body of Outlook email 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft