build a string from HTML to modify template

B

Bob

I need to be able to automatically send a HTML template in response to
a rule in Outlook 2003.

It seems that for me to do this I need to be able to make a string from
an existing HTML template,
insert a string with the customer's name in the proper section of the
HTML string, then insert the entire string back into the template as
objItem.HTMLBody = strHTML.

Problem is I don't know how to build a string from HTML.

Can anyone offer any suggestions or point me in a direction where I can
find some examples on converting HTML code into a string. I need to
preserve all formatting and hyperlinks.

Thank you in advance for your assistance!

Bob
 
S

Sue Mosher [MVP-Outlook]

You don't need to know any HTML for that task. Create an .oft file with placeholder text where you want the name to appear. I use tokens like %name%. Then load the template and use Replace():

Set itm = Application.CreateItemFromTemplate("C:\myfile.oft")
itm.HTMLBody = Replace(itm.HTMLBody, "%name%", _
"customer_name")
etc.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Top