I have 6 columns of data (company name, address 1, address 2, Address 3, Zip, Name) in excel that I need to convert into mailing labels for MS Word (30 Avery labels per page).
How do I do this?? Thank you so much!!!
You’re talking about a Mail Merge operation in Word, in fact, you’ve got Excel set up almost perfectly for it.
But there’s way too many details to a Mail Merge to give here. The best I can do is give you some pointers:
1.Word’s Mail Merge can be found in the Tools->Letters and Mailings menu item.
2.Before wasting pages of labels, run tests on regular paper and hold the sheets up against the labels to check the layout.
3.Don’t leave the setting up to the last minute. Mail Merge can be frustrating and take more time to set up than one would think.
4.For test runs, use only enough names to be sure you’re not losing any — a little over a page should do. Accidentally skipping every other name is real easy to do.
Keep a sense of humor while you’re wrestling with it. It will be worth it the second time around.
December 18th, 2009 at 6:33 pm
Well….not quite sure….you might could import the file into Word. The other option would be to try to PDF the spread sheet…then go back and take the PDF file and change it to a Word doc. Not sure what that would do. I’ve always made labels from a Word mail merge database that I created.
Not sure if that helps at all….but I hope that it does.
References :
December 18th, 2009 at 7:21 pm
You’re talking about a Mail Merge operation in Word, in fact, you’ve got Excel set up almost perfectly for it.
But there’s way too many details to a Mail Merge to give here. The best I can do is give you some pointers:
1.Word’s Mail Merge can be found in the Tools->Letters and Mailings menu item.
2.Before wasting pages of labels, run tests on regular paper and hold the sheets up against the labels to check the layout.
3.Don’t leave the setting up to the last minute. Mail Merge can be frustrating and take more time to set up than one would think.
4.For test runs, use only enough names to be sure you’re not losing any — a little over a page should do. Accidentally skipping every other name is real easy to do.
Keep a sense of humor while you’re wrestling with it. It will be worth it the second time around.
References :