mail merge multiple rows within a grouping

gmayor · #1 11-11-2015, 04:48 AM

My Many to One mail merge add-in uses docvariables (as does that of Doug Robbins). If using my add-in, you cannot use switches on the child fields. These are purely place markers and switches screw up the results. This is explained, with workarounds, on the web page http://www.gmayor.com/ManyToOne.htm .

tracygleghorn · #2 11-11-2015, 06:00 AM

that is what the your addin process converts the mergefeild to when creating the word document. the actual code on the document is mergefield tot_amt\#"$0" the format and $$ amount shows up ok on the single row groupings but the the convert 'DOCVARIABLE tot_amt\#"$,0" shows up on the first row of the multiple row groupings.

gmayor · #3 11-12-2015, 06:43 AM

Quote:

Originally Posted by tracygleghorn

that is what the your addin process converts the mergefeild to when creating the word document. the actual code on the document is mergefield tot_amt\#"$0" the format and $$ amount shows up ok on the single row groupings but the the convert 'DOCVARIABLE tot_amt\#"$,0" shows up on the first row of the multiple row groupings.

As I said, it screws up the results. Don't use switches on the child fields.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula that can merge multiple rows with the same ID into one row	Hilwey	Excel	3	07-08-2015 08:50 PM
Mail Merge Multiple Rows Into One Document Grouped	ryano	Mail Merge	4	03-23-2015 04:27 PM
Grouping table rows to prevent individual rows from breaking across pages	dennist77	Word	1	10-29-2013 11:39 PM
Grouping list in Mail Merge	AlexTeslin	Mail Merge	1	03-08-2013 09:31 PM
Mail Merge multiple rows?	ender541	Mail Merge	1	08-21-2012 03:14 PM