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. 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

    Feb 15, 2002
    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. 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


    Jan 16, 2009
    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. Thanks much for the assist . . . I'll try the method and let you know how it goes.
  6. Obi Wan

    Obi Wan

    Oct 13, 2007
    '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.