I am pulling out my hair for something that I am sure is an easy fix. I created a template that merges a legal document. Within the contents of the document, an address is needed that pulls from my database using a merge field named «Address». It merges on multiple lines but I need it all to merge on one line.

Example - It merges like this
123 Somewhere Dr


Chicago, Il 60601

I need it to merge like this:
123 Somewhere Dr, Chicago, Il 60601

Any advice, anyone? Thanks in advance.

You can't edit the contents of a merge field in this manner. You would need to derive the address in the required format in the data source.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com