View Single Post
 
Old 04-03-2017, 06:29 PM
Kokiri Kokiri is offline Windows 8 Office 2016
Novice
 
Join Date: Apr 2017
Posts: 4
Kokiri is on a distinguished road
Default

Ha! You're probably right.

I am trying to pull a 1:Many relationship into the letter. In the database, I'm restricted on what I can do with children records. I'm experimenting with other ways that I can get this out of the system (our system has a pretty nice mail merge feature otherwise.) Right now though, I made this field and a similar field that stores information from these child records. The records might have commas and other symbols. That's why I chose ^. I found the convert text to table function and set it up through a macro. After reading a lot of your material, I have a couple other routes that I may explore.

If I ran the macro in the output document, how do I tell the macro what to convert? It appears that all the bookmarks and other references are stripped in the output. These tables can have a variable number of rows, and there are also a variable number of records in the mail merge.
Reply With Quote