telohax.blogg.se - How to do a mail merge from excel for labels

If the cells pasted with a border, press Alt+Ctrl+U to remove it.Scroll down to the bottom of the first column and click in the empty paragraph below the table cells (if you have nonprinting characters displayed, you will see the.In the Columns dialog, click the preset button for Two, then change the spacing between the columns to 0.2".On the Page Layout tab, in the Page Setup group, click Columns, then More Columns.

Select the right column and Cut (Ctrl+X).

Select the narrow center column (between the labels), right-click, and choose Delete Columns.

In the mail merge main document (after inserting your merge fields and updating the labels), display table gridlines (Table Tools | Layout | Table | View Gridlines) so that you can see the label boundaries.