+ Reply to Thread
Results 1 to 6 of 6

Insert hyperlink in email

  1. #1
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Insert hyperlink in email

    I frequently send emails (from Outlook) like this:

    Kenny, Tim,

    [Some document name] is on the share.


    I copy the path on the share, select the words "on the share" in the email, right-click, select Hyperlink, and paste from the clipboard into the Address textbox. A macro would be handy.

    Outlook uses Word as an editor, and this does what I want in Word:

    Please Login or Register  to view this content.
    I'd be grateful if some kind soul would show me how to code it for Outlook.

    Cross-posted at https://www.mrexcel.com/board/thread...email.1190042/
    Entia non sunt multiplicanda sine necessitate

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,306

    Re: Insert hyperlink in email

    I think something like this would be the literal equivalent:

    Please Login or Register  to view this content.
    Rory

  3. #3
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Insert hyperlink in email

    That looks great, Rory, thank you. Creating the DataObject object (which worked in Word) failed in Outlook, so I recoded as below and added a reference:

    Please Login or Register  to view this content.
    I was sure that was going to work, but the Hyperlinks.Add statement failed: "Object doesn't support this property or method." Got any magic for that?

    If it matters, the message is in HTML format.
    Last edited by shg; 12-13-2021 at 02:07 PM.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,306

    Re: Insert hyperlink in email

    It should just be:

    Please Login or Register  to view this content.
    rather than:

    Please Login or Register  to view this content.

  5. #5
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Insert hyperlink in email

    Of course, thank you.

    I find the property naming odd that Inspector.WordEditor returns a Word document rather than the application object.

    Thank you again, Rory.

    Final code posted below for anybody that doesn't want to do their own edits.
    Please Login or Register  to view this content.

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    7,306

    Re: Insert hyperlink in email

    Quote Originally Posted by shg View Post
    I find the property naming odd that Inspector.WordEditor returns a Word document rather than the application object.
    As do I! (but then there’s nothing normal about Word)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Insert hyperlink to file in vba generated email?
    By skhan5427 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2020, 07:19 PM
  2. Replies: 1
    Last Post: 12-23-2014, 07:39 PM
  3. how to insert a hyperlink in an email generated using VBA?
    By mekha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2014, 02:24 PM
  4. [SOLVED] insert a hyperlink into an excel cell to refer to a specific email in outlook
    By Joe McLoughlin in forum Excel General
    Replies: 3
    Last Post: 08-03-2012, 05:25 PM
  5. [SOLVED] Insert Hyperlink And Send Email
    By Shahid_Excel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2012, 09:49 AM
  6. how to insert an email hyperlink in an excel header
    By need help in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-05-2006, 03:00 AM
  7. Insert Hyperlink in body of email
    By MAYDAY in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-04-2005, 12:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06452 seconds
  • Memory Usage 9,054KB
  • Queries Executed 15 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (6)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (6)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (6)postbit_legacy
  • (6)postbit_onlinestatus
  • (6)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (48):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • bbcode_parse_start
  • postbit_imicons
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1