Trying to mail merge a numbers sheet into pages where I have an address line #1 and address line #2 for exteneded address information. If address line #2 is empty I don't want a blank line in my addresses box between address line #1 and the City, State Zip.
I'm guessing it's something I can fix with formatting in my address block but I'm not sure how to fix it.
Hi Ed_T,
For help with merging cells, check the restrictions with the steps below found in the article here: Merge or unmerge cells in Numbers on Mac
"Merge or unmerge cells in Numbers on Mac
Merging table cells combines adjacent cells into a single cell. Unmerging cells that were previously merged retains all the data in the new top-left cell.
Here are some restrictions:
Note: You can’t use forms for tables with merged cells. Forms in a Numbers for iPhone or iPad spreadsheet are hidden when you open the spreadsheet in Numbers for Mac. In Numbers for Mac, merging cells in a table linked to a form may clear the form."
If you continue to have an issue, reach out to the Numbers support team directly.
Contact Apple for Support and Service
Best.
How to mail merge addresses and skip blank fields
