How to Make Address Stickers with Excel

Writing the address on every envelope that you mail can become a chore, especially if you are sending a large amount of mail at one time. It is much less time-consuming to use Microsoft Office to make your labels.

Items you'll need:

• Computer with the Microsoft Office suite


• Blank address label sheets


• Printer

1. Open Microsoft Excel. Create a columns on the spreadsheet for each part of the address. Then, fill in the each row with the addresses, putting the proper information into each column. When you are finished, save the document and close it.


2. Open Microsoft Word. On the toolbar, click the button that says "tools." A drop down menu will appear. Click "Letters & Mailings." Understand that depending what version of Word that you are using, the steps may vary slightly.


3. Select the spreadsheet that you created in Excel when Word asks for your database. This is how Word will know what addresses to print .


4. Select the type of labels that you want to print. To find out the type of labels that you have, just look at the package. A common type of address label is Avery 2020. Be careful to select the right label; choosing the wrong label will result in improper printing.


5. Load the labels into the printer. Use the feeder tray if your printer has one. Make sure that you load them the proper way, or the labels will be printed on the back side.


6. Select the option in Word to send the labels directly to the printer. Your labels will then print. Give the labels a minute to dry before peeling and sticking on your envelopes.