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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

On Sat, 25 Oct 2003 06:09:46 -0400, Scampa7
wrote in
microsoft.public.excel.programming:

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 & "}"

--
Michael Bednarek
http://mcmbednarek.tripod.com/ "POST NO BILLS"

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.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

On Sat, 25 Oct 2003 09:47:07 -0400, Scampa7
wrote in
microsoft.public.excel.programming:

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<TDData cell 1<TDData cell 2
<TR<TDData cell 3<TDData cell 4
</TABLE

--
Michael Bednarek
http://mcmbednarek.tripod.com/ "POST NO BILLS"

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........



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

On Wed, 29 Oct 2003 05:01:22 -0500, Scampa7
wrote in
microsoft.public.excel.programming:

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.

--
Michael Bednarek, Brisbane, Australia
http://mcmbednarek.tripod.com/ "POST NO BILLS"