Hello - I have a similar problem to what others have posted re: Mail Merge for Donation Acknowledgements.
I've already downloaded the Catalog Mail Merge and read the tutorials
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip ... unfortunately in all the examples they do not give the Field Coding, which is frustrating for a first timer.
I looked at the Microsoft forums
http://support.microsoft.com/?kbid=211303 and
http://support.microsoft.com/kb/294686/en-us articles ... I did get some help with the Field Coding there ... however I'm still doing something wrong.
I have a VERY simple data base: Donor Name, Date of Donation, Amount ...
I tried running a basic code and things seemed okay (altered a bit from the examples) unfortunately donor shows up multiple times with grouped amounts ... and the grouping doesn't seem to have rhyme or reason
Example:
Mr. and Mrs. B
1/6/2017 10.00
1/6/2017 15.00
1/11/2017 10.00
1/11/2017 15.00
Mr. and Mrs. L
1/11/2017 50.00
1/23/2017 50.00
Then it goes back ...
Mr. and Mrs. B
1/30/2017 10.00
1/30/2017 10.00
Mr. and Mrs. L
etc.
This is the Code I used ... (the spacing may be off in this "paste" since I can't copy it directly)
{ IF { MERGESEQ } = "1" "Dear { MERGEFIELD Name }we kindly acknowledge your 2017 contributions:" "" }<ENTER>
{ SET Place1 { MERGEFIELD Name }}<ENTER>
{ If { Place2 } <> { Place1 }"<ENTER>
Dear { MERGEFIELD Name } we kindly acknowledge your 2017 contributions:<ENTER>
<ENTER>
{ MERGEFIELD Date } ${ MERGEFIELD Amount }.00" "{ MERGEFIELD Date } ${ MERGEFIELD Amount }.00" }{ SET Place2 { MERGEFIELD Name }}<ENTER>
Thank you in advance for all of your help.