View Single Post
 
Old 12-20-2020, 06:52 PM
LDower LDower is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2020
Posts: 6
LDower is on a distinguished road
Default More Info

From the test excel - all the Signers (Column A) need to have their Message (G)/Signature(H) on a Partner (B) Letter - that's the many (messages/signatures) to one (partner) ratio. I've attached a completed example when I run the Many to One with the test info using the Mail Merge Doc provided. I then have to go in click Merge Cells to the whole Table to get the desired outcome (before/after attached). I'm looking to avoid manually having to merge all the cells in the table to get the Message and the Signature to correspond w/ each other in the proper format.

The header is different since we are printing on special letterhead - it's not relevant to the issue though.

Also the table is in there it's just borderless, if you put on the gridlines on you'll see the table. I've used a table since w/out the table it was not putting the message w/ the signature. Just doing -

message

message

message

signature

signature

signature


Thanks!
Attached Files
File Type: docx Complete Many Mail Merge Before Merge Cells.docx (22.5 KB, 8 views)
File Type: docx Desired Outcome.docx (22.4 KB, 9 views)
Reply With Quote