I have a word document that I am trying to merge the data into from an Access database.
Several of the fields in the Access Database are in a rich text format to allow users to create a bulleted list in the form that, ideally, would have output that data into the word document in the same formatting that the access database saved it in.
Example: I have several lists of bulleted items I want to put in cells in a word document table like:
- frogs
- cats
- dogs
and
- pie
- apples
- cake
- cookies
I want the number formatting, the bolded items, and those underlined to insert themselves into my document as they appear above using a mail merge field. When I do this, however, I get just the words and associated coding in brackets (like "<ul> <li> <font face=Arial size=2> BCK 120004 frogs </font> </li>") instead of the words being formatted appropriately. How do I get (or can I get) mail merge to display the formatted text instead of using the formatting of my word document and displaying formatting codes as text?