Quote:
Originally Posted by macropod
Your description suggests all you need is an ordinary letter merge, with a mergefield for each field in your data source, along the lines of:
Client Name: «Given_Name»«Family_Name»
Brother's name | Brother's Age
«Brother1» | «Age1»
«Brother2» | «Age2»
«Brother3» | «Age3»
where the words between the chevrons are your field names.
Note: You can't type or copy & paste the chevrons (i.e. '« »') - they're part of the actual mergefields, which you can insert from the mailmerge toolbar.
|
Hi Paul,
Thanks for the reply. I actually wanted the records to be inserted in a table. And each CLIENT will have its own page or letter. With the above example the problem im encountering is that if some clients has only one brother and the others has many. Then there will be rows that are are empty. Which I don't want to be shown. Rows will depend on how many brothers the client has.
I was following some of your examples from other threads and have managed to kind of put the data inside the table but it's creating a space between each row.
I also did a brute force if else statement for every client. But it's not really ideal. Will only be ok for few records.
Thanks Paul