Mailmerge with rich text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Walter Verkuil - 25 Aug 2004 16:34 GMT

I have some richt text in a database field. When i want to merge the
document in Word the field display's the text like:

<p><font style="Times new Roman">this is some text</font><p>
instead of:

this is some text

Does somebody know how you can avoid this problem.
Thanks,

Walter

Reply to this Message

Cindy M -WordMVP- - 26 Aug 2004 16:01 GMT

Hi Walter,

> I have some richt text in a database field. When i want to merge the
> document in Word the field display's the text like:
[quoted text clipped - 5 lines]
>
> Does somebody know how you can avoid this problem.

Word has no facility to pick up HTML or Rich-Text out of a database
field. The only way Word can pick up any formatting information is if
the text is contained in a Word TABLE that's used as the data source.
And even then, you have to "trick" Word by editing the field codes and
removing the word "Mergefield" from the field code where you want to
pick up the formatting.

So, in this case, I'd say you'd need to export the data to an RTF
file, open it in Word and save it as a Word document. If you don't
know how to create a table using RTF, then write it to a plain text
file in delimited format, open that in Word as plain text. Convert it
to a table, save the result as RTF, then open it again in Word and
save it as a Word document. Now you should be able to use it as the
data source.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)

Reply to this Message