Consulting

Results 1 to 3 of 3

Thread: Change font of msg body using VBA

  1. #1
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location

    Change font of msg body using VBA

    I have a message that I created and saved as a draft (.oft). It was saved in the format I wanted it: four dates in a sentence, dates are bolded.

    I am programming this from Excel via VBA.

    Outlook is referenced making use of Early Binding.

    I run my code, which inserts the correct dates into the correct locations of the body, then displays the message. But the formatting is lost.

    Is there anyway to retain the formatting or add formatting to the existing/altered body of the mail message?

    I can post the code if you like, but it's quite large. I am using a dialog sheet to populate with checkboxes which then will be taken to the mail message body.

    This is not an emergency of any kind, just more of a minor question, the routine works exactly the way I intended it to.

  2. #2
    VBAX Expert Shazam's Avatar
    Joined
    Sep 2005
    Posts
    530
    Location
    This link might help you but not sure.


    http://www.danielklann.com/excel/sen...s_the_body.htm

  3. #3
    Site Admin
    Urban Myth
    VBAX Guru
    Joined
    May 2004
    Location
    Oregon, United States
    Posts
    4,940
    Location
    Sorry, forgot to mention, I do not use HTML at all and Word is not my default mail editor.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •