Change Font in text message 2

[MDJ52]

I am working on creating an email from MSACCESS. By doing a series of message lines using text in quotes and fields from a query, and then tying them all under .Body of the email event I have been successful in creating an email message.
An example of part of my line of code is:

messageh = "Here is a lead from: SMITH,INC." & vbCrLf

Is there a way that I can make 'SMITH,INC' bold so that in the body of the email it stands out.

Thanks for your help
Mike

 

[Remou]

You can use HTML and
.HTMLBody
Instead of just
.Body

messageh = "Here is a lead from: <B>SMITH,INC.</B>" & vbCrLf

 

[MDJ52]

Remou
That worked great to make that part of the field bold.
However, it lost all of its line feed which I was doing with the vbCRLF.
What do those need to be changed to?

Mike

 

[RoyVidar]

I've never done anything like that, but is the <br> tag usable?

Roy-Vidar

 

[PHV]

Change each vbCrLf with "<BR>"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[MDJ52]

Thanks to Remou and PHV.
I have sent stars to both of you.
I can now have a relaxing weekend. Although, with the possibilities of HTML formatting I may also play with colors in this email to our salesman.

Thanks,
Mike