How do i print addresses from a microsoft excel list onto an avery lable sheet? -

THAT S PRETTY MUCH IT. STANDARD AVERY SHEET 8-1/2 X 11 WITH 33 LABLES. ANOTHER THING, THE EXCEL LIST ALSO HAS PHONE amp; FAX # S BUT I JUST WANT THE ADDRESSES TO PRINT. THANKS IN ADVANCE FOR YOUR HELP.

First, make sure you have a header row for the titles of your columns in the Excel sheet. Then, go into Word, and use Tools-gt;Letters amp; Mailings-gt;Mail Merge. This will bring up a wizard in the right pane. Then just follow the wizard step by step and it will make your labels. You need to choose Labels and hit next at the bottom of the pane. Then click label options to choose the type of label--the number you need should be on the avery sheet. Next. Hit Browse and find your excel sheet. A couple more windows may pop up, like one that asks you which sheet from the workbook to use (usually sheet 1, unless you set it up differently). Another will ask you to select recipients--this is your chance to filter the data if you don t want every address in the book to print (if you only want people from one state, go to the state field, click the little arrow, pick the state you want, and the rest will disappear from your labels, though it won t change your excel sheet). Next. In arrange your labels --you have to be careful--garbage in gives you garbage out. I usually just click more items so that all the column headings from the excel sheet will be there for me to choose from. Then you set it up exactly like you want it to show up on the label. If you have fields for First Name and Last Name, you must type the space in between: [First] [Last] and hit Enter for each line break, type in the comma and space after the city, and so on. You can hit the preview button to make sure it looks right with an actual address. Once you have that first label perfect, click the update all labels button. Next. (You have one more chance to filter the list or change the labels here.) Next. I recommend choosing the edit individual labels option at step 6 so that you can see your labels as a new document, but you also have the option to just send them to the printer and see how they come out. That s it, you re done. It sounds tricky, but it really isn t. Just take it one step at a time.

Without describing HOW to do this, what you want to use is the MAIL MERGE function of Word. Depending on your version, in Word you first go to TOOLS - MAIL MERGE, and then you will create a NEW DOCUMENT and set it up as your blank label sheet. Use your Excel file as your DATA SOURCE. Next tell Word which FIELDS in your spreadsheet do you want on your labels and where you want them. The exact details of this will vary with various versions of Word, and can be quite tedious, and well beyond the scope of Y! Answers. HTH!

Use Word. Use the labels wizard. Use the spreadsheet as a data source.