ACCESS FEED: RE: [MS_AccessPros] Using VBA to change a title to bold

Selasa, 15 Mei 2012

RE: [MS_AccessPros] Using VBA to change a title to bold

John F-

This can be done only if the email body is in HTML format. Then you would wrap
<b> </b> around the text you want to be bold.

John Viescas, author

Microsoft Office Access 2010 Inside Out

Microsoft Office Access 2007 Inside Out

Building Microsoft Access Applications

Microsoft Office Access 2003 Inside Out

SQL Queries for Mere Mortals

<http://www.viescas.com/> http://www.viescas.com/

(Paris, France)

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of jfakes.rm
Sent: Tuesday, May 15, 2012 8:19 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [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

[Non-text portions of this message have been removed]