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"