Hi,

I'm pretty new to Mail Merge so not even sure if this is possible so any help would be appreciated.

I'm trying to create a letter template to send to our customers when they request sample(s) of our products (they can select up to 12 samples at a time). On this letter, I've created a 4x13 table with the following 4 column headings:

Product Code
Product Name
Product Collection
Quantity Ordered

I've then inserted the corresponding merge fields from my data source (excel spreadsheet). The issue I have is that if I have a customer that only selects 1 sample, then there will be 11 empty rows shown. What I'm after is the table to only show as many rows as there is data for.

Can this be done? I hope I've explained it correctly.

Thanks in advance for any help.