close this bookTidBITS#129   
View the documentClarisWorks Review
View the documentBasic Facts
View the documentIntegration
View the documentPage Layout Capabilities
View the documentImport/Export Features
View the documentMacros
View the documentWord Processing
View the documentGraphics
View the documentSpreadsheet and Charting
View the documentDatabase and Mail Merge
View the documentCommunications
View the documentLearning ClarisWorks
View the documentWhat's Not There
View the documentThe Bottom Line
View the documentClarisWorks Details
View the documentFoot Notes

Database and Mail Merge

The database document type/tool, although not fully integrated into the other modules, is a real treat. It's another seeming retread - basically FileMaker Plus. But what a retread! FileMaker Plus was a terrific flat file database that went through several generations to become FileMaker Pro. It had easy field design and flexible layouts, allowed inclusion of graphics, and was easily modifiable at any point. ClarisWorks updates only a few menus and incorporates the common ClarisWorks features - text and spreadsheet frames - within the overall graphical-object ClarisWorks framework. You'd be hard-pressed to find a much better low-end database.

There's not much integration of the database to the other document types, however. Data copied from the database pastes directly into spreadsheet and word processing frames as tab delimited text, but fields and layouts can't be integrated with charting and graphics.

Claris did integrate the database into the word processing document type in the most important way, or at least in the way in which most people will use it: the mail merge. When a database document is opened, any word processing document or frame can be used as a "model" letter for a mail merge. Selecting Mail Merge from the File menu automatically brings up a dialog box with all possible databases listed. Double-clicking a database brings up all the fields in the database. Double-clicking a field name inserts the field marker at the insertion point. The whole database can then be merged with a click of the OK button. I have yet to see a less painful way of doing a mail merge.