MS Access database support

Author

Email fonts

Mitchell

2006-03-25, 3:30 am

I have some code in a Access 2002 database that sends an email, using
the SendObject command. Is there anyway to bold or underline a
specific word in the body of the email. Below is a small snippet of my
code:

strMessageBody = "PLEASE DATE AND SIGN ALL DOCUMENTS" & _
vbCrLf &

DFS

2006-03-25, 3:30 am

Mitchell wrote:
> I have some code in a Access 2002 database that sends an email, using
> the SendObject command. Is there anyway to bold or underline a
> specific word in the body of the email. Below is a small snippet of my
> code:
>
> strMessageBody = "PLEASE DATE AND SIGN ALL DOCUMENTS" & _
> vbCrLf &

Use HTML tags, and set your mail client to send HTML:

DoCmd.SendObject acSendTable, "tablename", , , , , "Test send table",
"<body><b>test is it bold</b></body>"

Ron2005

2006-03-30, 1:31 pm

although I have not gotten any of these to work for me from my email
program, there is a bodyformat argument when sending email

bodyformat = 2

same as cc or bcc

When I look at the email after it says the format is rtf or html etc
based on that bodyformat option.

For me, it has not helped in the formating but it may for you.

Ron

Ron2005

2006-04-06, 8:29 pm

I found the problem. Not only do you want the bodyformat = 2

You also want to load the data into HTMLbody and then within that use
html tags to control the bolding and fonts, and basically anything else
you want that can be controlled by HTML.

Try the following link and look near the bottom for an example

http://groups.google.com/group/comp...55d6cd9b7?hl=en

Sponsored Links