Format text in Outlook from Excel

  • Thread starter Thread starter Scampa7
  • Start date Start date
S

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.
 
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.
Click to expand...

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 & "}"
 
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.
 
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.
Click to expand...

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>
 
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........
 
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........
Click to expand...

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