[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

How do I highlight text in a message body with VBA?

Posted on 2009-07-13
1
Medium Priority
?
1,903 Views
Last Modified: 2013-11-05
Hello,

My task is to compare the bodies of two messages using VBA and highlight the text of the second message where the values are different. I am using the following code to split the lines of the message bodies into string arrays using the Split function and then loop through the lines and compare them. I am attempting to enclose each line with <div> tags and apply a style to change the text color. I later set the BodyFormat property to olFormatHTML when I send the final message but the resultant markup is displayed in the message. Is there another possible solution to this problem?
Dim beginRedDiv As String, beginBlackDiv As String, endDiv As String
    beginRedDiv = "<div style='color:red;'>"
    beginBlackDiv = "<div style='color:black;'>"
    endDiv = "</div>"
    
    Dim oldUpdateMessageBody() As String, newUpdateMessageBody As String, newTranscriptionMessageBody() As String
    
    oldUpdateMessageBody = Split(OriginalMessage.Body, vbCrLf)
    newTranscriptionMessageBody = Split(mUpdateMatchMessage.Body, vbCrLf)
    
    Dim i As Integer
    For i = 0 To UBound(oldUpdateMessageBody)
        If oldUpdateMessageBody(i) <> newTranscriptionMessageBody(i) Then
            newUpdateMessageBody = newUpdateMessageBody & beginRedDiv & oldUpdateMessageBody(i) & endDiv
        Else
            newUpdateMessageBody = newUpdateMessageBody & beginBlackDiv & oldUpdateMessageBody(i) & endDiv
        End If
    Next

Open in new window

0
Comment
Question by:Curto123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 

Accepted Solution

by:
Curto123 earned 0 total points
ID: 24843935
I seem to have found the solution on my own. I just needed to dig a little more. It seems all I needed to was use the HTMLBody property of the final message instead of the Body property. My text is now colored appropriately.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question