Forum Discussion
Mail merge nested if statements
Mailmerge challenge This application generates a single 3 x 4 label for each wishlist gift from these disadvantaged kids. The stickers will be taken by individuals who'll get the gift to be presente...
Use the following field construction, using CTRL+F9 to insert each pair of field delimiters { } and pressing the Enter key, or SHIFT+Enter where the ¶ appear.
«Name»
«gender» «age» «family#»
«wish_list_1»{IF «wish_list_2» <> "" "¶
«wish_list_2»" }{IF «wish_list_3» <> "" "¶
«wish_list_3»" }{IF «wish_list_4» <> "" "¶
«wish_list_4»" }{IF «wish_list_5» <> "" "¶
«wish_list_5»" }{IF «wish_list_6» <> "" "¶
«wish_list_6»" }
«source»
Deleted
When a wishlist is empty, then advance to the next kid