Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / June 2007

Tip: Looking for answers? Try searching our database.

Merging text with HTML tags as data source into single word docume

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michael - 20 Jun 2007 12:26 GMT
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. <BR>test</BR> instead of a line break before
'test', a &amp instead of &, and a <B>bold</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 - 20 Jun 2007 20:17 GMT
> 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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.