[AccessD] A2003: Sending HTML Emails via Outlook with Signature

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




More information about the AccessD mailing list