Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing address labels (97)

    I searched the board and came up with only a partial answer to my question here:
    http://www.wopr.com/cgi-bin/w3t/showthread...l&Words=address labels&Match=And&Searchpage=0&Limit=10&Old=allpost s&Main=45405

    I have a list of approx. 1,000 lines with 5 columns (name, street, house number, district, city)
    How can I print non-Avery labels (no manufacturers name on box but the labels are 3.5 by 7 cm on A4 pages) either directly from Excel or how do I export to Word 97?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Printing address labels (97)

    The best way is to do it using mail merge in Word. You can use an Excel worksheet as data source for a mail merge in Word, so there is no need to export the data to Word.

    Experiment a bit in Word with Tools/Envelopes and Labels to find a label type that corresponds with the ones you have (it is easier doing that now than halfway through the mail merge)

    In Word, create a new blank document.
    Slect Tools/Mail Merge...
    In step 1, select Address Labels as document type.
    Specify the active window as document to be used.
    In step 2, select Link to Data Source.
    Select MS Excel worksheets as file type.
    Browse to your Excel workbook and click Open.
    Word will prompt you to set up your label.
    Select the label type, then click OK.
    Now create your label. You can enter fixed text and insert merge fields.
    Finally, in step 3, you can merge to the printer or to a new document.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing address labels (97)

    Yes, Hans is right.
    My 2 penn'orth for what it's worth is to save the source data list as .csv - file size will be much smaller, any possible complications from formulas in any fields will be overcome, as the .csv will freeze the result as a value.
    Word will read the csv ok, so anyone else using the data source doesn't even need excel.

  4. #4
    Star Lounger
    Join Date
    Jan 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing address labels (97)

    Thanks Hans,

    Clear and concise step by step instructions brought the desired result.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •