+ Reply to Thread
Results 1 to 2 of 2

How to change the font of a hyperlink being added in the body of an email from VBA

  1. #1
    Registered User
    Join Date
    08-23-2012
    Location
    Washington, United States
    MS-Off Ver
    Excel 2007
    Posts
    21

    How to change the font of a hyperlink being added in the body of an email from VBA

    Hi everyone,

    I'm trying to add a hyper link to the body of an email which I am able to do, but I want to use a specific font. The default seems to be New Times Roman but I would like to use Calibri to match the rest of the body of the email.

    Here is my code:
    Please Login or Register  to view this content.
    Does anyone know how I can change the font in the MyScreenTip part of this code to be Calibri?

    Thank you in advance!

  2. #2
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: How to change the font of a hyperlink being added in the body of an email from VBA

    Using the online HTML editor at http://html-color-codes.info/html-editor/ gave me:
    HTML Code: 
    Calibri isn't one of the available fonts, but you should be able to change the arial,helvetica,sans-serif part to Calibri.
    Post responsibly. Search for excelforum.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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