In an Access database I build an email body for Outlook. It is just a
concatenation of text strings and variables. Does anyone know how I could
vary the font and or boldness of selected pieces of the text? Here is
skeleton code:

Set olObject = CreateObject("Outlook.Application")
Set myNameSpace = olObject.GetNamespace("MAPI")
Set myFolder = myNameSpace.GetDefaultFolder(olFolderInbox)
Set myItem = olObject.CreateItem(olMailItem)
<creates variable Msg>
myItem.Body = Msg
myItem.Display
AppActivate myItem.Subject

Thanks.

You need to write the text to the HTMLBody property. And you need to use the
HTML syntax, of course.

<p>this a paragraph</p>
<p>this a <b>bold</b> paragraph</p>
<p style='font-size:48pt;'>huge by using css</p>

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Thu, 23 Oct 2008 13:19:00 -0700 schrieb mscertified:

> In an Access database I build an email body for Outlook. It is just a
> concatenation of text strings and variables. Does anyone know how I could
> vary the font and or boldness of selected pieces of the text? Here is
> skeleton code:
>
> Set olObject = CreateObject("Outlook.Application")
> Set myNameSpace = olObject.GetNamespace("MAPI")
> Set myFolder = myNameSpace.GetDefaultFolder(olFolderInbox)
> Set myItem = olObject.CreateItem(olMailItem)
> <creates variable Msg>
> myItem.Body = Msg
> myItem.Display
> AppActivate myItem.Subject
>
> Thanks.