+ Reply to Thread
Results 1 to 2 of 2

Highlight variables in an E-mail

  1. #1
    Registered User
    Join Date
    01-17-2013
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    84

    Cool Highlight variables in an E-mail

    I'm working with the following code to send an e-mail. However, I want to highlight the variables I created. I tried dw_approved.Color = 65535 , however that and others like it haven't work.

    Thanks for the help in advance. FYI, I used references to get this e-mail to work

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor Gregor y's Avatar
    Join Date
    10-24-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2010 32-Bit
    Posts
    276

    Re: Highlight variables in an E-mail

    String variables like dw_approved only hold the raw text and not the associated formatting. To get at that you'd need to work with the Range of the text within the document.

    Please Login or Register  to view this content.
    Last edited by Gregor y; 08-31-2015 at 06:56 PM. Reason: remove +1 from range formulas.

+ 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] Formula to highlight cell based on variables
    By Dena in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 03-04-2015, 06:14 PM
  2. [SOLVED] formula to highlight cell based on two variables
    By Dena in forum Excel General
    Replies: 5
    Last Post: 02-17-2015, 04:00 PM
  3. code to attach the draft mail in new compose mail as attachment in outlook 2010
    By priya1987 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2012, 08:38 AM
  4. Replies: 1
    Last Post: 07-22-2012, 09:26 AM
  5. How to e-mail selected row and use e-mail address in a cell to send e-mail from excel
    By syedalamgir in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-27-2010, 02:15 AM
  6. VBA to copy, highlight cells then e-mail.
    By tmtjamie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-24-2010, 12:58 PM
  7. Replies: 2
    Last Post: 11-25-2005, 06:50 AM

Tags for this Thread

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