#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Your mailmerge field coding appears to be based on the MS articles rather than the tutorial you downloaded. The coding in the MS articles won't do what you want; you need the tutorial's field coding for that. For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-...html#post23345 https://www.msofficeforums.com/mail-...html#post30327 Another option, if your workbook has a separate sheet with just a single instance of each of the grouping criteria, would be to use a DATABASE field in a normal ‘letter’ mailmerge main document could be used without the need for a macro. For an example of that, see: https://answers.microsoft.com/en-us/...f-8642e46fa103 The DATABASE field can even be used without recourse to a mailmerge, though that may not suit your requirements. An example of such usage can be found at: https://www.msofficeforums.com/mail-...html#post67097 Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from: Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or Doug Robbins at http://bit.ly/1hduSCB
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA Code to search for field codes with certain text before the Field code and to change style | welcometocandyland | Word VBA | 4 | 02-08-2017 06:53 PM |
IF in field codes? | tinfanide | Word | 1 | 09-15-2016 06:19 AM |
New to Field Codes | Panzer336 | Word | 2 | 04-11-2016 07:57 AM |
trouble with excel to word links. | acceptor | Word | 3 | 01-02-2015 12:14 PM |
Formula Field using Field Codes | hunter2193 | Word | 3 | 04-05-2013 04:58 AM |