Unit II Word Processor Open Office Mail merge can access a wide variety of data sources, including spreadsheets, text files and databases such as MySQL, Adabas, and ODBC The following example uses a spreadsheet with the following column (field) headers: Title, First name, Last name, Address, State/Country, Country, Post Code, Gender, and Points. The mail merge wizard is shown in Figure . . The following steps perform mail merge operation.
Tools -> Mail Merge Wizard Step : Select starting document This step has five options: Use the current document. Create a new document. Start from an existing document. Start from a template.
Start from a recently saved document. Choose “Create a new document” option and click Next Button Step : Select document type This step has two options: Letter E-mail message Choose “Letter” as option - to send letters to a group of recipients as shown in Figure . . Click Next button Figure .
Choose document type Step : Insert Address block This step helps to select the address list to be merged with the document as shown in Figure . . This step has four sections Click “ Select Address list ” button to choose the address list from an existing file or create a new address file. Click “Add” button to include the existing data source as shown in Figure .
. (or) Click “Create “ to create a new data source. This window shows default fields for the address as shown in Figure . .
Click “Customize” to add or delete or rename fields Note Minimum three fields must be selected when the user creates an address list. Figure . . Insert Address block Figure .
. Select Add Figure . New Address List Figure . Customize Address List In Figure .
, after selecting the required fields for the address list Click OK button. This will get back to the previous window, where the user can add records. Figure . Filled New Address List Click New to add more records If the user wants to delete any particular record, select the record using navigation buttons and then Click Delete