OpenOffice is a free office suite that includes a database development tool. If you don't have OpenOffice on your computer, you can download the free software at the link provided below. The easiest way to create a new mailing list database is to use the wizards that are provided.
Creating a Mailing List Database in OpenOffice.org 3.0
Open the OpenOffice Suite by clicking the icon on your desktop. When you see the "Welcome" screen, click on the "Database" icon to start the database software.
When the first wizard opens, select "Create a New Database" and click next. Now, you're going to save your database. Select "Yes, register the database for me." Make sure both of the boxes are checked to open the database for editing and to create tables using the wizard, then click finish.
When the "My Documents" system folder opens, save your database with a name that is easy to remember, like "Marketing Mailing List," or some other name. As soon as you click "Save," the database will open for editing and the table wizard will open in a smaller window.
In the table wizard, select the type of database you want to create: business or personal. Then click the dropdown arrow under "Sample Tables." Scroll down to the "MailingList" option and select it. You will now see the options under "Available Fields" change to the available mailing list options. Select all of the options you want to include in your table by holding the control key and clicking on each option you want, then click the right-pointing arrow between the two boxes in the window. The selections you made will appear in the right window. Click "Next."
Now you're going to set the type and format for each field. Make your selections and changes for each field and click next. You will be taken to a screen that helps you to set up a primary key assignment for each database entry. It is already set to automatically assign a primary key. It's best to leave the settings alone, unless you're well versed in database administration. Click next.
The screen that appears gives you several options. At this point, you should create a form based on the table. Select that option at the bottom of the list. If you want to, you can change the name of the table, but it's best to leave it as it is. Click "Finish." This action will open the form wizard.
Click the double right arrow in the middle of the screen. All of the table fields will show up on the right side of the window. Use the up and down arrows to adjust the order you want the field to appear in on the form. Click finish. The form will open and is ready for you to start entering your mailing list data.