How to set font from MS Access VBA to outlook email
Posted on 2012-09-05
I have some simple code that sends an email from MS Access VBA. It populates the Email Address, Subject and body.
Part of The body is RTF that is stored in memo field and looks great on the email
Problem is I need to poplulate part of the RTF with a Table from a recordset in the access database and have it ligned up properly on the RTF.
I originally thought creating a table in RTF would solve this issue, but NO too difficult, now I figured out if I just could use a MONOSPACED font that would be great.
Any suggestion on how I can change the FONT of the outgoing email from withint the VBA that creates the email?
Or other Suggestions on how to solve this issue?