I need to generate HTML email using Access 2007/Outlook 2007. I have
enough experience with VBA to gin up the code, but Outlook 2007 is
something of a mystery to me.

Here's what I've tried:

1. created an .oft template
2. attempted to insert text into the template like this

Code:
--------------------
Set olApp = GetObject(, "Outlook.Application")
Set olmi = olApp.CreateItemFromTemplate(strOftPath)
olmi.HTMLBody = "HTMLBODYtext here/BODY/HTML"
--------------------


Unfortunately, this overwrites all the nice logos and such I had put in
the template.

Should I be using a Outlook Template or Form?

I like the idea of using templates because they are discrete files that
(hopefully) users can administer if they want to change logos/colors,
etc.

Since I can store formatted Rich Text in an Access Memo field, I was
thinking I could just dump that into the .oft - or use bookmarks in the
.oft to insert predefined blocks of text, like a NameAddress block.

Can I do that with an .oft? Or should I use an Outlook form?

What are some good resources for programming .oft templates?


--
deko
http://forums.slipstick.com