View Single Post
 
Old 11-22-2017, 06:26 PM
spaynter spaynter is offline Windows 10 Office 2007
Novice
 
Join Date: Nov 2017
Posts: 1
spaynter is on a distinguished road
Question Read the links, still having trouble with Field Codes

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.
Reply With Quote