> I wonder if there's a way to make Word interpret the HTML tags
> automatically
> during the mail merge?
No, sorry.
If I had to do this, I would probably
a. "roll my own merge" in VBA, using ADO to get the data from Oracle
b. either save the HTML snippets as .htm files which I would then include
either using VBA or via INCLUDETEXT, or
c. write my own interpreter that stuffed the field contents in and applied
the appropriate formats. And I'd only actually consider that if the allowed
HTML tags were a very, very simple subset of what HTML allows.
I can think of variations on that theme, but none which would substantially
reduce the complexity, except maybe if...you could write an Oracle PL/SQL
procedure (sorry, I'm way out of date with Oracle these days - perhaps it's
something else now) that emitted either a set of .htm files for each merge
record, or (conceivably) a single HTML file with bookmarks that identified
each field in each record. You might then be able to INCLUDETEXT the info,
complete with formatting, in your merge. Not my idea of fun.
Peter Jamieson
> Dear all, I have a .doc document and a data source from an oracle database
> which stores HTML data as text. The front end application has no problem
[quoted text clipped - 10 lines]
> Thanks in advance,
> Michael
Michael - 21 Jun 2007 10:15 GMT
Thanks Peter.
> > I wonder if there's a way to make Word interpret the HTML tags
> > automatically
[quoted text clipped - 34 lines]
> > Thanks in advance,
> > Michael