Home Forums Classifieds GT Store Blogs Today's Posts Search Social Groups


Glock Talk
Welcome To The Glock Talk Forums.

Thread Tools Display Modes
Old 04-13-2010, 16:21   #1
Senior Member
Join Date: Nov 2002
Location: Red Sox Nation meets the Black Bear
Posts: 345
Easy to make name+address database?

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?
Thirties is offline   Reply With Quote
Old 04-13-2010, 16:50   #2
Sheriffs a near
cgwahl's Avatar
Join Date: Feb 2002
Location: CA
Posts: 11,329
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.
The irony of the information age is that we can't necessarily trust all the information.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 signatures.
cgwahl is offline   Reply With Quote
Old 04-13-2010, 17:51   #3
Senior Member
Join Date: Sep 2002
Location: CA, just outside the United States
Posts: 17,925
Blog Entries: 1
Send a message via AIM to Drjones

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?
The danger to America is not Barack Obama, but a citizenry capable of entrusting a man like him with the Presidency.
Drjones is offline   Reply With Quote
Old 04-13-2010, 19:43   #4
Senior Member
Join Date: Jan 2009
Posts: 983
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.
moncoacp is offline   Reply With Quote
Old 04-16-2010, 05:58   #5
Senior Member
Join Date: Nov 2002
Location: Red Sox Nation meets the Black Bear
Posts: 345
Thanks much for the assist . . . I'll try the method and let you know how it goes.
Thirties is offline   Reply With Quote
Old 04-16-2010, 18:08   #6
Obi Wan
Senior Member
Obi Wan's Avatar
Join Date: Oct 2007
Location: 'Round the bend...
Posts: 2,237
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.
"Political Correctness is a doctrine fostered by a delusional, illogical liberal minority, and rabidly promoted by an unscrupulous mainstream media, which holds forth the proposition that it is entirely possible to pick up a turd by the clean end." - Virg Muelleri
Obi Wan is offline   Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -6. The time now is 19:12.

GT Wiki
GT Blogs
Social Groups
GT Store

Users Currently Online: 1,404
386 Members
1,018 Guests

Most users ever online: 4,634
Apr 18, 2015 at 3:37