View Single Post
 
Old 12-20-2020, 01:10 PM
LDower LDower is offline Windows 10 Office 2013
Novice
 
Join Date: Dec 2020
Posts: 6
LDower is on a distinguished road
Default Merge All Cells in a Table via Macro

Hi - I'm making a Company Christmas Letter and each letter has a message from a unique group of signers. I used Graham Mayor's Multi-to-One Mail Merge to make the letters and it worked perfectly. But I have an issue with formatting I can't figure out. I had to insert a table to get the correct message/signature to line up w/ each other - (note: the message is in a different color/format than the signature) but they show up next to each other horizontally vs vertically aligned since it's a table. However, I would like it for each message to be on top of its signature. A quick fix I found was to just merge all cells in the table afterwards and it solves that formatting issue. But I have to do that manually across all 7,500+ letters then. Is there a macro I could run or setup the document differently to prevent this issue? (I figured creating a Macro makes the most sense - but sorry if I posted in the wrong thread- first timer!)
Reply With Quote