Darren - Active Billing
darren at activebilling.com.au
Tue Jun 15 10:26:06 CDT 2010
Hi team In my access app I am building HTML Strings to insert into Outlook as email bodies - I have all this working OK I am using standard outlook code found (mostly) on this list - nothing tricky - Stuff like Dim OlApp As Outlook.Application Dim objMail As Outlook.MailItem Dim olInspector As Outlook.Inspector Set OlApp = Outlook.Application Set objMail = OlApp.CreateItem(olMailItem) Set olInspector = objMail.GetInspector With objMail Blah blah blah... If Outlook itself is set to "Use Word as Email editor" my text and table appear nicely in the body of the email but I lose the standard and default outlook Signature If I turn "Use Word as Email Editor" off then it works a treat. I see my text, the table and my signature all nicely placed in the email body There are a gazillion tales of woe on the net about this issue but no-one has posted a way to toggle this value on or off via VBA Does anyone know a way in code to turn "Use Word as editor" off until the email is built and then turn it back on? I've managed to get this close If olInspector.EditorType = OlEditorType.olEditorWord Then MsgBox "IT IS WORD" ''Email body will be missing signature Else MsgBox "IT ISN'T WORD" ''email body is perfect End If But am unable to find a way to toggle the olInspector.EditorType Hope it all makes sense - Thanks in advance team Darren