PDA

View Full Version : ISO easy method for printing a club membership directory


Romandub
09-24-2007, 12:41 PM
I am in charge of printing a hard-copy membership directory book for a club I am in. There are approximately 200 members and the membership information is on an Excel spreadsheet. The club is a parents' club, so in additon to parents' name and addresses, we need to include kids' names and contact info. Last year they used Word mail merge to do the directory, but there were some problems with the final product. Does anyone know of an easy software program that can convert an Excel spreadsheet into directory formatting information? We have all the data, it's just about formatting at this point into "directory style." Thanks for any suggestions!

lindrusso
09-24-2007, 12:45 PM
I'm not an expert, but can't you just set up the Excel sheet to print out the way you'd like it to look? A lot of people use Excel for forms and tables - it's an easy way to get everything to line up nicely.

How exactly would you like the directory to be set up?

funniegrrl
09-24-2007, 12:46 PM
Well, "mail merge" is what needs to happen more or less, whether the final product is in Word or something else. Usually problems with merges have to do with not having the spreadsheet/table set up correctly, or just not understanding the nuances of the merge software and formatting. That's going to be true no matter what software you use. In addition to Word and other word processing, the spreadsheet could be taken into MS Access or FileMaker and a report could generate the directory. You can also do a merge in MS Publisher and other layout programs.