Hi,
I’m wondering, what’s the best way dealing with the following serial letter / mail merge process:
– I have a online form where people enter their personal data like name, place, phone, mail address, etc.
– There is one field for telephone no. and one field for mobile telephone no. People can fill out both or just one of it.
– I have an function which exports all datasets as TXT file and I have a InDesign business card template where all datasets go into it as mail merge process. This works fine so far.
– Now what’s the best way to handle the problem of unfilled fields not to get an unfilled line in the business card? Lets say in the BC the first line is for telephone no., second line is for mobile telephone no. When someone hasn’t filled out telephone no., I want to have mobile no. in the line of telephone no. to prevent an gap/unfilled line. Is there a way in InDesign itself to fix this issue or do I have to go over Excel to manage this?
Thanks in advance, regards
Tom