Mailing labels Where is the option to make mailing labels

Check your mailing list. Especially check how many invisible spaces are after a name or address. Suspect extra characters are pushing the mailing list into the next page or label and then it will print an extra blank page or label. Seen this happen when I was a Computer System Administrator and had to fix a similar fault for a client.
There is a reveal code option on most word processors that shows up hidden spaces.

You need label printing software which can be download for free, try google !

Hi Jan,

You can use the option Mail Merge In Microsoft Word to print Return address.

If you are Using Windows 2003, Follow the link below

http://www.wikihow.com/Mail-Merge-in-Microsoft-Word


If you are using Windows 2012, You will find Mail Merge option under Mailing tab on top - Create Mail Merge option

Regards,
Sean

Hi,

1. Pull up a blank Microsoft Word Document.
2. Select "Tools" under the toolbar feature. Slide the cursor down to Letters and Mailing. Slide it to the Right and down. Select "Envelopes/Labels."
3. A box will open up. Make sure that the "labels" tab at the top is selected. The default is "envelope", so you must click on the "labels" tab.
4. Below that, you will see a "print" box. If you want a full page of labels (excellent for Christmas lists, etc.), make sure the "Full Page of Same Label" radio button is selected. If you only want to do one label, make sure the "Single Label" radio button is selected.
5. Off to the right side, you will see the word "Option." Press on that. Locate your label. Whatever labels you are using should have their classification number listed on the bottom left corner of the outside of the box. They tend to be 4 digits (ie. 5162 is the number for Avery White Mailing Labels.)
6. Once you have located your number on the box, find the corresponding number under the "Options Tab." Highlight it. Press Okay.
7. You will see "New Document" in the upper right hand corner. Press that.

Presto! You can now fill in an entire box of labels and send out very classy looking envelopes!

hi Samajane,

I understand the you excel file has data that is stored column wise. Well you can first convert the column wise data to row wise data and then import it to you word.

To convert the column wise data to row wise data.
1.Select the data in your worksheet.
2.Right Click -> Copy
3.Create a blank worksheet.
4.Goto Edit - > Paste Special
5.Check the Transponse Option
6.Press OK.

Now you have converted your column wise data to row wise data and now u can import it to your word and print mailing labels

play with the size of the label on the report & form option

You'll need the actual Avery code for this, or at least the correct measurements.
Open up Microsoft Word. Go to 'Tools' and find 'Letters and Mailings' in the list. Then off of that is 'Envelopes and Labels'. Click on that one and a box will pop up. If you click on 'Options'. From here you can find the correct label settings by the code which will be on the Avery pack. If you haven't got the code, you can scroll through the lists and highlight options to see the measurements but this will take you a while.
Once you chosen your labels, click on ok. Now you can enter your address in the box and print a whole page of the same address or click on 'New Document' and that will give you a page set out correctly for that label sheet.

Create a mail merge label with the Address Book
On the File menu, click New.
In the Works Task Launcher, click Templates.
In the Letters and Labels category, click Mailing labels.
Click Use this style.
In the Labels dialog box, click Mailing labels.
Click OK.
The Label Settings dialog box appears.
Under Printer Information, click the option for the printer you are using.
Under Label Information, select the label product and style.

If you're seeing 30 of the same label, try adding <<Next Record>> to the beginning of each label (including the < > characters as shown). If you need more help please simply reply to this by posting comments, and I'll be notifited right much faster than happening across a request for help by chance; the system will send me an e-mail to make me aware of your comments.

Hope this will FixYa!!!

Thanks,

Aimiel

Are you using word for your labels? If so, you can insert a picture when you are doing the set up for the address box. Try doing a mail merge, so you can the setup for your address block.



If this was helpful, please rate me. Thanks, Patty