Very Urgent: How to print on Labels

Posted on 2004-11-23
Last Modified: 2010-04-12

I have to print addresses on labels. There are about 200 addresses in an excel sheet. They need to be printed on a label so that they can be sticked on top on envelopes. The label sheet has 2 labels in each row.

Is there any option to do so. I have HP Laser Printer.

Question by:thomas908
    LVL 11

    Accepted Solution

    Use Microsoft Word to make a mail merge:
    LVL 8

    Author Comment

    For the all the label options it shows 3 colums in each row. i want only 2 columns.
    LVL 37

    Assisted Solution

    If these are Avery labels or some other well-known brand, Word should have a template for it.

    Go to Tools >Envelopes & Labels, click on Options and then select the brand and label number.

    If your labels are not there, you can even create your own labels by clicking on the Details button: you enter height, width, pitch, top and side marge\ins, as well as number of rows & columns.
    LVL 18

    Assisted Solution

    by:Andrew Davis
    i am presuming that the label sheets you have are A4/Legal 2 columns X rows. you simply need to format the spreadsheet to fit the page layout. this may require you to insert a column to allow for spacing.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Suggested Solutions

    How to solve seemingly unsolvable printer issues. Users sometimes run into printing issues where all the normal steps do not seem to work. Well the steps below can show users how to take one extra step beyond the normal steps needed to remove old…
    Causes of paper jams:The following are the main causes of paper jams. Guides:If the guides for the paper are not set correctly they may cause the paper to enter at an angle. You should ensure that the guides are set correctly for the paper type a…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now