+ Reply to Thread
Results 1 to 1 of 1

Avoid triggering the mailto hyperlink

  1. #1
    Registered User
    Join Date
    05-12-2015
    Location
    Cali, Colombia
    MS-Off Ver
    2013
    Posts
    2

    Question Avoid triggering the mailto hyperlink

    Good morning everybody. Thanks for your attention and apologies in advance if this has been asked before.

    I have a spreadsheet with several contacts and emails. At work, we send emails to these contacts on a regular basis, tailored through some specific templates. I've created a code that, when you click a mailto: hyperlink, a small form with a dropdown menu shows up so we can select the template to use, and when clicking a command button, it composes an email using Outloook, populating the body of the email with the template and the contact, company name, subject, etc.

    All of that works perfectly.

    However, it not only opens the userform; it also opens a new, blank email, as it would without the code.

    Is there any way to prevent that from happening? To only execute my code when clicking the email address?

    Thanks in advance

    EDIT: the Worksheet_FollowHyperlink cannot be trapped. My solution was to do this on Worksheet_SelectionChange and verifying if the Target had a "@" in the value, which would ensure it was an email, then trigger my code.
    Last edited by Large114; 05-13-2015 at 09:45 AM.

+ 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. MAILTO hyperlink email issue
    By Nans434 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-25-2012, 01:00 PM
  2. mailto hyperlink within button?
    By jamer02 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-28-2011, 07:46 AM
  3. mailto hyperlink within button?
    By jamer02 in forum Excel General
    Replies: 0
    Last Post: 06-28-2011, 06:09 AM
  4. Zeilenumbruch in mailto:-Hyperlink
    By loriot in forum Excel General
    Replies: 1
    Last Post: 10-18-2005, 11:05 AM
  5. =hyperlink() for mailto:
    By README in forum Excel General
    Replies: 2
    Last Post: 02-25-2005, 11:06 AM

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