+ Reply to Thread
Results 1 to 4 of 4

Text to Bold, sending to email/Outlook

  1. #1
    Registered User
    Join Date
    08-16-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    11

    Text to Bold, sending to email/Outlook

    Hello All

    Let me preface this by saying, I am self taught and very new to VBA.

    On that note, I am trying to modify some code so that when I send from excel to Outlook, somearea are bolded and while others are hightlighted in red.

    Please Login or Register  to view this content.
    Hoping someone could point me in the right direction

    Thank you in advance

    Kind Regards
    Sagittariu5
    Last edited by Sagittariu5; 11-20-2013 at 11:07 AM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,642

    Re: Text to Bold, sending to email/Outlook

    Hi there,

    To display text using a Red font use:

    Please Login or Register  to view this content.

    To display text using a Bold font use:

    Please Login or Register  to view this content.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

  3. #3
    Registered User
    Join Date
    08-16-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Text to Bold, sending to email/Outlook

    Hello Greg M

    Thanks for your help, the above works is I change the
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    Thanks for the insight

    Kind Regards
    Sagittariu5

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,642

    Re: Text to Bold, sending to email/Outlook

    Hi again Saggitarius,

    Many thanks for your feedback, and sorry for not including the fact that you needed to operate on "htmlbody" rather than on "body".

    Glad to hear that everything's working correctly for you now.

    Thanks also for the Reputation increase

    Best regards,

    Greg M

+ 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. Sending Email of workbook through Outlook
    By naveenmarapaka in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2012, 09:29 AM
  2. [SOLVED] sending email from outlook using vba excel
    By joshshaji in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-31-2012, 08:27 PM
  3. Sending Email via Outlook
    By jamsta1972 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-26-2010, 12:46 PM
  4. Sending an email with Outlook Express not Outlook
    By Steven811 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-05-2010, 04:23 AM
  5. Sending Outlook email pop up box
    By jamphan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2007, 03:56 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