I have Microsoft Office and a list of addresses in an Excel spreadsheet. Is there a way to get these addresses into Word so I can create stick-on mailing labels out of them?
You can import the address data on the Microsoft Excel spreadsheet into Microsoft Word and make labels out of them with Word's Mail Merge feature. The process does take several steps, but saves quite a bit of time in the long run.
Those precise steps vary based on which version of Microsoft Office you are using, but generally goes like this: You set up a label template in Word, format the type in the text field, import the data from the Excel spreadsheet with the mail merge command and then print the labels. (A quick video overview gives you an idea of what to expect.)
Microsoft's site has its own detailed instructions for the entire label-making process from an Excel spreadsheet, as well as the steps for making labels from Outlo ok contacts. Once you get the addresses set up, you just need the blank labels to run through the printer. Word's Labels tool can create templates for a variety of popular adhesive label sheets from Avery and other office-supply companies, including the common Avery 5160 style that fits 30 labels per sheet.
If you are unfamiliar with some of Word's more advanced features, using the mail merge feature may take a bit of practice. Microsoft has an interactive online course and a 15-minute video “Webinar†that further explain how to use it.
