ACCESS FEED: Re: [MS_AccessPros] Bold in a email text message

Minggu, 12 Januari 2014

Re: [MS_AccessPros] Bold in a email text message

Orlan-

Not sure you can do it with SendObject. Is the resulting email in Plain Text, or is it HTML or RTF? If the latter two, then you could try adding <B> in front of the text you want to be bold and </B> at the end. <Strong> and </Strong> do the same thing.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Jan 12, 2014, at 6:28 AM, <orlanvj@gmail.com> <orlanvj@gmail.com> wrote:

I am using the following to write an automatic email

MessText1 = Me.FirstName & "," & vbCrLf & vbCrLf & _
            "We have registered you for the following classes:" & vbCrLf & vbCrLf

MessText2 = "Day" & vbTab & vbTab & "Class Num - Instructor" & vbCrLf

MessText3 = "Monday:" & vbTab & Me.Monday & IIf([Monday] > 0, "A - " & txtInstMon, "") & vbCrLf & _
            "Tuesday:" & vbTab & Me.Tuesday & IIf([Tuesday] > 0, "B - " & txtInstTue, " ") & vbCrLf & _
            "Wednesday:" & vbTab & Me.Wednesday & IIf([Wednesday] > 0, "C - " & txtInstWed, " ") & vbCrLf & _
            "Thursday:" & vbTab & Me.Thursday & IIf([Thursday] > 0, "D - " & txtInstThu, " ") & vbCrLf & _
            "Friday:" & vbTab & vbTab & Me.Friday & IIf([Friday] > 0, "E - " & txtInstFri, " ") & vbCrLf & _
            "Saturday:" & vbTab & Me.Saturday & IIf([Saturday] > 0, "F - " & txtInstSat, " ") & vbCrLf & vbCrLf & _
            "We look forward to seeing you in class." & vbCrLf & vbCrLf &

            DoCmd.SendObject _
            ObjectType:=acSendNoObject, _
            To:=Me.Email, _
            Subject:="Class Registration", _
            MessageText:=MessText1 & MessText2 & MessText3, _
            Editmessage:=True

Originally this was one single 'line' label MessText. I broke it into three parts. What I want is the MessText2 to appear in bold. Can anyone suggest a way to put just part of the message in Bold?

Orlan