Mailmerge with rich text

W

Walter Verkuil

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
 
C

Cindy M -WordMVP-

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:

<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.
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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top