Excel Sheet (2 columns) import to word to make labels

[traxxton]

I have office xp and an excel sheet with 2 columns and about 3,000 lines. The first column is customer code and the second is customer name. I have avery 4013 dot matrix lables and need to print each customer code/name on a seprate label. Whats the easiest way to go about it? I copied it into word, but having a problem getting everything in label format.

 

[mugs]

Mail merge. Do you have a template file for the labels?

Or try this: http://www.avery.com/us/Main?a...&softwarecode=3200

 

[duragezic]

Yep, Tools -> Mail Merge can do it. Not sure if they have the Avery 4013 labels (I've only done it in Office 97), but if it comes down to it you can just measure all the dimensions you need.

 

[traxxton]

Had some trouble with the mail merge, but got it working. Thanks alot!