Hello all,
I am having some difficulty with merging into a Word 2007 (also tested in Word 2010) document from a Tessitura report (Execute an Output Set), and I'm not sure if it's my merge fields, or Tessitura.
The aim is to merge data similar to below, but skip the rows when the last column is blank.
My first idea was to use this example as my merge fields, with the second to sixth rows duplicated down the page.
1 {SKIPIF { MERGEFIELD Contribution_Date_Range}=""} 2 Member: «Salutation_outside_line1» 3 Customer Number: «customer_no» 4 Membership Processed: «Contribution_Date_Range» 5 Notes: «Contribution_Notes»6 {NEXT}
However merge fails, and Tess displays the error: 'OLE Object Runtime Error Error calling external object function show at line 170 in the eu_merge event of object wa_report_standard'.
The NEXT field is important for this document as each row will not fill the entire page, and the Mail Merge mode of 'Directory' which groups multiple rows on each page does not appear to be possible when merging from Tessitural.
If the SKIPIF field is removed, then the merge works fine, so it appears to be the combination of NEXT and SKIPIF.
If anyone has expericed something similar, or has a better suggestion for this merge, I would love to hear from you!
Best, Nicholas