I have set up some code to send an e-mail.
Is it possible to change some of the text to bold?
This is what i have so far, it all works, but im trying to make it look clearer:
strTitle = Nz(DLookup("Title", "TblTitle", "[No] = " & Me.No), 0)
strScope = Nz(DLookup("Scope", "TblTitle", "[No] = " & Me.No), 0)
strName = Nz(DLookup("FirstName", "TblEmailAdd", "[ID] = " & Me.Action), 0)
strAddress = Nz(DLookup("EmailAdd", "TblEmailAdd", "[ID] = " & Me.Action), 0)
strSubject = "Actions for Meeting Number " & Me.MeetingNo
strBody = "Dear " & strName & "," & vbCrLf & _
"You have been set as an actionee for the following action:" & vbCrLf & vbCrLf & _
Me.Detail & vbCrLf & vbCrLf & _
"Please action as required before " & Me.ActionDate & "." & _
vbCrLf & "Thank you."
If strAddress = "" Then
MsgBox "This Actionee is missing an e-mail address"
Else
DoCmd.SendObject , , , strAddress, , , strSubject, strBody, True
End If
I would idealy like the me.detail part to come out in bold. I tried me.detail.fontbold, but that didnt work.
Also, is it possible to change the font in the actual text (eg in the text "Please action as required before.." could you make the before italic?
Any help would be much appreciated.
Thank you!
Is it possible to change some of the text to bold?
This is what i have so far, it all works, but im trying to make it look clearer:
strTitle = Nz(DLookup("Title", "TblTitle", "[No] = " & Me.No), 0)
strScope = Nz(DLookup("Scope", "TblTitle", "[No] = " & Me.No), 0)
strName = Nz(DLookup("FirstName", "TblEmailAdd", "[ID] = " & Me.Action), 0)
strAddress = Nz(DLookup("EmailAdd", "TblEmailAdd", "[ID] = " & Me.Action), 0)
strSubject = "Actions for Meeting Number " & Me.MeetingNo
strBody = "Dear " & strName & "," & vbCrLf & _
"You have been set as an actionee for the following action:" & vbCrLf & vbCrLf & _
Me.Detail & vbCrLf & vbCrLf & _
"Please action as required before " & Me.ActionDate & "." & _
vbCrLf & "Thank you."
If strAddress = "" Then
MsgBox "This Actionee is missing an e-mail address"
Else
DoCmd.SendObject , , , strAddress, , , strSubject, strBody, True
End If
I would idealy like the me.detail part to come out in bold. I tried me.detail.fontbold, but that didnt work.
Also, is it possible to change the font in the actual text (eg in the text "Please action as required before.." could you make the before italic?
Any help would be much appreciated.
Thank you!