Excel/Word merge

[Sara]

I have a spreadsheet with columns A and B data filled. I
want to merge this spreadsheet onto a label format in
Word. I would like Column A from the Excel spreadsheet to
be on the left hand side of the labels and Column B from
the Excel spreadsheet to be on the right hand side of the
labels. I am using the Avery Label 5395 with 8 labels per
page. I'm not sure if this is possible but it would be a
huge time saver as I have almost 600 labels.

 

[Arvi Laanemets]

Hi

You better merge your both columns into one - from left column on even rows
(2nd, 4th, etc) and from right column on uneven rows (3th, 5th, etc). The
easiest way to do this:
1. Add a column before both of them so now are filled columns B and D
2. Into A2, enter the formula
=ROW(A1)*2-1
and copy down.
3. Into C2, enter the formula
=ROW(A1)*2
and copy down.
4. Replace formulas in columns A and C with values (copy, and then
PasteSpecial.Values)
5. Copy values in columns C (without header row) into columns A:B below
existing values.
6. Sort data by column A.

Now you can create your mail merge.