[Michael]

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
recognizing the HTML tags and would display the HTML texts correctly. But
once I tried to merge this HTML text to the Word document, Word would show
the HTML tags as is. i.e. BRtest/BR instead of a line break before
'test', a &amp instead of &, and a Bbold/B instead of a bolded 'bold'
text.

I wonder if there's a way to make Word interpret the HTML tags automatically
during the mail merge?

Thanks in advance,
Michael

[Peter Jamieson]

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


"Michael" wrote in message
...
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
recognizing the HTML tags and would display the HTML texts correctly. But
once I tried to merge this HTML text to the Word document, Word would show
the HTML tags as is. i.e. BRtest/BR instead of a line break before
'test', a &amp instead of &, and a Bbold/B instead of a bolded 'bold'
text.

I wonder if there's a way to make Word interpret the HTML tags
automatically
during the mail merge?

Thanks in advance,
Michael

[Michael]

Thanks Peter.

"Peter Jamieson" wrote:

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


"Michael" wrote in message
...
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
recognizing the HTML tags and would display the HTML texts correctly. But
once I tried to merge this HTML text to the Word document, Word would show
the HTML tags as is. i.e. BRtest/BR instead of a line break before
'test', a &amp instead of &, and a Bbold/B instead of a bolded 'bold'
text.

I wonder if there's a way to make Word interpret the HTML tags
automatically
during the mail merge?

Thanks in advance,
Michael