Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Dec 2000
    Location
    North Epping, New South Wales, Australia
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    excel to printing labels (excel 2002)

    I have a database of over 350 names, addresses,etc, from my bowling club.
    I like to print out labels on an Avery type sheet with only the names and addresses for mailing.
    Word has an envelopes and labels section, but I cannot find that in Excel.

    How do I tranfer the names and addresses into mailmerge?
    Do I have to transfer it to Access (which I have never used it)
    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20> <font face="BrushScript BT"> Cees </font face=brush>
    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18> <img src=/S/flags/Netherlands.gif border=0 alt=Netherlands width=30 height=18>

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

    Re: excel to printing labels (excel 2002)

    Word can do a mail merge with addresses from an Excel workbook. Prerequisite is that your address list is set up in table form, with field names in the first row, and each address in a separate row below it.

    This is OK:

    <table border=1><td>First Name</td><td>Last Name</td><td>Street</td><td>City</td><td>John</td><td>Evans</td><td>3 Power Lane</td><td>Canberra</td><td>Mary</td><td>Dewar</td><td>51 Cookaburra Drive</td><td>Melbourne</td></table>
    This is NOT suitable:

    <table border=1><td>First Name</td><td>John</td><td>Mary</td><td>Last Name</td><td>Evans</td><td>Dewar</td><td>Street</td><td>3 Power Lane</td><td>51 Cookaburra Drive</td><td>City</td><td>Canberra</td><td>Melbourne</td></table>
    If you do a mail merge (to labels) in Word 2002, the third step will let you browse for an existing list of recipients; .xls is one of the recognized file types.

  3. #3
    Lounger
    Join Date
    Dec 2000
    Location
    North Epping, New South Wales, Australia
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel to printing labels (excel 2002)

    Thanks Hans. I'll give it go tomorrow, Saturday.
    Right now it is time to turn of the computer (Mrs T will be happy)
    and watch some of the Rugby Union World Cup.(Mrs T might not be so happy [img]/forums/images/smilies/smile.gif[/img] )
    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20> <font face="BrushScript BT"> Cees </font face=brush>
    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18> <img src=/S/flags/Netherlands.gif border=0 alt=Netherlands width=30 height=18>

Posting Permissions

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