[VBA, Interop, 2007] Email Populated from Access cannot be Spellchecked
So I have an interesting conundrum.
I have an application built around an Access DB in VBA. One function of the app is to create emails in Outlook. I do this by using Outlook.Application and Outlook.MailItem, then using Outlook.MailItem.HTMLBody to set the body of the item to a copy of an existing file (saved as a .msg) and start using Replace to replace patterned strings with relevant data.
Spellcheck is not seeing anything that's put in to the Body by Access. It will catch errors in the subject line, but it will allow errors in the body to go out unchecked.
Anyone know what I might be overlooking to allow the Spellchecker to check the body?
Thanks!
|