|
|
#6
12-20-2020, 06:52 PM
|
|||
|
|||
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! 
|
| Tags |
| macro help, many to one mail merge, merge tables |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Macro for merging cells in a word table
|
dana_c_83 | Word VBA | 3 | 04-29-2020 03:04 PM |
|
Merge table cells across columns but skip if column don't exist
|
jhearing | Word Tables | 4 | 05-31-2016 06:20 AM |
|
Macro to split table cells
|
nachiketapte | Word VBA | 10 | 03-08-2016 04:07 AM |
| Macro to loop through all cells in a table produced by a mail merge | elh52 | Word VBA | 4 | 08-31-2014 10:50 PM |
|
Macro to Merge Cells Row By Row in a Table
|
KD999 | Word VBA | 4 | 02-20-2012 08:51 PM |
Windows 10 
Office 2013
Threaded Mode