I have a mail merge that has data in Excel. The word merge needs to be a table. The table has a first row with the field from column A. Then the next row in the word table is split in 2 columns. This is where the next 5 fields from excel go. They go in the first column of the word table, like an address block. The next record should be in the right column of the table, etc, if the first column at the top of the word table is the same as the previous row in excel. The merge should make a new page with a new table, only if the first column is different than the previous record. Looking around, I am not sure how to do this.

So let's say this is a data set of music. It would be the name of the CD, and then who to send it to. Each row of excel would be like this:
CD,Recipient1,Add1,City,State,Zip
CD1,johndoe,1mainst,chicago,ny11223
CD1,janesmith,2mainst,chicago,ny11223
CD2,mikeanderson,3broadst,chicago,ny11223


CD3,bethchilds,4hollywoodblvd,chicago,ny11223
CD3,sarahmanning,5pennsilvaniaave,chicago,ny11223
CD3,tatianamaslany,6blahblahst,chicago,ny11223

So the word doc would have cd1 at the top row of a table. The 2nd row split in 2 columns, so that the first recipient block goes in the first column. The next record is the same cd, so it just goes in the next column in the word table. If the CD name changes, then we go to a new page and put the new CD in a new table as the first table row/column (centered).

Does this make sense? If anyone can help, I would appreciate it. I found a tutorial online about directories and catalogs, but it is really confusing.

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]

Cross-posted at: http://windowssecrets.com/forums/sho...el-Column-Same
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

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