close

Privacy guaranteed - Your email is not shared with anyone.

Easy to make name+address database?

Discussion in 'Tech Talk' started by Thirties, Apr 13, 2010.

  1. Thirties

    Thirties

    Joined:
    Nov 24, 2002
    Messages:
    244
    Likes Received:
    0
    Location:
    Red Sox Nation meets the Black Bear
    I am trying to computerize our database (Rolodex) of friends, etc. There are about 200+ names and addresses. I'd like to have these in an Excel database, or Ms Word so I can print the list onto Avery labels.

    The MS Word Avery template is too difficult for my stupid brain to figure out.

    Anyone have any better ideas?
     
  2. cgwahl

    cgwahl Sheriffs a near

    Joined:
    Feb 15, 2002
    Messages:
    6,669
    Likes Received:
    960
    Location:
    CA
    Well, unless you're looking for something particularly fancy...MS Word should be able to do a mail merge off of Excel. So can always just type in your addresses into that, mail merge into the template and you're done.
     

  3. Drjones

    Drjones

    Joined:
    Sep 28, 2002
    Messages:
    6,157
    Likes Received:
    54
    Location:
    CA, just outside the United States
    Is your ultimate goal to create mailing labels?

    If so, then yes, enter the info into excel. Note that for a mail merge to work properly, you want each data value to be in its own cell: first name, last name, city, state, zip, etc. each need to be in their own cell/column, otherwise the merge doesn't work too well.

    If you want a salutation (Dr./Mr./Mrs.) that needs to have its own column too.

    So a properly set up address would look like this:

    Mr. | John | Thirties | 569 11th Ave | Glocktown | PA | 90210 |

    With each | indicating a new cell/column. Make sense?
     
  4. moncoacp

    moncoacp

    Joined:
    Jan 16, 2009
    Messages:
    983
    Likes Received:
    0
    DrJones is on the correct track. Once you get the spreadsheet set up you can also use it to send personalized letters to each person using the Word mail merge feature.
     
  5. Thirties

    Thirties

    Joined:
    Nov 24, 2002
    Messages:
    244
    Likes Received:
    0
    Location:
    Red Sox Nation meets the Black Bear
    Thanks much for the assist . . . I'll try the method and let you know how it goes.
     
  6. Obi Wan

    Obi Wan

    Joined:
    Oct 13, 2007
    Messages:
    2,113
    Likes Received:
    15
    Location:
    'Round the bend...
    Drjones nailed it. You can use the "Mail Merge" function in Word to walk you through the process when you're ready to test your mailing.