How to bold a word in an email body

vincent76 · Oct 30, 2002

Hi;

I have an vb program that sends an email using the content of an excell cell. Basically it opens up an excell file and gets the value of a specific cell and puts it in an email body and sends it. What I want to do is scan that cell for certain keywords and make them bold and then send it. So the email receiver when he opens the email he'll see those words in bold.

Any help will be greatly apreciated!

jeepxo · Oct 30, 2002

what are you using to generate the email?

if you are simply putting a text string in and firing it off then you can't make it bold.

you probably have the option of htmltext in your mailbody.

for example with CDONTS you can say
mail.body =
or
mail.htmlbody =

Then you can markup the body of the email to your hearts content

vincent76 · Oct 30, 2002

Thanks for your reply, I'm using the outlook object library 10.0 Here's my code:

Sub Button2_Click()

Dim objOutlook As Outlook.Application
Dim objMail As Outlook.MailItem

Set objOutlook = CreateObject("Outlook.Application&quot

Set objMail = objOutlook.CreateItem(olMailItem)
objMail.Recipients.Add "zzzz@zzzzz.com"
objMail.Subject = Workbooks(1).Sheets("Renewal Notice&quot

.Cells(1, 2).Value
objMail.BodyFormat = olFormatHTML
objMail.Body = Workbooks(1).Sheets("Renewal Notice&quot

.Cells(2, 2).Value
objMail.Send

End Sub

I tried using all the body format and nothing work.. keep in mind That I will parse the Workbooks(1).Sheets("Renewal Notice&quot

.Cells(2, 2).Value first and bold some words.

Any help ill be grealy apreciated.

Thanks

Schroeder · Oct 30, 2002

You'll need to send HTML as the body of the email. I suppose it could be as simple as

<HTML>
<BODY>
The word <B>Bold</B> will be bold face.
</BODY>
</HTML>

Although, it seems most email clients recognize html when they see it, you should indicate something like

text/html; charset="DEFAULT_CHARSET"

in the ContentType header.
Does the Outlook object let you customize all of your headers?

vincent76 · Oct 30, 2002

Thanks for your reply Schroeder; I don't know if you could modify the headers in the outlook object. I tried putting in the cell for the email body <b>word</b> it didn't do it.. It put literally the bold tags instead of bolding the word when I received the email.

jeepxo · Oct 30, 2002

don't think you will need to do that

try this

objMail.HTMLBody = Workbooks(1).Sheets("Renewal Notice&quot

.Cells(2, 2).Value

Schroeder · Oct 30, 2002

jeepxo's solution looks to be more appropriate for where you're coming from. I don't know anything about the Outlook object.
For mine, if you're going to explicitly put HTML tags in the body of your message, you're going to need to go all out and make a complete HTML document out of it - including the <HTML> declaration at the top as well as altering the ContentType header to tell the recipient's email client how to handle the message.

I suspect this "objMail.HTMLBody" property takes care of writing the HTML and altering the headers for you.

vincent76 · Oct 30, 2002

Thank you all for your replies, I will try it out tonight and I'll let you know id it works.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How to bold a word in an email body

vincent76

Programmer

jeepxo

Programmer

vincent76

Programmer

Schroeder

MIS

vincent76

Programmer

jeepxo

Programmer

Schroeder

MIS

vincent76

Programmer

Similar threads

Part and Inventory Search

Sponsor