Quote:

---

Originally posted by peacock1

Hi All,
I have 5000 addresses that I need to print on stickers to prepare mailing list, can any one guide me how to go about of printing of it.
The addresses are Excel file format.
Mayur

---

If you have the data stored in another file, such as a spreadsheet, you can perform a mail merge to have the data imported into your labels.

Before you begin you need to make a small configuration change within Word.
>>From the Tools menu, click Options.
>>Select the "General" tab and " check" the option "Confirm conversion at open".

then follow these steps.

1. Open Word.
1. From the Tools menu, point to Letters and Mailings, and click Mail Merge
Wizard. If you are working in Word 2003, click Mail Merge.
3. Under Select document type, click Labels. This option is used for creating
address labels.
4. Click Next: Starting document.
5. Under Select starting document, select Change document layout.
6. Click Label options. Select the paper type that you will be using such as
Avery Standard 5160 Address. Click OK.
7. Click Next: Select recipients.
8. Under Select recipients, click Use an existing list. This option assumes that
you are using address information stored in another file or database.
9. Click Browse to locate your spreadsheet containing address information.

10. Click Open.
11. Select the table containing the address information and click OK.
12. Place a check beside the recipients you want included in the mail merge. 13. Click OK.
14. Click Next: Arrange your labels.
15. Click More items.
16. From the Insert Merge Field dialog box, select the fields you want to
include in the mail merge. Click Insert. These should be the fields that
contain the recipients' names and addresses. Close the Insert Merge Field
dialog box.
17. Format the first label as you want it to appear when it is printed.
18. Click Update all labels.
19 Click Next: Preview your labels.
20. Click Next: Complete the merge.
21 If you are satisfied with the appearance of the labels, click Print.
Your labels will now be printed. Each label should contain a different
address based on the address information that was in your Excel file.


Disclaimer: "Please DO NOT sue me if this does not work, how ever I could give you some more FREEEEEEEEEE opinions / ideas/ tips in future if I am rewarded"