D
deko
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 = "<HTML><BODY>text 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?
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 = "<HTML><BODY>text 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?