Format text in Outlook from Excel

[Scampa7]

I have set up an email to send from Excel. I would like the values from
the Excel sheet that appear in the body of the email to be in bold and
possibly in a larger font. Any help would be much appreciated.

 

[Michael Bednarek]

I have set up an email to send from Excel. I would like the values from
the Excel sheet that appear in the body of the email to be in bold and
possibly in a larger font. Any help would be much appreciated.

In which format does the Outlook message get composed? In Plaint Text,
you're obviously out of luck.

If HTML, you need to put HTML code into the body, like:
..Body = .Body & "<B>" & curAmountDue & "</B>"

I've never used RTF, but I suspect you would have to do the same thing:
..Body = .Body & "{\b" & curAmountDue & "}"

 

[Scampa7]

Thanks Michael - I was in plain text!, but now have changed to HTML and
"<b>" works.

I am not familiar with HTML script, and I wondered how to insert a tab,
ie equivalent of vbTab in plain text in HTML.

 

[Michael Bednarek]

Thanks Michael - I was in plain text!, but now have changed to HTML and
"<b>" works.

I am not familiar with HTML script, and I wondered how to insert a tab,
ie equivalent of vbTab in plain text in HTML.

I don't think HTML knows about TAB characters; in fact, one principle of
HTML rendering is that consecutive whitespace is treated as a single
space. There is the tag of <SPACER TYPE= SIZE=>, but that does not align
text the way TABS do.

The usual method is to construct a table:
<TABLE>
<TR><TD>Data cell 1<TD>Data cell 2
<TR><TD>Data cell 3<TD>Data cell 4
</TABLE>

 

[Scampa7]

Thanks again Michael - I thought I had this one sorted as I had tried
out inserting the HTML codes in the sub routines at home, where I have
Office 2000 and all worked fine. But at work we are still on Office 97
and I have found that you can't send HTML code from Excel 97. I would
have tried RTF but have not discovered how to send the email that way.
I guess it may be impossible to send an email from Excel with formatted
text, but incase there is a solution........

 

[Michael Bednarek]

Thanks again Michael - I thought I had this one sorted as I had tried
out inserting the HTML codes in the sub routines at home, where I have
Office 2000 and all worked fine. But at work we are still on Office 97
and I have found that you can't send HTML code from Excel 97. I would
have tried RTF but have not discovered how to send the email that way.
I guess it may be impossible to send an email from Excel with formatted
text, but incase there is a solution........

Sorry, but I know nothing about Excel 97/Outlook 97.