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
    Expand Collapse

    Joined:
    Nov 24, 2002
    244
    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?
     

    Wanna kill these ads? We can help!
  2. cgwahl

    cgwahl
    Expand Collapse
    Sheriffs a near

    Joined:
    Feb 15, 2002
    6,283
    12
    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
    Expand Collapse

    Joined:
    Sep 28, 2002
    6,117
    1
    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
    Expand Collapse

    Joined:
    Jan 16, 2009
    983
    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
    Expand Collapse

    Joined:
    Nov 24, 2002
    244
    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
    Expand Collapse

    Joined:
    Oct 13, 2007
    2,105
    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.
     
Loading...
Similar Threads Forum Date
Easy to Use Sharpener? The Cutting Edge Jun 23, 2012
How easy to find General Firearms Forum Jun 6, 2012
Concealed carry permit? Be ready to see your name in Star database Indiana Glockers Feb 19, 2007
Need easy to make dinner recipes!!!!! Food Forum Jan 26, 2007
web page connection to database Tech Talk Apr 18, 2006
Duty Gear at CopsPlus