Create mailing list from excel file,

[wtowers]

Hi all, I have a small problem which is probably very simple but, I can't quite get it to work.

I have a file with x number of names and addresses and I want to format these names and addresses in mailing label that can be printed out on a sheet of avery labels. The will need to be formatted neatly and have self adjust text sizes for the larger addresses.

EG: the Mailing labels will need to print 3 across and 12 down. The label size is constant throughout the sheet it is only the address size that may change size and I need them all to fit with the bounds of the individual label.

Address 1 is normal

Mr Joe Bloggs
14 Where Street
Timbuktu QLD 4650

Adress 2 is a bit longer as it contains company information as well.

Mr Joe Bloggs, Assistant Director
Corporate and Personnel Department
Rural College of Learning
1551b Private Mail Bag 1245
Mellbourne GPO VIC 3001 Australia

[boopathiraja]

May be right click format>Alignment>Select Shrinik to fit

[newdoverman]

I think that your best bet is to arrange your data in proper data format of 1 row per record with each column being a field. All columns to have a heading. Then, use Word's Mail Merge feature which will fill in the fields if they have data and you can also specify what labels you are using.