Selasa, 15 Mei 2012

[MS_AccessPros] Using VBA to change a title to bold

 

Ok,
I have a user that wants the following to display in an email. I got everything working except now they want to see the field title (not a label) bolded for example:

Name: John Smith (User wants only Name bolded)
Email Address: jsmith@yahoo (User wants only Email bolded)
Address: 123 Main (User wants only Address bolded)

Here is part of the code that runs to export info on a form into Lotus Notes. What I need to figure out how to do, is can I programatically use VBA to bold certain text?

& " Please advise if you or someone else is the correct contact to receive the document request list. " _
& vbCrLf & vbCrLf & "Please 'reply to all' on this e-mail, and provide the following contact information:" _
& vbCrLf & vbCrLf & "Name: " & Me.ContactPerson _
& vbCrLf & "Email Address: " & Me.EmailAddress _
& vbCrLf & "Mailing Address: " & Me.Address & " " & Me.City & ", " & Me.State & " " & Me.Zip _
& vbCrLf & "Phone: " & Me.PhoneNo & " " & Me.ExtensionNo _

Thanks,

John F

__._,_.___
Recent Activity:
.

__,_._,___

Tidak ada komentar:

Posting Komentar