Email & Font

[Guest]

Hi All,

I have a database and i want my users to be able to send an email from a
given page, i have no access to their machines and therefore cannot do
anything in their Outlook, so it all has to be done from Access. I can write
this code:
strMessage.Value = "blah blah blah"
DoCmd.SendObject acSendNoObject, , , "(e-mail address removed)", , , "test",
strMessage, True
however, i want to be able to change the font, size, bold, add carriage
returns etc to the message body text.

Can any give me any guidance on how to do this. I have seen where people
create an email message but none of the answers are specific enough to show
me exactly what to do as i haven't done anything like that before.

Thanks for your help.

 

[Guest]

Emma,

I do not believe SendObject allow formatting of this type. If you really
need to perform formatting then you need to look into automating Outlook
through VBA. take a look at

http://msdn2.microsoft.com/en-us/li...odc_ac_olauto_sendanoutlookmessageusingaccess

Other e-mailing options can be found at

http://www.granite.ab.ca/access/email.htm