Go Back   Talk Microsoft > Microsoft Operating Systems & Software > Microsoft Office Family

Reply
     How do i print addresses from a microsoft excel list onto an avery lable sheet?  
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-22-2008, 06:45 AM
Junior Member
 
Join Date: Jul 2008
Posts: 1
Default 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 & Fax #'s But I Just Want The Addresses To Print.

Thanks In Advance For Your Help.
Reply With Quote
Links
  #2 (permalink)  
Old 07-22-2008, 06:49 AM
Junior Member
 
Join Date: Jul 2008
Posts: 1
Default

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->Letters & Mailings->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.
Reply With Quote
  #3 (permalink)  
Old 07-22-2008, 07:19 AM
Junior Member
 
Join Date: Sep 2007
Posts: 6
Default

Use Word.

Use the labels wizard.

Use the spreadsheet as a data source.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 05:36 PM.