+ Reply to Thread
Results 1 to 7 of 7

Clickable mailto email address in strbody email macro

  1. #1
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    Work Office 365 Home 2019
    Posts
    428

    Clickable mailto email address in strbody email macro

    Hi Team,

    Hopefully an easy fix. I have a macro that sends emails (among many other things). It works fine, but, in the body of that email it offers advice on who to contact if there are issues and provides an email address (see red in the code below).

    Please Login or Register  to view this content.
    It works fine, but what code do I need to wrap around the email address so that it is an actual clickable link? (I tried "href;mailto ..." but it didn't like it )

    Many thanks

    MM

  2. #2
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2404-17531.20128
    Posts
    1,361

    Re: Clickable mailto email address in strbody email macro

    Maybe:
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    Work Office 365 Home 2019
    Posts
    428

    Re: Clickable mailto email address in strbody email macro

    Thanks CheeseSandwich - it does create a link (with a Ctrl+Click to follow link instruction, but it doesn't do anything even when you try that).

    I believe there may be a "mailto" type solution.

    But thank you for trying anyway :-)

    MM

  4. #4
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2404-17531.20128
    Posts
    1,361

    Re: Clickable mailto email address in strbody email macro

    Maybe:

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    Work Office 365 Home 2019
    Posts
    428

    Re: Clickable mailto email address in strbody email macro

    Thanks CheeseSandwich.

    Not sure what I did wrong earlier but that works (for the most part) in that it still requires a "Ctrl+Click" but at least it now opens up an email. I've added a rep

    If there is a way of inserting it so that people just need to click on the link (as they would with any normal email) then that'd be good to learn.

    MM

  6. #6
    Forum Expert CheeseSandwich's Avatar
    Join Date
    12-22-2021
    Location
    Kent, England
    MS-Off Ver
    365 - 2404-17531.20128
    Posts
    1,361

    Re: Clickable mailto email address in strbody email macro

    Thanks for the rep,

    It is only CTRL & Click as it is in a draft - once the mail is sent the end user will not need to hold CTRL

    The CTRL part is for opening your own links from a draft.

    Cheers,
    Cheese

  7. #7
    Forum Contributor
    Join Date
    03-08-2011
    Location
    London
    MS-Off Ver
    Work Office 365 Home 2019
    Posts
    428

    Re: Clickable mailto email address in strbody email macro

    CheeseSandwich.

    Every day's a school day eh!

    Thanks again, I'll close this off as "Solved" now :-)

    MM

+ 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. [SOLVED] Email Send Macro - 0 pulling into CC field when no email address present
    By toriwoo86 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-26-2021, 02:18 PM
  2. attach different worksheet and email them tdifferent email address through macro/vba/addin
    By arunverma004 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-03-2014, 08:20 AM
  3. Replies: 0
    Last Post: 02-21-2013, 04:46 AM
  4. Macro to PDF a sheet in workbook and email (outlook) to an email address in a cell
    By paul_sykes00 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-17-2012, 12:54 AM
  5. Replies: 6
    Last Post: 12-02-2011, 02:14 PM
  6. Macro doesn't automatically resolve All email address when email is drafted
    By sonny.thind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-23-2011, 12:58 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1