I'm working on automating donations and was wondering if, when using Data Merge, it is possible on export to auto remove a line, if those fields don't have any data in them.

Per example,

Screenshot 1

After Data Merge,

Screenshot 2

Goal is to remove the bottom two lines if there isn't a second donation turning it into this,

Screenshot 3

Thank you in advance for your help.

2 Answers 2

  1. Include the $ symbol in Excel or whatever program you use
  2. Make sure "Remove blank lines for empty fields" is selected in the DM options
  3. Create two paragraph styles for "amount" and "date". Set them as numbered list. In the bullets and numbering options, type the prefix (e.g. "Donation amount") instead of the numbering marker ^#

enter image description here

  • I understood everything except your third point. Could you be a little more specific? Thank you so much.
    – Sam
    Feb 13, 2020 at 13:53
  • @Sam I've edited my answer. Hopefully it will make more sense
    – Vinny
    Feb 13, 2020 at 14:27
  • 1
    That did it beautifully; merci!
    – Sam
    Feb 13, 2020 at 14:45

I think you will have to place a null character in the blank space in the excel document

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.