-
For the life of me, I cannot get this to work? 
I can delete the second column, but not any cells in the first column?
Merge Labels Using a Down-Then-Across Output
To achieve this:
1. In the Labels dialog, click New Document to create a new document based on the label definition you have chosen.
2. Delete all cells except the first. If there is a spacer column, note its width beforehand.
3. On the Page Layout tab, in the Page Setup group, click Columns and choose More Columns...
4. In the Columns dialog, select however many labels across your label stationery originally had
5. In the Spacing box, set the width to the original spacer column width or, if it had none, 0
6. Set the column width to your label width.
7. Change the mailmerge type to 'Directory'.
8. Run the mailmerge.
Just using Print Preview at the moment.
We can live with side by side, and in fact as the controller wants to fold the A4 in half and place in a polypocket, that is the better arrangement?, as I intend to have the names sorted and the controller wants an excel sheet for each starting letter, so that is fortunate.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules