Mail Merge and Labels

users
#21

If you are using a table, have you tried my suggestion in a related thread?

o Put the cursor in the cell containing the text.
o Press Ctrl+A to select all the text in that cell.
o Press Ctrl+C to copy that text.
o Press Ctrl+A again to select the entire table.
o Press Ctrl+V to paste copies of the text into all the cells at once.

I trust this helps.

Brian Barker

#22

Hi Cliff,

When you use the table style templates, the wizard does not work. It is designed for the frame style. What I do is fill in one label. Then if you have a 30 label sheet with 3 columns and 10 rows, I copy and paste it to the nest two labels to the right. Then I copy all three of those labels on row 1, and paste into the complete second row. Then I copy rows 1 and two and paste into rows 3 & 4, 5 & 6, 7 & 8, and 9 & 10. It really goes pretty fast that way.

Don

#23

Copy one cell. Select all cells. Paste once into all. (That's Ctrl+A, Ctrl+C, Ctrl+A, Ctrl+V.) Isn't that even faster than "pretty fast" - and equally fast no matter how many labels you have?

Brian Barker

#24

Hi Brian,

That is a much better solution. Thanks for suggesting it.

Don

#25

** Reply to message from Brian Barker <b.m.barker@btinternet.com> on Wed, 18
Dec 2013 17:10:24 +0000

>Initially I just want a sheet with all the labels the same. [...]
>For now I can obviously copy/paste to each label, but the wizard's
>way of entering data for one then propagating it to all is handy for
>like a set of return address labels.

If you are using a table, have you tried my suggestion in a related thread?

o Put the cursor in the cell containing the text.
o Press Ctrl+A to select all the text in that cell.
o Press Ctrl+C to copy that text.
o Press Ctrl+A again to select the entire table.
o Press Ctrl+V to paste copies of the text into all the cells at once.

I trust this helps.

Thanks Brian. Saw that after I sent my email. Should work fine.

Cliff