OpenOffice.org Address Books and Form Letters
Another choice for an address data source is an LDAP server. Selecting LDAP from the AutoPilot's Address Data Source window and then clicking Settings will bring up the Create Address Data Source window. Here you can specify the LDAP server's location and the user name and password required to access the server.
A documented issue with OpenOffice 1.0 is that the first connection to an LDAP server must be made as root. After this first connection is made, normal users can then access the server. I was able to connect to a test OpenLDAP server on my system, but I could not display any information from it. The OpenOffice.org web site indicates this is another known problem.
Finally, you can use dBase files as an address source. Simply pick Other from the AutoPilot's menu and select dBase as the Database type. Select the directory containing the .dbf file, and then make sure the correct filename is checked. After clicking OK, go through the field assignment procedure to map OpenOffice's address fields to the fields in the database.
One advantage of using a dBase file is you can edit the records it contains when the Data Sources window is displayed. Address books from other sources can't be edited from the Data Sources window.
OpenOffice.org does have some quirks when dealing with address books. Clicking the refresh button on the View Data Source window didn't actually update the data shown. The only way to show the updated information is to restart the application.
Another problem is the application will hang if you hide the Data Sources window while Mozilla/Netscape's address book is being viewed.
A form letter is a document containing fields populated by information from an address book. There are two ways to insert these fields into a document. One way is to position the cursor where you want the field and then click Insert -> Fields -> Other (keyboard shortcut Ctrl-F2). Click on the Database tab and select Form letter field in the Type list. In the Database Selection window pick the address book and field to insert, and then click the Insert button (see Figure 5). This will put a placeholder in your document where information from the address book will be inserted. Once you have inserted the fields that you need, click Close and continue editing your document.
The second way to insert fields is to display an address book in the Data Sources window and then drag column names from the table into your document.
After you have created and saved your form letter template, you have to generate the letters that will be sent to each addressee. These letters can be printed out, saved as individual files on your hard drive or sent as e-mail messages.
To generate form letters, click File -> Form Letter. This will bring up the Form Letter window where you can select which addressees to use (all, selected or a specific range). Choose whether the letters should be printed, saved to disk or e-mailed, and then click OK. Note that in order to send your form letters as e-mail, you must have Netscape 6.x installed. OpenOffice.org can't send form letters as e-mail using Mozilla.
OpenOffice.org offers you the ability to filter your address book data using SQL statements. Because you can create address books with custom fields, you can target form letters to specific customers based upon criteria such as a purchased product or a renewal date. You can also limit your form letter to addressees in specific area codes, zip codes or states.
To use this feature, open the Data Source Administration window (see Figure 6) by clicking Tools -> Data Sources. Select the database you wish to use, and then click on the Queries tab. Clicking on the New Queries button will bring up a SQL statement builder window (see Figure 7). This window allows you to build a query and run it to see its results. Make sure you include all the fields in your query that you will insert into your letter. Once the query works as you would like, you can save it with a descriptive name and use it again.
To insert fields from an SQL query, select the query as your database selection in the Fields dialogue (Insert -> Fields -> Other). When you generate the form letters (File -> Form Letters), select the query you wish to use from the Form Letter window instead of an address book table.
|Making Linux and Android Get Along (It's Not as Hard as It Sounds)||May 16, 2013|
|Drupal Is a Framework: Why Everyone Needs to Understand This||May 15, 2013|
|Home, My Backup Data Center||May 13, 2013|
|Non-Linux FOSS: Seashore||May 10, 2013|
|Trying to Tame the Tablet||May 08, 2013|
|Dart: a New Web Programming Experience||May 07, 2013|
- RSS Feeds
- New Products
- Making Linux and Android Get Along (It's Not as Hard as It Sounds)
- Drupal Is a Framework: Why Everyone Needs to Understand This
- A Topic for Discussion - Open Source Feature-Richness?
- Home, My Backup Data Center
- Readers' Choice Awards
- What's the tweeting protocol?
- Developer Poll
- New Products
- Reply to comment | Linux Journal
1 hour 25 min ago
- play with linux? i think you mean work-around linux
9 hours 51 min ago
- Where is Epistle?
9 hours 57 min ago
- You forgot OwnCloud
10 hours 27 min ago
- aplikasi free
13 hours 41 min ago
- Having a framework
13 hours 45 min ago
- Fix my computer
14 hours 25 min ago
18 hours 32 min ago
- Missed one
18 hours 51 min ago
- web Host
19 hours 17 sec ago
Enter to Win an Adafruit Prototyping Pi Plate Kit for Raspberry Pi
It's Raspberry Pi month at Linux Journal. Each week in May, Adafruit will be giving away a Pi-related prize to a lucky, randomly drawn LJ reader. Winners will be announced weekly.
Fill out the fields below to enter to win this week's prize-- a Prototyping Pi Plate Kit for Raspberry Pi.
Congratulations to our winners so far:
- 5-8-13, Pi Starter Pack: Jack Davis
- 5-15-13, Pi Model B 512MB RAM: Patrick Dunn
- Next winner announced on 5-21-13!
Free Webinar: Linux Backup and Recovery
Most companies incorporate backup procedures for critical data, which can be restored quickly if a loss occurs. However, fewer companies are prepared for catastrophic system failures, in which they lose all data, the entire operating system, applications, settings, patches and more, reducing their system(s) to “bare metal.” After all, before data can be restored to a system, there must be a system to restore it to.
In this one hour webinar, learn how to enhance your existing backup strategies for better disaster recovery preparedness using Storix System Backup Administrator (SBAdmin), a highly flexible bare-metal recovery solution for UNIX and Linux systems.