MailMerge Address Labels

[Muthukrishnan V]

MS Excel 2007 and MS Word 2007.

I have created an address data base in Excel containing headers like:A1 name;A2 Door No; A3 Street; A4 City; A5 Postal code; and A6 State. Then address data entered from A2 onwards. I am able to create mailing address labels through MS Word using Mailings ribbon, but I get the mailing label only one label per page. When I have about 50 addresses, the Mail merge output gives these 50 address labels, each label in one page and it gives the output in 50 pages. 1st address in 1st page, 2nd address in 2nd page and so on and the 50th address comes in the 50th page.


My requirement: My mail merge address labels should contain 8 labels per page (in an A4 sheet left side 4 and right side 4) and the entire 50 address labels should be printed in 7 pages, so that I can tear off these 50 addresses to paste in address column of the envelope).


Kindly guide me.

 

[ranman256]

in the paper template, set the paper type to 4x4 label.
mailmerge with this template (not the 25x25 paper)

 

[mole999]

word has access to the majority of standard layouts, need to identify the label type and then use the associated template