Home Forums Classifieds Blogs Today's Posts Search Social Groups



  
SIGN-UP
Notices

Glock Talk
Welcome To The Glock Talk Forums.

 
  
Reply
 
Thread Tools Display Modes
Old 04-13-2010, 16:21   #1
Thirties
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
cgwahl
Sheriffs a near
 
cgwahl's Avatar
 
Join Date: Feb 2002
Location: CA
Posts: 11,226
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
Drjones
Senior Member
 
Join Date: Sep 2002
Location: CA, just outside the United States
Posts: 17,908
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
moncoacp
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
Thirties
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,116
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

 
  
Reply

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 10:20.




Homepage
FAQ
Forums
Calendar
Advertise
Gallery
GT Wiki
GT Blogs
Social Groups
Classifieds


Users Currently Online: 1,266
310 Members
956 Guests

Most users ever online: 2,672
Aug 11, 2014 at 2:31