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.

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:
http://windowssecrets.com/forums/sho...merge-Tutorial
or:
http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip
The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

For some worked examples, see the attachments to the posts at:
https://www.msofficeforums.com/mail-...html#post23345
https://www.msofficeforums.com/mail-...html#post30327
http://windowssecrets.com/forums/sho...l=1#post928391

Alternatively, you may want to try one of the Many-to-One Mail Merge add-ins, from:
Graham Mayor at http://www.gmayor.com/ManyToOne.htm; or
Doug Robbins at http://bit.ly/1hduSCB

In addition to a 'Many to One' merge, the latter handles:
• Merge with Charts
• Duplex Merge
• Merge with FormFields
• Merge with Attachments
• Merge to Individual Documents
• Merge, Print and Staple

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Hi,

Thanks for getting back to me - having read through your tutorial however I'm no closer to understanding how to create a dynamic table using mail merge.

What I'm after is when the mail merge is being printed, only the lines in the table where there is data will be printed, with the others hidden?

Sorry if my original explanation wasn't clear enough...

Did you actually try the process outlined in the tutorial? It even comes with sample files for you to practice with.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]