View Single Post
 
Old 06-17-2013, 08:58 AM
DepricatedZero DepricatedZero is offline Windows 8 Office 2007
Novice
 
Join Date: Jun 2013
Posts: 6
DepricatedZero is on a distinguished road
Default [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!
Reply With Quote