Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Word Labels from Excel spreadsheet data (Word 97 SR2)

    <img src=/S/question.gif border=0 alt=question width=15 height=15> I have a spreadsheet (my client actually) with a series of names and addresses, city, etc. in separate columns. They want to be able to print out address labels from Word for the people in this spreadsheet (unless there is a way to do it directly from Excel?). I have tried a few things and for small numbers of labels it is not bad - Copy to Word -> table in Word and then convert text to table and then fiddle around with the result to get it into something for labels. For a small number of labels this is not too time consuming, but they have a few hundred labels to produce <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>. Any insight anyone has on this will be greatly appreciated.

    Thanks <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Ron M

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    St. George, Maine, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Word Labels from Excel spreadsheet data (Word 97 SR2)

    Have you looked into Mail Merge to labels.

    Bob_D

  3. #3
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Calgary, Alberta, Canada
    Posts
    818
    Thanks
    6
    Thanked 1 Time in 1 Post

    Re: Word Labels from Excel spreadsheet data (Word 97 SR2)

    Did not know you could do that. I will definitely look into it. Thanks <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15> <img src=/S/smile.gif border=0 alt=smile width=15 height=15>


    Ron M

    Don't you just love this lounge!!! <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> <img src=/S/fanfare.gif border=0 alt=fanfare width=31 height=23>

Posting Permissions

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