Results 1 to 6 of 6

I am using a VBA code that sends emails

Threaded View

starlev I am using a VBA code that... 05-15-2015, 11:30 AM
daffodil11 Re: I am using a VBA code... 05-15-2015, 11:37 AM
starlev Re: I am using a VBA code... 05-17-2015, 09:48 AM
daffodil11 Re: I am using a VBA code... 05-18-2015, 09:19 AM
starlev Re: I am using a VBA code... 05-20-2015, 07:42 AM
Kyle123 Re: I am using a VBA code... 05-20-2015, 08:28 AM
  1. #1
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    191

    I am using a VBA code that sends emails

    Hi
    I am using a VBA code that sends emails
    In a using a string that stores text in a string named Temp_Body then I use a HTMLBody for the text that will be sent in the email
    Here is the code that I use:

    HTMLBody = Temp_Body & vbNewLine & vbNewLine & RangetoHTML(rng)
    Is there anyway I can change the color and font of the Temp_Body?

    Thank you in advance for your help.
    Last edited by starlev; 05-15-2015 at 11:34 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 04-13-2016, 08:46 AM
  2. Need a macro that sends out emails from outlook base off of dates in excel
    By Wery123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-11-2015, 10:20 PM
  3. Use of CDO code to send emails failing
    By DEB1000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2015, 03:49 PM
  4. Help with code to send automatic emails
    By hauckj14 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-16-2015, 12:45 PM
  5. Help! Macro that sends auto emails based on date
    By just2005 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-17-2014, 08:20 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