Mail Merge to create specific number of table rows

[flackend]

I have a sign-up sheet that pulls information about the event (name, location, time, number of seats, etc) with mail merge.



I'd like the sign-up sheet to layout a specific number of rows in a table for attendees' information based on the event location's number of seats available.


So I'm thinks something like this (in english):

if merge data 'location' equals 'Hall A' then create 28 rows

or

create {merge data, 'num_of_seats'} rows

If that makes sense...

Thanks for any help!

[macropod]

Hi flackend,

For this, you could create whatever conditional tables you might need and embed each if them in an IF field, coded along the lines of:
{IF{MERGEFIELD location}= "Hall A" "Table for Hall A"}
{IF{MERGEFIELD location}= "Hall B" "Table for Hall B"}
etc

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.

[flackend]

Originally Posted by macropod

Hi flackend,

For this, you could create whatever conditional tables you might need and embed each if them in an IF field, coded along the lines of:
{IF{MERGEFIELD location}= "Hall A" "Table for Hall A"}
{IF{MERGEFIELD location}= "Hall B" "Table for Hall B"}
etc

Note: The field brace pairs (ie '{ }') for the above examples are created via Ctrl-F9 - you can't simply type them or copy & paste them from this message.

It worked great, thanks! I didn't think realize you could insert a table in an IF statement like that!

[mmurali]

How to set fixed number of rows in a page in ms word mail merge. eg. 15 rows table in a page while merging

[Guessed]

Are you saying this merge is one record per row or are there multiple columns also containing records?

Would you not just set a table row height that allows 15 rows?