Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Labels from Excel Spreadsheet (2003)

    I have a spreadsheet of clients with their names, addresses, etc. I filter it to show me only the names and addresses that I want to sent holiday cards to. Can someone tell me how to easily use this to generate labels in Word? Thanks!

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

    Re: Labels from Excel Spreadsheet (2003)

    You can mail merge to address labels in Word (Tools | Letters and Mailings | Mail Merge). Word doesn't "know" about the filtering you set up in Excel, though. When you select the Excel workbook as data source for the mail merge in Word, you'll be given the opportunity to filter the data.

  3. #3
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Labels from Excel Spreadsheet (2003)

    Thanks for your quick response Hans. I did just that but for some reason my labels were all blank and it kept telling me that there were too many fields in the records. Any thoughts?

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

    Re: Labels from Excel Spreadsheet (2003)

    The address list must be recognizable as a data table, i.e.:
    - The first row must contain the field names (column headings)
    - Each row below that must contain the data for one address.
    - There should be no extraneaous data in or directly bordering on the table.
    - It's best if the table starts in cell A1, or if the data table is a named range.

  5. #5
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Labels from Excel Spreadsheet (2003)

    Thanks much! I was being dense!

Posting Permissions

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