Mail Merge

OpenOffice.org 2.0

Document - ID	Specification Owner	Last Change	Status
	Christian Jansen	June 07, 2005	Final
Applies to	OpenOffice.org Writer
Task ID(s)	i20057
Category	Feature
Product Version	OpenOffice.org 2.0

Abstract

The Mail Merge functionality will be totally renewed. The user will be assisted by a Merge Wizard. Advanced users will get a Toolbar from where the most needed functions for creating a Merge are accessible. The new Merge will also be much more flexible in managing & editing databases and allows to save into one single file.

i-Team Members (The specification owner is part of the i-Team)

	Name	E-mail Address
User Experience	Christian Jansen	Cj@openoffice.org,
Development	Oliver Specht	Os@openoffice.org,
	Tino Rachui	Tra@openoffice.org,
Quality Assurance	Hasan Ilter	Hi@openoffice.org,
Documentation	Uwe Fischer	Ufi@openoffice.org

Approved for Implementation

	Approved by	Date
User Experience	Christian Jansen	04/14/04
Development	Oliver Specht	04/14/04
	Tino Raccui	04/24/04
Quality Assurance	Hasan Ilter	04/22/04
Documentation	Uwe Fischer	04/22/04
	Frank Peters	04/22/04
String Review	Paul Compton; Elizabeth Matthis; Matthias Müller-Prove	08/09/04; 11/08/04; 8/13/04

Document Change History

Rev. Level	Change	Initials	Date
1.0	Initial Draft	CJ	04/01/04
1.1	Revised Draft	CJ	04/13/04
1.2	Revised Draft based on feedback from Uwe, Frank & Tino	CJ	04/19/04
1.3	Revised Draft based on feedback from Oliver	CJ	04/21/04
1.4	Strings changed for adressblock examples	CJ	04/28/04
1.5	Add section to link database selection process to Writer Spec.	FL	05/03/04
1.6	Changes in Address block-, Select Addresses-, AddGreetings-, & Custom Greeting Line dialog. Revised failure msg which appears when testing e-mail account settings	CJ	06/09/04
1.7	Changes in Custom Address block; Send Document as E-Mail chaged;Warnings for No Subject and Unchanged Attachment Name added	CJ	01/07/04
	added mnemonic for menu item "Mail Merge Wizard..." (row 130)	MMP	7/19/04
final	accepted all tracked changes. Previeous version is at http://staroffice-doc/Teams/User_Experience/Team/em/SpecStrgRevs_SO8/mailmerge_specification_MMP12Aug04.sxw open questions are marked with “##”; mnemonics are not up-to-date	MMP	8/13/04
1.8	Progress indicator for merging documents added	CJ	Oct 26, 04
1.9	Add Data Source: File type list revised	CJ	Dec 28, 04
1.10	Changed “Technical Dependencies” section. It is now stated that an email service has to be registered within OOo 2.0 in order to enable the email functionality of Mail Merge. Before it has be suggested that only Javamail need to be installed for enabling email in Mail Merge.	TRA	June 07, 05

Contents

Glossary	1

1	Motivation	1

2	User Scenarios	1

3	Goals	1

4	Requirements and Dependencies	1

4.1	Requirements	1

4.2	Technical Dependencies	2

5	Competitive Analyses	2

5.1	Performing a Mail Merge in Word 2002 and 2003 []	2

6	Detailed Specification	9

6.1	Step 1 – Starting Document	9

6.2	Step 2 – Document Type	11

6.3	Step 3 (Letter) – Address Block	13

6.3.1	Selecting an Address List	15

6.3.2	Add Data Source	16

6.3.3	Choosing another Table	20

6.3.4	Typing an Address List – New Address List	20

6.3.5	Typing an Address List – Find	22

6.3.6	Typing an Address List – Customize	22

6.3.7	Selecting The Address	25

6.3.8	Creating a Custom Address Block	27

6.3.9	Address Block - The Preview	29

6.3.10	Address Block -Matching Fields	29

6.4	Step 3 (E-Mail) – Address List	31

6.5	Step 4 – Greeting Line	32

6.5.1	Step 4 - Personalized Greeting Line	33

6.5.2	Step 4 - Neutral Greetings Lines	37

6.5.3	Step 4 – The Preview	37

6.6	Step 5 – Layout	40

6.7	Step 6 – Prepare Merge	42

6.8	Step 7 – Personalize	44

6.9	Step 8 - Save, Print & Send	46

6.9.1	Step 8 - Save Starting Document	46

6.9.2	Step 8 - Save Merged Document	47

6.9.3	Step 8 – Print Merged Document	49

6.9.4	Step 8 – Send merged document as E-mail	50

6.10	Sending Out an E-Mail	56

6.10.1	Configuration of E-Mail settings	56

6.10.2	Progress of Sending E-Mails	59

6.11	Handling of Partially Successful E-Mail Sending Jobs	61

7	Future Tasks	62

7.1	Handling of partially successful e-mail Merge Jobs in the Future	62

8	Notes & Issues	64

9	References	65

Glossary

Term	Description
Mail Merge	A function of some word processing software that produces multiple instances of a document by substituting different text strings from a database in place of certain field markers. This is often done with mass mailings.
Data Source	

Motivation

OpenOffice.org mail merge too difficult to use and should follow standard approach known from competing products .

User Scenarios

User A want to send a mailing to 100 different recipients. User A uses a data source, in this case a OpenOffice.org Spreadsheet, as a container for the address. Now, user A wants to create the address block and the greeting line automatically.

User B want to send out an advertising brochure by e-mail to 1000 different recipients. The Mail shall provide a body and the advertising brochure shall be attached as PDF.

User C wants to send out a party invitation to a well known circle of friends. The greeting line shall be informal but shall contain the first name of each recipient.

Goals

Usability studies have shown that the current (OpenOffice.org 1.1 or before) mail merge feature is too hard to use for the standard user. It is also not possible to send out merged documents by mail.

Goal is to provide a user-friendly tool which guides the user through the steps of creating a merge. It is also a goal to allow users to send out the merged documents by mail.

Requirements and Dependencies

Requirements

Reduce the ways to insert and select fields, each with their own feature sets. The Mail Merge tabbed dialog has different features from the Insert Field palette which in turn has different features than the Data Source drop-down panel.

Provide preview mode showing live data in place of fields.

It should be possible--even EASY--to pick a tabular data source (CSV, spreadsheet, DBF, whatever) and go straight into dropping fields into the working document. Requiring users to set up a data source first creates several extra steps and is confusing when reuse isn't going to happen.

When merging to files, the current UI creates a separate output document for each data record, so if users are making 30 envelopes, users creating 30 saved files of one envelope each. This has its uses, but I think many, many, many users prefer the option of being able to merge to a single 30-page document. It's sure easier to print or tweak the result that way.

Technical Dependencies

Sending mail merge via email is only possible if an email service is registered within OpenOffice.org. This service has to implement a couple of interfaces necessary for the email functionality e.g.:
- com.sun.star.mail.XMailServiceProvider
- com.sun.star.mail.XMailServer
- com.sun.star.mail.XSmtpService
- com.sun.star.mail.XMailService
For more information have a look at the documentation of these interfaces in the offapi project under '<offapi>/com/sun/star/mail'."
StarOffice will provide the needed email service, so that a working system is assured for this product.

The new wizards [ ] have to be available in C++

Competitive Analyses

Performing a Mail Merge in Word 2002 and 2003 [ ]

With Microsoft Office 2002 and 2003, many common tasks have been simplified, not the least of which is that of performing a mail merge. Using the Mail Merge Wizard in Word 2002 and 2003 lets you create and merge a form letter in minutes. Here's how:

Step One:

Start with a blank document, then if your Task Pane isn't showing, go to the View menu and select Task Pane.

Click the arrow at the top of the Task Pane and select Mail Merge.

You'll be asked to select a Document Type. Select Letters.

Click Next: Starting Document at the bottom on the task pane.

Figure 1 Select document Type

Step Two:

Now you have a choice as to your starting document:

If you are starting from scratch, click Use the current document.

If you wish to start from a template, click Start from template and select a template.

If you have already prepared your letter, click Start from existing document, then find and open the document you plan to use.

Figure 2 Select starting document

Step Three:

Next, you need to select your recipients:

If you have an existing database, click Use an existing list, and then click Browse to find it.

If you wish to use your Outlook contacts, click Select from Outlook contacts, then click Choose Contacts folder. Select the folder you wish to use and click OK.

If you don't have a database of recipients and wish to start from scratch, click Type a new list, and then click Create. Enter each contact's information into the fields provided. When you're done with an individual entry, click New Entry. When you're done with your database, click Close.

Give your data source a name and click Save.

Now you have the opportunity to edit your recipient list. If you wish to do so, click Edit recipient list. If you wish to exclude any of the contacts on your list, you can do so by deselecting the ticked box on the left. When you're done, click OK.

Figure 3 Select Recipients

Step Four:

Click Next: Write your letter.

If you haven't already done so, type your letter.

Next, click on the place in your document where you wish your address block to appear.

Click Address Block to select the format of your recipients' names.

Select whether you would like to include company names and postal addresses.

When you're done, click OK.

Now click on your document where you want your greeting line to appear and click Greeting Line.

Select your greeting line format and click OK.

When you're happy with your letter, click Next: Preview your letters.

Figure 4 Writer your letter

Step Five:

Browse through your letters using the back and forward buttons.

When you're satisfied, click Next: Complete the Merge.

Figure 5 Preview your letters

Step Six:

Now you can either choose to print your letters, or if you wish you can edit individual letters by clicking Edit individual letters.

In the Merge to New Document dialog box, select the letters you wish to merge.

Click OK.

A new document will open containing all the letters. Use this document to make changes to individual letters.

Your original document will remain open in the background. Use this if you wish to make changes to all your letters simultaneously.

When you're done, print or save your document.

Figure 6 Complete the merge

Now that your letters are done, think about how much time it would save you to merge your envelopes:

Press Control N to start a new document.

This time, select Envelopes as your document type.

Click Next: Starting Document.

Select Change document layout, then click Envelope options.

Select the size that matches the envelopes you plan to use.

Make any desired changes to your layout, then click OK.

Click Next: Select recipients, and follow the instructions in Step Three above.

Click Next: Arrange your envelope.

Click the place on the envelope where you wish the name and address to appear and click Address Block. Select your desired format and click OK.

Click Next: Preview your envelopes.

Flip through your envelopes to check that everything is in order.

Click Next: Complete the merge.

Click Print. Select the envelopes that you wish to merge and click OK.

Detailed Specification

Mail Merge in OpenOffice.org 2.0 is represented by a wizard the main target group for using this wizard are users knowing what a mail merge is.

Users can access the Mail Merge feature from the Tools menu. Table 1 shows the Extras menu extended by the Mail Merge entries.

Tools Menu

...

Gallery

---------------

Bibliography Database

Data Source...

---------------

Mail Merge Wizard...

---------------

Text <-> Table

...

String list

Item	English	German	Comments
Menu Entry	Mail Merge ~Wizard...	Serienbrief-Assistent...	

Step 1 – Starting Document

Choosing the “Mail Merge Wizard...” menu item opens the Mail Merge Wizard. The Mail Merge Wizard is a modal dialog with 8 steps. Detailed information can be found in the general wizard specification [ ]. The first step of the wizard asks users how to start. Users have the choice between the options listed below:

Use the current document
The 'Use the current document' option is the default action – the wizard uses the existing document as basis.

Create new document
'Create new document' opens a new document which will be used as basis for the merge

Start from existing document
'Start from existing document' opens a a file picker pointing to the 'my documents' folder. Users can select a file. The file will be used as basis for the merge. File type list shall only show Text documents. Selecting this option and clicking next opens also the file picker.

Start from template
'Start from template' opens the Document & template dialog. Users can select a template. The file will be used as basis for the merge.

Start from recently saved starting document
This drop down lists all starting documents saved at step 8 of the wizard. At the first start of the wizard the list is empty due to this the whole feature is inactive. It gets active when the user saved a document by using the “Save Starting Document” feature.

The Starting document step shall look like shown in Figure 7.

Figure 7 First Step of the Mail Merge Wizard (Note that the window title should be “Mail Merge Wizard” for all steps.)

String list

Item	English	German	Comments
Wizard Title Bar	Mail Merge Wizard	Serienbrief-Assistent	
Road Map	Steps	Schritte	
Road Map	1. Select starting document	1. Ausgangsdokument wählen	
Road Map	2. Select document type	2. Dokumenttyp wählen	
Road Map	3. Insert address block	3. Adressblock einfügen	Display in case of letter
Road Map	3. Select address list	3. Adressenliste wählen	Display in case of e-mail
Road Map	4. Create salutation	4. Briefanrede erstellen	
Road Map	5. Adjust layout	5. Layout anpassen	
Road Map	6. Edit document	6. Dokument bearbeiten	
Road Map	7. Personalize document	7. Dokument personalisieren	
Road Map	8. Save, print or send	8. Speichern, drucken, versenden	
Text Field	Select the document upon which to base the mail merge document.	Wählen Sie auf welchem Dokument der Serienbrief basieren soll.	
Radio Button Label	Use the current ~document	A~ktuelles Dokument verwenden	
Radio Button Label	Create a ne~w document	~Neues Dokument erstellen	
Radio Button Label	Start from an ~existing document	~Bestehendes Dokument verwenden	
Button Label	~Browse...	~Durchsuchen...	
Radio Button Label	Start from a ~template	~Vorlage verwenden	
Button Label	B~rowse...	D~urchsuchen...	
Label	Start fro~m a recently saved starting document	Zuletzt ~gespeicherte Ausgangsdokumente	
Label	~Help	~Hilfe	
Label	<<~Back	<<~Zurück	
Label	~Next>>	~Weiter>>	
Label	~Finish	~Fertig stellen	
Label	~Cancel	~Abbrechen	

Heading	Select the starting document for the mail merge	Wählen Sie das Ausgangsdokument des Serienbriefes	

Step 2 – Document Type

Step 2 (Figure 8) is the step from where users can select between different document types they want to create.

The step provides the following options:

Letter
This is the default, Selecting Letter inserts an address block and a greetings line into the document.

E-Mail-Message
The E-Mail option inserts only a greetings line into the document.

Selecting E-Mail shall change the heading stated in the roadmap of step 3 from 'Address Block' to 'Address List'.

Depending on the selected option the wizard shall display the correct note.

Figure 8 The second step of the Mail Merge Wizard. Users can select between several documents they want to create.

String list

Item	English	German	Comments
Wizard Heading	Select a document type	Bitte wählen Sie einen Dokumenttyp	
Text Field	What type of document do you want to create?	Was für ein Dokument möchten Sie erstellen?	
Radio Button Label	~Letter	~Brief	
Radio Button Label	~E-mail Message	~E-Mail-Nachricht	
Text Field	Letter:	Brief:	Shall be displayed bold
Text Field	Send letters to a group of recipients. The letters can contain an address block and a salutation. The letters can be personalized for each recipient.	Briefe werden an eine Liste von Empfängern verschickt. Sie können einen Adressblock und eine Anredezeile enthalten. Die Briefe können auch für jeden Empfänger personalisiert werden.	DISPLAY WHEN LETTER IS SELECT
Text Field	E-Mail Message:	E-Mail-Nachricht:	Shall be displayed bold
Text Field	Send e-mail messages to a group of recipients. The e-mail messages can contain a salutation. The e-mail messages can be personalized for each recipient.	E-Mail-Nachrichten werden an eine Liste von Empfängern verschickt. Die Nachrichten können eine Anredezeile enthalten. Sie können auch für jeden Empfänger personalisiert werden.	DISPLAY WHEN E-MAIL MESSAGES IS SELECTED

In case no appropriate email service is installed (see 1) the E-Mail option shall be disabled. In this case the wizard shall tell the user why it is disabled. Therefore, an information shall be display on the located below the description of the 'Letter' feature.

String list

Item	English	German	Comments
Text Field	Note:	Hinweis:	Shall be displayed bold
Text Field	In order to send e-mail messages with %PRODUCTNAME, you need to install the latest version of Java Mail. You can find further information about Java Mail on the internet at 'http://java.sun.com/products/javamail/'.	Um Nachrichten mit %PRODUCTNAME versenden zu können, muss die aktuellste Version von Java Mail installiert sein. Weitere Informationen zu Java Mail finden Sie im Internet unter 'http://java.sun.com/products/javamail/'.	

When an email service is available Selecting the 'E-mail' option shall check if it is working other wise the wizard shall display an alert specified below:

String list

Item	English	German	Comments
Title Bar	%PRODUCTNAME %PRODUCTVERSION	%PRODUCTNAME %PRODUCTVERSION	
Warning Text	%PRODUCTNAME was unable to find a Java Mail connection. In order to send e-mail messages with %PRODUCTNAME, you need to install the latest version of Java Mail. You can find further information about Java Mail on the internet at 'http://java.sun.com/products/javamail/'.	%PRODUCTNAME konnte auf Ihrem System keine Java Mail Anbindung finden. Um Nachrichten mit %PRODUCTNAME versenden zu können, muss die aktuellste Version von Java Mail installiert sein. Weitere Informationen zu Java Mail finden Sie im Internet unter 'http://java.sun.com/products/javamail/'.	
	OK	OK	

Step 3 (Letter) – Address Block

The address block step allows users to select the data source which shall be used to complete the merge. It provides address block defaults and a preview. The preview informs users if elements don't match correctly.

Figure 9 shows the wizard page. The feature are specified in detail below:

Figure 9 Third step of the Mail Merge Wizard showing options for address block configuration

String list

Item	English	German	Comments
Heading	Insert address block	Adressblock einfügen	
Text Field	1. Select the address list containing the address data you want to use. This data is needed to create the address block.	1. Wählen Sie, aus welcher Adressenliste die Adressdaten bezogen werden sollen. Die Daten der Adressenliste werden für den Adressblock benötigt.	
Button Label	Select A~ddress List....	Adr~essenliste auswählen...	Default, if document isn't assigned to an address list.
Button Label	Select ~Different Address List....	Ander~e Adressenliste auswählen...	Shall be displayed if document is assigned to a database.
Text Field	Current address list:	Aktuelle Adressenliste:	This string shall appear only if a document is successfully assigned to a database.
Text Field	2. Select the address block you want inserted in the document.	2. Wählen Sie den Adressblock, der in das Dokument eingefügt werden soll.	
Check Box Label	~This document should contain an address block	~Diese Dokument soll einen Adressblock enthalten	##PJC: this is confusing. If not checked then steps 1 & 3 seem to be irrelevant.
Button Label	~More...	~Mehr...	
Text Field	3. Check if the address data matches correctly.	3. Überprüfen Sie, ob alle Adressdaten verfügbar sind.	
Text Field	< not available >	< nicht verfügbar >	
Button Label	Match ~Fields...	~Felder zuordnen...	
Text Field	Document:	Dokument:	
Tool Tip	Preview Previous Address Block	Adressblock des vorigen Dokuments ansehen	
Tool Tip	Preview Next Address Block	Adressblock des nächsten Dokuments ansehen	

Selecting an Address List

As long no address is assigned to a document the 'Next', 'More...', 'Match Fields...' & all controls of step 2 & 3 shall be disabled. When an address list is assign a string shall be displayed right under the 'Address List...' Button.

In the case a document has been load which is already assigned to a database the the wizard shall start on step 3 (Address block). The wizard step shall display the user which database will be used and the string for selecting an address list shall be 'Different Address List...'

Clicking the “Address list” button open a dialog from where users can select from existing data sources, add new ones or can create a new address list by typing it. (Figure 10). For the more experienced user it is possible to filter the data they want to import.

The dialog lists by default the supported address books of the default E-Mail program. On Windows are these Outlook, Outlook Express and Mozilla (and all its sub versions like Thunderbird or Netscape Communicator for example) On Linux Mozilla and Evolution.

Figure 10 Select Address Dialog

String List

Item	English	German	Comments
Title Bar	Select Address List	Adressenliste auswählen	
Text Field	Select an address list. Click 'Add...' to select recipients from a different list. If you do not have an address list you can create one by clicking 'Create...'.	Wählen Sie eine Adressenliste. Klicken Sie auf 'Hinzufügen...', um weitere Adressenlisten zu verwenden. Liegt noch keine Adressenliste vor, klicken Sie auf 'Erstellen...'.	
Text Field	Your recipients are currently selected from:	Zurzeit werden Ihre Empfänger gewählt aus:	
Heading Field	Data source name	Datenquellenname	
Heading Field	Table	Tabelle	
Button Label	Add...	Hinzufügen...	
Button Label	Create...	Erstellen...	
Button Label	Filter...	Filtern...	
Button Label	Edit....	Bearbeiten...	
Button Label	Change Table...	Andere Tabelle...	
Button Label	OK	OK	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	

Add Data Source

Users can add a data source by clicking 'Add...' button. A file picker appears pointing by default to the My Documents folder. The file type list shall provide the following filter patterns:

<Address Lists>	(& extension list of the file formats listed below )
<Address Lists>	(*. EXTENSIONLETTERS OF THE MOST CURRENT BASE FORMAT [ ]; *.csv; *. EXTENSIONLETTER OF THE MOST CURRENT CALC FORMAT ;*.sxc; *.xls; *.txt; *.dbf)
<All Files>	(*.*)
%PRODUCTNAME Base [ ]	*. EXTENSIONLETTERS OF THE MOST CURRENT BASE FORMAT
%PRODUCTNAME Calc	*. EXTENSIONLETTER OF THE MOST CURRENT CALC FORMAT; *.sxc
dBase	*.dbf
Microsoft Excel	*.xls
Plain Text	*.txt
Text Comma Separated	*.csv

After the user selected a file. It has to be tested if the to be opened file contains more then one table, if yes, a dialog has to appear from where users can select the table they want the access. Users shall have access to Views (Note: Discuss with Database Team if this will be possible for OO.o 2.0 ), Queries & Tables. Figure 11 shows the Table Selected Dialog.

Figure 11 The Select Table dialog appears if a data source contains more than one table

String list

Item	English	German	Comments
Title Bar	Select Table	Tabelle auswählen	
Text Field	The file you have selected contains more than one table. Please select the table containing the address list you want to use.	Die von Ihnen gewählte Datei beinhaltet mehrere Tabellen. Bitte wählen Sie die Tabelle mit der Adressenliste, die Sie verwenden möchten.	
Heading Field	Table name	Tabellenname	
Heading Field	Type	Typ	
Text	Table	Tabelle	
Text	Query	Abfrage	
Text	View	Ansicht	
Button Label	~Preview...	~Vorschau...	
Button Label	OK	OK	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	

In the case OpenOffice.org could not open the file a warning shall appear informing the user that this file could not be opened.

String list

Item	English	German	Comments
Title Bar	%PRODUCTNAME %PRODUCTVERSION	%PRODUCTNAME %PRODUCTVERSION	
Text Field	Could not open “C:\xxxx.ttt”. The file is not in the expected format.	„C:\xxxx.ttt“ kann nicht geöffnet werden. Die Datei hat nicht das richtige Format.	
	OK	OK	

For users who don't know the content of each table a preview button allows them to preview the content of each table. Clicking 'Preview' opens a dialog which shows the contents of a table. The first entries shall be displayed within 2 seconds.

Figure 12 Showing a preview of a data source.

String list

Item	English	German	Comments
Title Bar	Mail Merge Recipients	Serienbriefempfänger	
Text Field	The list below shows the contents of:	Die folgende Liste zeigt den Inhalt von:	German??
Button Label	Close	~Schließen	

Figure 13 Shows the manually added address list.

Users can filter recipient by clicking the 'Filter...' button. This calls the Default Filter dialog (shown below). Known from OpenOffice.org 1.1

Figure 14 Default Filter Dialog; same as in OpenOffice.org 1.1

Choosing another Table

When a document is assigned to a database containing more than one table, users can change the table from where the address list data is selected. Clicking “Other Table” in the “Select Address List” dialog opens the Select Table dialog, now with the currently assigned table preselected.

Typing an Address List – New Address List

If no address list is available, but the user wants to create one. Users can do this by selecting 'Create...' in the Select Address List dialog.

'Create...' opens a dialog like shown in figure 14. From here users can create address lists. Right after opening the dialog the cursor shall be placed in the 'Title' text edit. Pressing Tab moves the curser to the next edit field. The dialog offers user the options listed below:

Clicking New creates a new record page, and the counter displayed in the view entry has to increase by 1.

Clicking OK closes the dialog and calls a Save As file picker, where user can save the typed list as StarOffice Address List

NOTE: The address list shall be saved as coma separated text file (CSV – UTF8 Formatted), the delimiter shall be tab, the default location shall be My Documents on Windows platform and on Linux the document folder of the Window Manager.

The 'Edit...' button allows user to edit existing address lists created by using the 'New Address List' Dialog(Figure 14).

String list

Item	English	German	Comments
Sava As Default	%PRODUCTNAME Address List (.csv)	% PRODUCTNAME Adressenliste (.csv)	

Delete deletes the currently displayed record. When only one record is left and is also empty the delete button shall be disabled. If one entry is left but containing data delete shall delete the data and change to the disabled state.

'Find...' allows users to search within the stack of entries.

'Customize...' allows the user to modify the order and the content of the entries.

The Address Information list offers a collection of predefined text elements where users can type in address information. It shall also be possible define the gender of a recipient. For doing such users shall have the possibility to select between female & male. Therefore a combo box shall be available in the address list. The 'gender' entry shall not be visible in Custom Greeting Line & Custom Address Block.

Figure 15 New Address List dialog

String list

Item	English	German	Comments
Title Bar	New Address List	Neue Adressenliste	
Text Field	Address Information	Adressdaten	
Text Edit Label	Title	Titel	
Text Edit Label	First name	Vorname	
Text Edit Label	Last name	Nachname	
Text Edit Label	Company name	Firmenname	
Text Edit Label	Address line 1	Adresszeile 1	
Text Edit Label	Address line 2	Adresszeile 2	
Text Edit Label	City	Ort	
Text Edit Label	State	Bundesland	
Text Edit Label	ZIP code	Postleitzahl	
Text Edit Label	Country	Land	
Text Edit Label	Telephone private	Telefon privat	
Text Edit Label	Telephone business	Telefon beruflich	
Text Edit Label	E-mail address	E-Mail-Adresse	
Text Label	Gender	Geschlecht	
DD Combo Box Entry	Female	Weiblich	
DD Combo Box Entry	Male	Männlich	
Button Label	~New	~Neu	
Button Label	~Delete	~Löschen	
Button Label	~Find...	~Suchen...	
Button Label	C~ustomize...	A~npassen...	
Text Edit Label	Sho~w entry number	~Eintragsnummer anzeigen	
Tool Tip	First	Erster	
Tool Tip	Previous	Vorheriger	
Tool Tip	Next	Nächster	
Tool Tip	Last	Letzter	
Button Label	OK	OK	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	

Typing an Address List – Find

Users can search for strings listed in the field of an entry. It is also possible to perform search only in one category. The Find dialog (Figure 15) shall be modeless, this assures the user can modify address book data while the dialog is still open. The search shall work like the Text Search of the 'Search Database' feature located in the Database Window (press F4 in Writer). Find shall start searching at the first table entry, found entries shall be displayed like in the Data Source Window of OpenOffice.org 1.1.

Figure 16 Find Entry Dialog of the Type Address List feature.

String list

Item	English	German	Comments
Title Bar	Find Entry	Eintrag suchen	
Text Edit Label	F~ind	Suchen	
Check Box Label	Find ~only in	Nur suchen in	
Button Label	~Find	S~uchen	
Button Label	~Close	~Schließen	
Button Label	Help	~Hilfe	

Typing an Address List – Customize

In some cases the elements provided by OpenOffice.org do not meet the user's needs. eg. The user needs a different order of the elements or different elements at all. For this case users can Add, Delete, Rename or move the elements of the entries. Figure 16 shows a mock up of the Customize Address List dialog.

Figure 17 Dialog for customizing an address list

String list

Item	English	German	Comments
Title Bar	Customize Address List	Adressenliste anpassen	
List Box Label	A~ddress list elements	Adresslistenelemente	
Button Label	~Add...	H~inzufügen...	
Button Label	~Delete	~Löschen	
Button Label	~Rename...	~Umbenennen...	
Tool Tip	Move up	Nach oben	
Tool Tip	Move down	Nach unten	
Button Label	OK	OK	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	

Users can modify the element order by clicking move up or move down (visualized by arrow up & down). Adding a custom element can be achieved by pressing the 'Add..' button. Clicking that button will open a dialog like shown in figure 17. The Add Element dialog comes up with a non existing default name (possible name scheme: Custom 1) for an element which shall be highlight so that the default can easily be changed to users needs.

Figure 18 Add Field

String list

Item	English	German	Comments
Title Bar	Add Element	Element hinzufügen	
Text Edit Label	Element name	Elementname	
Default Text	Custom	Neues Element	
Button Label	OK	OK	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	

In case an element already exists a warning shall appear after clicking OK.

String list

Item	English	German	Comments
Title Bar	%PRODUCTNAME %PRODUCTVERSION	%PRODUCTNAME %PRODUCTVERSION	
Text	This list already has an element with this name. Please type a different element name.	Die Liste enthält bereits ein Element mit diesem Namen. Bitte wählen Sie einen anderen Namen.	
Button Label	OK	OK	

Renaming Elements is possible by pressing 'Rename' in the Customize Address List dialog. A dialog like 'Add Element' shall appear, but displaying the element selected in the Customize Address List dialog.

Figure 19 Rename field dialog

String list

Item	English	German	Comments
Title Bar	Rename Element	Element umbenennen	
Text Edit Label	Element name	Elementname	
Button Label	OK	OK	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	

Selecting The Address

In this chapter the workflow of selecting and creating address blocks is described.

Figure 20 Select Address Block

The wizards provides for fast access two standard address blocks. Note: these have to be localized for usage in different counties. For example the Korean version of OpenOffice.org shall display typical Korean address blocks.

For Germany user shall choose from these address blocks

German Address Blocks Examples
Anrede Vorname Name Straße Postleitzahl Stadt	Anrede Vorname Name Straße Postleitzahl Stadt Land
Firma Anrede Name Straße Postleitzahl Stadt	Firma Anrede Name Straße Postleitzahl Stadt Land

String list

Item	English	German	Comments
Text	Title	Anrede	
Text	First Name	Vorname	
Text	Last Name	Name	
Text	Street	Straße	
Text	ZIP	Postleitzahl	
Text	City	Stadt	
Text	Country	Land	

Users who need additional or a custom Address block have to click 'More...'. This opens a dialog shown in figure 20. From here users can select from several other default address blocks. Users can also a define a rule for inserting the country/region. Depending on the previously selected address block users can choose between:

Never include the country/region

'Always include the country/region

Only include the country/region if different than:

The address block shall reflect the settings, i.e. will the country appear/disappear in the preview accordingly.

If none of the defaults fits to users need than they can have two options:

Create a custom address block or,

Modify an existing.

Newly created address blocks shall be added to the end of the address block list. and be shall selected. The currently selected address block shall also appear in the address block list of wizard step 3.

Figure 21 Dialog for selecting additional address blocks

String list

Item	English	German	Comments
Title Bar	Select Address Block	Adressblock auswählen	
Listbox Label	~Select your preferred address block	Bitte ~wählen Sie einen Adressblock	
Text Field	Address block settings	Adressblock Eigenschaften	
Option Button	N~ever include country/region	Land/Region ~niemals in Adresse einfügen	
Option Button	~Always include country/region	~Immer Land/Region in Adresse einfügen	
Option Button	Only ~include country/region if it is not:	Land/Region nur dann einfügen, ~wenn anders als:	
Button Label	~New...	~Neu...	
Button Label	~Edit...	~Bearbeiten...	
Button Label	~Delete	~Löschen	
Button Label	OK	OK	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	

Creating a Custom Address Block

In the case that none of the defaults fits users needs can create an own address block. Clicking 'New...' in the 'Select Address Block' dialog opens a dialog (Figure 21) from where users can create a address block that fits to their special needs.

Figure 22 User Interface for customizing or creating an address block

String list

Item	English	German	Comments
Title Bar	New Address Block	Neuer Adressblock	
Listbox Label	Address ~elements	Adress~elemente	
Tool Tip	Add to address	In Adresse übernehmen	
Tool Tip	Remove from address	Aus Adresse entfernen	
Grid Control Label	~Address block	~Adressblock	
Tool Tip	Move up	Nach oben	
Tool Tip	Move right	Nach rechts	
Tool Tip	Move down	Nach unten	
Tool Tip	Move left	Nach links	
	Drag address elements here	Adresselemente hierher ziehen	
Text Field	Preview	Vorschau	
Button Label	OK	OK	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	

Specifying the layout of an address block can be done by dragging address elements from the 'Address Elements' to an address block formatting area. The Address Elements list shall display the headings of the database table.

The address block addressing area shall provide invisible rows where the dropped element automatically snaps into. This assures that users can format the layout for their needs. Drawing 1 visualizes the interaction model.

The preview located below the address block formatting area shall display how the address block is formatted in real life. The preview shall render the content of the first address database record.

First Name First Name Family Name Family Name First Name 1. 2. Family Name Fields Address Block Formatting Area Snap Indicator Drawing 1 Work flow of dragging fields into the formatting area.

The Address Fields (MMP: Elements?) list shall list all column headers of the data source. For example if the data source provides a table containing three columns (A, B & C) the Address Fields list has show three Fields (A, B & C). Each element can be applied more than once to the address block formatting area.

Users can also move elements to the Elements list to the address block formatting area by using buttons. The address block formatting area provides the following keyboard access:

Keyboard Short Cut	Action
Arrow Up	Moves the selected item one row up
Arrow Down	Moves the selected item one row down
Arrow Left	Moves the selected item in front of an other item
Arrow Right	Moves the selected item behind an other item

Spaces between elements shall be set automatically. Clicking OK closes the dialog and adds the custom address block to the address block selectors. The custom address block shall be selected and appear at the first position of the list.

Address Block - The Preview

The preview (Figure 22) shall display the address block how it will appear in the document. For this preview the data of the address list shall be used. If one element can't be matched the preview shall display a warning. The warning shall be visualized by using the term '< not available >' . To emphasize the importance of the warning it shall be stated in red (R: 255, G:0, B:0).

Figure 23 The preview warns the user that two fields don't match with address list.

Users can also browse address blocks other recipients by clicking Forward or Back. These navigation buttons are located on the right hand side below the preview.

Address Block -Matching Fields

In case elements don't match, users can assign data source fields to address elements by hand. Therefore users have to click 'Match Fields ...'. The 'Match Fields...' button shall be located at the right hand side of the preview.

Clicking Assign opens a field matching dialog (Figure 23). Here users can match the not correctly assigned element with the database field. For example the element is named 'Nombre', but in the database table the name column has the heading 'Name'. For matching these, users have to apply the correct database column with the element. Matching fields is for users a very abstract thing, for providing assistance usability test have shown that having a good preview helps users a lot. Thus the dialog has two preview one directly beneath the matching table another below. The right one shows the first data record of the database matching the element. The lower one displays the first data record in formatted order. Both shall display elements which don't match in red (R:255, G:0, B:0)

. Figure 24 Matching fields

String list

Item	English	German	Comments
Title Bar	Match Fields	Felder zuordnen	
Text Field	Assign the fields from your data source to match the address elements.	Weisen Sie den Adresselementen Felder der Datenquelle zu.	
Caption	Address elements	Adresselement	
Caption	Match to field:	Zuordnung zu Feld:	
Caption	Preview	Vorschau	
Text Field	Address block preview	Adressblock Vorschau	
Button Label	OK	OK	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	

Item	English	German	Comments
list box entry	< none >	< leer >	used for no match in “Match to field:” column. This is different than the < not available > string used for previews

Step 3 (E-Mail) – Address List

In case the user selected E-Mail on step 2 the address Block step shall allow only to select the address list (Figure XXX)

Figure 25 Selecting an Address List for E-Mails.

Item	English	German	Comments
Heading	Select address list	Adressenliste auswählen	

Text Field	Select the address list containing the address data you want to use. This data is needed to create the salutation and to specify the e-mail recipients.	Wählen Sie, aus welcher Adressenliste die Adressdaten bezogen werden sollen. Die Daten der Adressenliste werden für die Anrede und die E-Mail-Adresse benötigt.	
Button Label	A~ddress List....	~Adressenliste...	

Step 4 – Greeting Line

The greeting line is also a part of a document which has to behave flexible (Figure 24). Users can choose between inserting or not. A greeting line can also be personalized or not. Unmarking the 'Insert personalized greeting line' option shall disable all features needed for personalizing a greeting line. These are Male, Female, New.., Column title and Field value. The general greeting line drop down combo box shall always be active. This is because the greeting line specified there is used as fallback if a recipient name is missing.

For specifying where the gender information is stored in the database (address list), users have to identify the column which stores the gender information. When users use an address list, created by using the New Address List dialog, the gender information shall be match automatically. In this case users do not have to change any setting. A drop down list box allows users to specify the column filled with gender information. Next users can specify the entry which identifies female recipients. In the case users have already specified the gender information in the Custom Address Block dialog, these setting shall incur to the gender settings of this dialog.

Figure 26 Setting up a greeting line

String list

Item	English	German	Comments
Heading	Create the salutation	Briefanrede erstellen	
Check Box	This document should contain a salutation	Eine Briefanrede in das Dokument einfügen	
Check Box	Insert personalized salutation	Personalisierte Briefanrede einfügen	
Drop Down List Box Label	Female	Weiblich	
Drop Down List Box Label	Male	Männlich	
Button Label Female	New...	Neu....	
Button Label Male	New...	Neu....	
Text Field	Address list field indicating a female recipient	Adresslistenwert für einen weiblichen Empfänger	
Combo Box Label	Field name	Spaltentitel	EM-OS/CJ: Feld oder Spalte hier? cf. p56##
Combo Box Label	Field value	Feldinhalt	
Combo Box Label	General salutation	Allgemeine Briefanrede	
Text Field	Preview	Vorschau	
Text Field	< not available >	< nicht verfügbar >	
Button Label	~Match fields...	~Felder wählen...	
Text Field	Document:	Dokument:	
Tool Tip	Preview Previous Salutation	Vorige Briefanrede ansehen	
Tool Tip	Preview Next Salutation	Nächste Briefanrede ansehen	

Step 4 - Personalized Greeting Line

For displaying gender-specific information in the greeting line users can specify for female recipients a different greeting line as for male recipients.

OpenOffice.org provides the following default greeting lines:

String list for female recipients:

Item	English	German	Comments
Drop Down List Box Content	Dear Ms. Citizen,	Sehr geehrte Frau Mustermann,	
	Ms. Citizen,	Liebe Frau Mustermann,	
	Dear Mary,	Hallo Frau Mustermann,	##MMP?? mix of first name and last name between German and English
	Hello Mary,	Hallo Maria,	
	(none)	(keine)	

String list for male recipients:

Item	English	German	Comments
Drop Down List Box Content	Dear Mr. Citizen,	Sehr geehrter Herr Mustermann,	
	Mr. Citizen,	Lieber Herr Mustermann,	
	Dear John,	Hallo Herr Mustermann,	##MMP?? mix of first name and last name between German and English
	Hello John,	Hallo Max,	
	(none)	(keine)	

The default greeting lines are listed in a drop down list box.

When users need additional greeting lines they have to click 'New...'. This opens a dialog for creating custom greeting lines. The UI provides two 'New ...' buttons. One for creating female recipients, the other for male. Depending on the selected 'New ...' button the dialog displays the information that a greeting line for female or male recipients will be created.

The specification describes the dialog for female recipients.

Figure 27 Creating a custom greeting line

String list

Item	English	German	Comments
Title Bar	Custom Salutation (Female Recipients)	Eigene Briefanrede (weibliche Empfängerinen)	
Title Bar	Custom Salutation (Male Recipients)	Eigene Briefanrede (männliche Empfänger)	
	Salutation e~lements	Briefanrede-Elemente	
	Title	Anrede	Comes from OpenOffice.org
	Punctuation mark	Satzzeichen	Comes from OpenOffice.org
	Text	Text	Comes from OpenOffice.org
Tool Tip	Add to salutation	In Briefanrede übernehmen	
Tool Tip	Remove from salutation	Aus Briefanrede entfernen	
Grid Control Label	1. ~Drag salutation elements into the box below	1. ~Ziehen Sie Briefanrede-Elemente in den Anredebereich	
Tool Tip	Move up	Nach oben	
Tool Tip	Move right	Nach rechts	
Tool Tip	Move down	Nach unten	
Tool Tip	Move left	Nach links	
	Drag salutation elements here	Briefanrede-Elemente hierher ziehen	
	2. Customi~ze salutation element	2. Briefanrede-Element an~passen	
Text Field	Preview	Vorschau	
Button Label	OK	OK	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	

The formatting of a greeting line behaves like the address block formatting feature (Chapter: 6.3.6 Creating a Custom Address Block). One big difference, compared to the Customize Address Block dialog is, that users can also drag also predefined greeting line elements to the formatting field. These special fields are 'Salutation' and 'Punctuation Mark' (Note: This list may has to be extended). When such element has been dragged into the formatting are and´n is selected the 'Customize element' combo box becomes active. The tables below list the contexts and their content:

String list for Salutations: Female

Item	English	German	Comments
Combo Box Content	Dear Ms.	Sehr geehrte Frau	NOTE: THIS UI ELEMENT SHALL BE A COMBO BOX
	Ms.	Verehrte Frau	
	Hello, Ms.	Guten Tag Frau	
	Dear	Liebe	
	Hello	Hallo	
	(none)	(keine)	

String list for Salutations: Male

Item	English	German	Comments
Combo Box Content	Dear Mr.	Sehr geehrter Herr	NOTE: THIS UI ELEMENT SHALL BE A COMBO BOX
	Mr.	Verehrter Herr	
	Hello, Mr.	Guten Tag Herr	
	Dear	Lieber	
	Hello	Hallo	
	(none)	(keine)	

String list for Punctuation Mark

Item	English	German	Comments
Combo Box Content	,	,	
	:	:	
	!	!	
	(none)	(kein)	

The combo box shall be deactivated when an element is selected which isn't customizable. The preview shall display the layout of the greeting line with the first database record

. Figure 28 Shows an example how a customized greeting line could look like.

Step 4 - Neutral Greetings Lines

The neutral greeting line option shall be used if the documents shall not be personalized. The combo box is filled with the following defaults:

String list for Neutral (General) Greetings Lines

Item	English	German	Comments
Combo Box Content	To whom it may concern,	Sehr geehrte Damen und Herren,	NOTE: THIS UI ELEMENT SHALL BE A COMBO BOX
	Dear Friends,	Liebe Freunde,	
	Dear Sir or Madam,	Liebe Vereinsmitglieder,	
	Hello,	Hallo,	

Step 4 – The Preview

Like the Address Block the Greeting Line Step shall provide also a preview. This preview shall display the greeting line by using the first database record. Not assigned fields shall be displayed by a red < not assigned > (R:255, G:0, B:0).

Not assigned merge fields can be assigned by clicking 'Match Fields...'. 'Match Fields...' opens the Assign Greeting Line Elements dialog.

Figure 29 Assign Fields Dialog for Greeting Lines

String list

Item	English	German	Comments
Title Bar	Match Fields	Felder zuordnen	
Text Field	Assign the fields from your data source to match the salutation elements.	Weisen Sie den Briefanredeelementen Felder der Datenquelle zu.	##MMP: Are these database fields as in Fig. 24?
Caption	Salutation elements	Briefanredeelemente	
Caption	Match to:	Zuordnung zu Feld:	
Caption	Preview	Vorschau	
Text Field	Salutation preview	Briefanrede Vorschau	
Button Label	OK	OK	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	

Item	English	German	Comments
list box entry	< none >	< leer >	used for no match in “Match to field:” column. This is different than the < not available > string used for previews

Step 5 – Layout

Now its time to place the address block and the greeting line in the document. Therefore users can specify the position of the address block and the greeting line. By default the address block shall be inserted as the standard position of the country from where the letter will be send. OpenOffice.org shall use the locale settings for identifying where to place the address block. For Example a German Office installed on a German system and a German locale shall place the address block at position regulated by DIN.

Users who are unsatisfied with the default of the address block position shall move the address block by using numeric fields.

Note: The address block shall be inserted bound to the page as frame.

For simplification an option called 'Align to Text body' shall be introduced. As long as this option is marked , moving the address block horizontally, shall be disabled. This assures that the address block and the text body align. When users moved the address block to any other position than default and than mark again the 'Align to text body' option the address block and the displayed value shall jump back to default.

The greeting line shall inserted as paragraph before the “main” paragraph of the document.

Known about the situation that a wizard can not fit every users needs regarding position of the address block and the greeting line users shall have the possibility to move those.

By default the life preview of the dialog shall show the entire page. User shall have the possibility to zoom into the preview. Therefor the following zoom levels shall be available.

100%

75%

50%

Entire Page (entire page shall be displayed as string in the drop down list, but as percent number after selecting)

Figure 28 shows a mockup of the Layout wizard page.

Figure 30 Layout step of the wizard

String list

Item	English	German	Comments
Heading	Adjust layout of address block and salutation	Layout des Adressblocks und der Briefanrede anpassen	
Text Field	Address block position	Adressblock-Position	
Check Box Label	Align to text body	Am Text ausrichten	
Spinfield Label	From ~left	Von links	
Spinfield Label	~From top	Von Oben	
Tool Tip	Salutation position	Briefanrede-Position	
Tool Tip	Move	Nach	
Tool Tip	Move	Nach	
Text Field	~Up	Oben	
Text Field	~Down	Unten	
Combo Box Label	~Zoom	Ansicht	
DD Content	100%	100%	
DD Content	75%	75%	
DD Content	50%	50%	
DD Content (Default)	Entire page	Ganze Seite	

Step 6 – Prepare Merge

On step 6 of the wizard, users can prepare the merge (Figure 29). They can navigate thru the merge documents by clicking navigation buttons. Users can also exclude records from being merged in the next step. Clicking for the next button, in the navigation bar, shows a preview of the next merged document in the main document window and its record number on the wizard page.

Note: At this time the merge is not final, this mean changing the document shall effect all documents.

A change which has effect on all documents shall be done by clicking an 'Edit Document' Button. Clicking this button hides the wizard and displays a toolbar (Figure 30).This Toolbar shall appear in floating state located at the upper left corner of the document (Drawing 2). It is very important that the closer of the floating toolbar is deactivated. When the user has done her changes she has to click the 'Back to Mail Merge Wizard' toolbar button. This closes the toolbar and the Mail merge wizard appears again, displaying step 6. When users move forward to step 7 the merge shall be performed.

Note: The starting document shall not be dropped. Because this is needed for saving purposes in dialog specified in chapter:6.9.1”Step 8 - Save Starting Document” .

Figure 31 Prepare Mail Merge.

String list

Item	English	German	Comments
Heading	Preview and edit the document	Kontrollieren Sie das Dokument und ändern sie es falls notwendig	
Text Field	The preview of a merged document is visible now. To see the preview of another document click one of the arrows.	Sie sehen jetzt eine Vorschau auf ein Serienbriefdokument. Um eine Vorschau auf weitere Dokumente zu sehen, klicken Sie auf die Pfeile.	
Text Edit Label	~Recipient	~Empfänger	
Tool Tip	First	Erster	
Tool Tip	Previous	Vorheriger	
Tool Tip	Next	Nächster	
Tool Tip	Last	Letzter	
Check Box Label	Exclude this recipient	Diesen Empfänger ausschließen	
Text Field	Edit document	Dokument bearbeiten	
Text Field	Write or edit your document now if you have not already done so. The changes will effect all merged documents.	Sie können jetzt das Dokument erstellen oder bearbeiten. Die Veränderungen wirken sich auf alle Serienbriefdokumente aus.	
Text Field	Clicking 'Edit Document...' will temporarily reduce the wizard to a small window so you can edit the mail merge document. After editing the document, return to the wizard by clicking 'Return to the Mail Merge Wizard' in the small window.	Ein Klick auf die Schaltfläche 'Dokument Bearbeiten...' schließt vorübergehend den Assistenten. Durch Klicken der 'Zurück zum Serienbrief-Assistenten' Schaltfläche – sichtbar in einem kleinem Fenster – gelangen Sie zurück zum Assistenten.	
Button Label	~Edit Document...	Dokument ~bearbeiten...	

Figure 32 Toolbar which appears when users edit a document

String list

Item	English	German	Comments
	Mail Merge Wizard	Serienbrief-Assistent	
	Return to Mail Merge Wizard	Zurück zum Serienbrief-Assistenten	

Max Muster Example Street 1 Dear Mr. Muster, Bla, Bla, Bla edit Max Muster Example Street 1 Dear Mr. Muster, Bla, Bla, Bla Max Muster Example Street 1 Dear Mr. Muster, Bla, Bla, Blub Max Muster Example Street 1 Dear Mr. Muster, Bla, Bla, Bla edit Drawing 2 Workflow of editing documents

Step 7 – Personalize

Due to performance issues a progress indicator shall appear before the Personalize dialog appears. The progress indicator informs users how many personalized documents have already been created. A counter gives users feedback about the progress. A wait cursor shall be also displayed. The figure below shows how the dialog shall look like:

String list

Item	English	German	Comments
Heading	Mail Merge	Serienbrief	
Text Field	Status:	Status:	
Text Field	Progress:	Fortschritt	
Text Field	Creating documents...	Die Dokumente werden erstellt...	
Text Field	%X of %Y	%X von %Y	the placeholders will be replaced by numbers at runtime which denote for example, 1 of 100 documents have been created
Button	Cancel	Abbrechen	

As stated in the chapter before, shall the merge be performed during when moving from step 6 to 7. Like on step 6 users can edit the merged documents. Due to the fact that the merge has been performed changes have no effect on other documents. Users change documents by clicking 'Edit individual Documents...'. Like before the wizard shall be closed and the toolbar (Figure 31) appears. They can exit back to the wizard by clicking 'Back to Mail Merge Wizard'.

Step 7 of the wizard allows also to perform a search thru the merged document.

Figure 33 Complete the merge

String list

Item	English	German	Comments
Heading	Personalize the mail merge documents	Personalisieren Sie die Serienbrief-Dokumente	
Text Field	You can personalize particular documents. Clicking 'Edit Individual Document...' will temporarily reduce the wizard to a small window so you can edit your document. After editing the document, return to the wizard by clicking 'Return to the Mail Merge Wizard' in the small window.	Sie können jetzt die Dokumente personalisieren. Ein Klick auf die Schaltfläche 'Individuelles Dokument bearbeiten...' schließt vorübergehend den Assistenten. Durch Klicken der 'Zurück zum Serienbrief-Assistenten' Schaltfläche – sichtbar in einem kleinem Fenster – gelangen Sie zurück zum Assistenten.	
Button Label	~Edit Individual Document...	Individuelles Dokument ~bearbeiten...	
Text Field	Find	Suche	
Text Edit Label	~Search for:	Suchen ~nach:	
Check Box	Whole wor~ds only	Nur ganzes ~Wort suchen	
Check Box	Back~wards	Nach ~oben	
Check Box	Ma~tch case	~Groß-/Kleinschreibung	
Button Label	~Find...	~Suchen...	

Step 8 - Save, Print & Send

At this step users can select how to proceed with the generated merge. Users can choose between four options:

Save starting document

Save merged document

Print merged document

Send merged document as E-mail

The chapter below describe each option in detail.

Step 8 - Save Starting Document

This option (Figure 31) allows users to save the initially created document containing text & merge fields. Clicking 'Save Starting Document' opens a file picker point to “my documents”. The most current OpenOffice Writer Format shall be preselected & the file name text edit shall be filled with the document name. When saved the starting document shall contain fields & database connection settings.

Note: When one of the four options has been performed successfully the 'Finish' button shall be active.

Figure 34 Save Starting Document option

String list

Item	English	German	Comments
Heading	Save, print or send the document	Speichern, drucken oder versenden Sie die Serienbriefe	
Text Field	Select one of the options below:	Wählen Sie eine der Optionen:	
Option Button	Save ~starting document	Ausgangsdokument speichern	
Option Button	Save ~merged document	S~erienbriefdokument speichern	
Option Button	~Print merged document	Serienbriefdokument ~drucken	
Option Button	Send merged document as ~E-mail	Serienbriefdokument als E-Mail ~versenden	
Text Field	Save starting document	Ausgangsdokument speichern	
Button Label	Save Starting ~Document...	Ausgangsdokument ~speichern...	

Step 8 - Save Merged Document

The Save Merged Document option (Figure 33) saves the merged document. Users can choose between the following options:

Save as single document:
This saves the whole merged document as one document.

Save as individual documents:
Saves each record as individual document. The document name shall be extended by the number of records. For example 10 records shall be saved as: %Dokumentname_01.sxw, %Dokumentname_02.sxw; %Dokumentname_03.sxw etc...
In case this naming scheme already exists. We shall display the following warning (Figure XXX):

Figure 35 Warning which shall be displayed when files already exist.

String list

Item	English	German	Comments
Title Bar	%PRODUCTNAME %PRODUCTVERSION	%PRODUCTNAME %PRODUCTVERSION	

Item	English	German	Comments
Label	A document with the name '%CURRENTDOCUMENTNAME' already exists. Please save this document under a different name.	Ein Dokument mit dem Namen '%CURRENTDOCUMENTNAME' existiert bereits. Bitte wählen Sie einenanderen Namen.	
Label	New document name:	Neuer Dokumentname	

From To:
Saves range of records defined in the text fields.

Figure 36 Save Merged Document

String list

Item	English	German	Comments
Text Field	Save merged document	Serienbriefdokument speichern	
Option Button	Save as single document	Als ~ein Dokument speichern	
Option Button	Save as individual documents	Als ein~zelne Dokumente speichern	
Text Edit Label	~From	~Von	
Text Edit Label	~To	~Bis	
Button Label	~Save Documents	~Dokumente speichern	

PJC: If you choose “From...To...” are they saved as a single document or as individual documents? Can the user choose?

Step 8 – Print Merged Document

The print merge d document option shall provide the following options. Users can select the printer, if an fax is installed the list shall also contain the fax. Beneath the printer selector it shall be possible to have access to the printer / fax properties.

Users shall select from the following printing options:

Print all documents
Prints all documents

From To
Prints range of records defined in the text fields.

Figure 37 Print Merged document settings

String list

Item	English	German	Comments
Text Field	Print merged document	Serienbriefdokument drucken	
DD List Box Label	Printer	~Drucker	
Button Label	Properties...	~Eigenschaften...	
Option Button	Print all documents	~Alle Dokumente drucken	
Text Edit Label	From	~Von	
Text Edit Label	To	~Bis	
Button Label	Print Documents	Dokumente ~Drucken	

Step 8 – Send merged document as E-mail

Before users can perform the Send document as E-Mail feature, OpenOffice.org shall check, if an valid E-mail configuration exist. Therefore, OpenOffice.org has to check if an appropriate SMTP server was configured. Only when a valid configuration exists, the E-Mail settings shall be activated. Otherwise, an alert shall appear telling the user that she has to setup the E-Mail Configuration before sending is possible. This is specified in detail in chapter 6.10.1: Configuration of E-Mail settings .

Note: The Send merged document as E-mail shall be default when the user has been selected 'E-Mail' in Chapter: 6.2 Step 2 – Document Type

The send document as E-mail option (Figure 35) provides the following settings:

To
User can define define the database field that contains the email address value. Therefore a drop down list box shall give the users access to the address database headings. Recipients for carbon copies or blind copies can be specified by clicking 'Copy to...'. This shall open a dialog where users can define recipients for carbon- and or blind copies (Figure 35). The delimiter shall be Space.

Figure 38 Copy to dialog for adding blind copy or carbon copy recipients.

String list

Item	English	German	Comments
Title Bar	Copy To	Kopie an	
Text Field	Send a copy of this mail to:	Ein Kopie dieser Nachricht soll gesendet werden an:	
Text Edit Label	~Cc	~Cc	
Text Edit Label	~Bcc	~Bcc	
Text Field	Note:	Hinweis:	
Text Field	Separate e-mail addresses with a semicolon (;).	E-Mail-Adressen mit Semikolon (;) trennen.	
Button Label	OK	OK	
Button Label	Cancel	Abbrechen	
Button Label	Help	Hilfe	

Subject
The subject line is a text edit field where users can specify the subject.

Send As
With the Send as features, users can specify the format of the Mail. Users shall choose between the options listed in the table below (Sending the Mail in HTML Format shall be default):

Mail Format	File Format Of The Attachment	Additional Settings
Plain Text	None: Document shall be exported as plain text and shall be used as the mail body	None
HTML (Default)	None: Document shall be exported as HTML and shall be used as the mail body	None
Attachment (SXW - OpenOffice.org Writer)	OpenOffice.org 2.0 Writer File Format	Yes -> 'Properties...'
Attachment (DOC - Microsoft Word Format)	Most current Microsoft Word format	Yes -> 'Properties...'
Attachment (PDF – Portable Document Format)	PDF -> Format preferences shall be set to “Print Optimized”	Yes -> 'Properties...'

Attachment Name

The Attachment Name text edit gets activated, if one of the following file formats has been selected as attachment:

- OpenOffice.org Writer

- Microsoft Word Format

- Portable Document Format

When activated the text edit shall display preselected the string 'Untitled.sxw'. Whereby the extension changes depending on the file format previously selected.

When users forget to add the extension when renaming the attachment name, OpenOffice.org adds this the extension automatically.

Figure 39 Send merged document as E-Mail

String list

Item	English	German	Comments
Text Field	Send merged document as E-mail	Serienbriefdokument als E-Mail versenden	
DD List Box Label	To	An	
Button Label	Copy To...	Kopie an...	
Text Edit Label	Subject	Betreff	
DD List Box Label	Send as	Senden als	
DD List Box Content	Plain Text	Nur Text	
DD List Box Content	HTML Message	HTML-Nachricht	
DD List Box Content	Open Office Text Document	Open Office Text Dokument	EM->CJ: Is it correct to use the new file format name here? I think so.
DD List Box Content	Adobe PDF Document	Adobe PDF-Dokument	
DD List Box Content	Microsoft Word Document	Microsoft Word Dokument	
Button Label	Properties...	Eigenschaften...	
Text Edit Label	Name of the attachment	Name des Anhangs	
Default Text Edit content	Untitled	Unbenannt	
Option Button	Send All Documents	Alle Dokumente versenden	
Text Edit Label	From	Von	
Text Edit Label	To	Bis	
Button Label	Send Documents	Dokumente versenden	

OpenOffice.org shall check before sending out documents, if a subject exits and – in case files are attached – the name of the attachment got changed.

If not OpenOffice.org shall display the following warnings before sending the documents. In both cases the default string preselected for easy overwriting.

Warning for no subject:

String list

Item	English	German	Comments
Title	%PRODUCTNAME	%PRODUCTNAME	
Question Text	You did not specify a subject for this message. If you would like to provide one, please type it now.	Sie haben kein Betreff für diese Nachricht angegeben. Wenn Sie einen angeben möchten, dann geben Sie ihn jetzt ein.	
Default Text edit content	No subject	Kein Betreff	
Button Label	OK	OK	
Button Label	Cancel	Abbrechen	

Warning for attachment name not changed:

String list

Item	English	German	Comments
Title	%PRODUCTNAME	%PRODUCTNAME	
Question Text	You did not specify a new name for the attachment. If you would like to provide one, please type it now.	Sie haben keinen neuen Namen für den Anhang angegeben. Wenn Sie einen angeben möchten, dann geben Sie ihn jetzt ein.	
Default Text edit content	Untitled	Unbennant	
Button Label	OK	OK	
Button Label	Cancel	Abbrechen	

E- Mail Settings - Send As – Properties Button

This button shall be active if one of the following file formats was selected:

OpenOffice.org Writer

Microsoft Word

Portable Document Format

Clicking the button, opens a dialog (Figure 37) from where users can specify the E-Mail body. This is needed if the document will be attached. Users can define here the e-mail body text and can specify if the recipients shall be greeted individual or neutral.

When users need additional greeting lines they have to click 'New...'. This opens a dialog for creating custom greeting lines. The UI provides two 'New...' buttons. One for creating female recipients, the other for male. Depending on the selected 'New...' button the dialog displays the information that a greeting line for female or male recipients will be created (6.4.1 Step 4 - Individual Greeting Line).

Users can also specify the greeting line fore recipients where the address information is missing.

Like the Address Block the Greeting Line shall provide a preview. This preview shall display the the greeting line by using the first database record. Not assigned fields shall be displayed by a red < not assigned > (R:255, G:0, B:0).

Not assigned merge fields can be assigned by clicking 'Match Fields...'. Match Fields...' opens the Assign Greeting Line Elements dialog (Chapter: 6.4.3 Step 4 – The Preview).

The 'Write your message here' field shall allow users to write the message. It shall always be active. Figure 40 Dialog for writing the e-mail body

String list

Item	English	German	Comments
Title Bar	E-mail Message	E-Mail-Nachricht	
Check Box	Insert personalized salutation	Personalisierte Briefanrede einfügen	
Drop Down List Box Label	Female	Weiblich	
Drop Down List Box Label	Male	Männlich	
Button Label Female	New...	Neu....	
Button Label Male	New...	Neu....	
Text Field	Address list field indicating female recipients	Adresslistenwert für einen weiblichen Empfänger	
Combo Box Label	Field name	Spaltentitel	Feld oder Spalte? Siehe selbe Frage an anderer Stelle. p33##
Combo Box Label	Field value	Feldinhalt	
Combo Box Label	General salutation	Allgemeine Briefanrede	
Text Field	~Write your message here	~Schreiben Sie Ihre Nachricht hier	
Button Label	OK	OK	
Button Label	Cancel	Abbrechen	
Button Label	Help	Hilfe	

Item	English	German	Comments
	This e-mail should contain a salutation	Eine Briefanrede in der E-mail-Nachricht einfügen	German?

Sending Out an E-Mail

Configuration of E-Mail settings

Before the user is able to send a mail merge via e-mail an appropriate SMTP server has to be configured. Figure 38 shows a mockup for entering the necessary SMTP server settings. The dialog can be accessed from Tools / Options / Text Document / Mail Merge. Or, when no E-Mail account has been created before, right after clicking the Send button in the Mail Merge Wizard. If this is the case - first an alert (displaying an information as icon) shall appear - informing the user that the E-Mails can't be send out.

The table below lists the strings which shall be used for the alert.

String list

Item	English	German	Comments
	In order to be able to send mail merge documents by e-mail, %PRODUCTNAME requires information about the e-mail account to be used. Do you want to enter e-mail account information now?	Damit Serienbriefe per E-Mail versendet werden können, benötigt %PRODUCTNAME Informationen über das E-Mail-Konto, von dem aus Sie E-Mails versenden möchten. Möchten Sie jetzt die Konto-Informationen eingeben?	
	Yes...	Ja...	
	No	Nein	
	Help	Hilfe	

The Mail Merge configuration step shall give the users the possibility to test his settings immediately (see “Test Account Settings...” button). The possibility of errors during an E-mail merge can so be minimized.

The Mail Merge configuration step shall only be displayed when the Java Mail services is installed.

Figure 41 Tools Option Mail Merge dialog

String list

Item	English	German	Comments
Tree Entry	Mail Merge E-mail	Serienbrief-E-Mail	
Text Field	User information	Benutzerinformationen	
Text Edit Label	~Your name	~Ihr Name	
Text Edit Label	~E-Mail address	~E-Mail-Adresse	
Check Box Label	Send replies to ~different e-mail address	Sende ~Antworten an andere Adresse	
Text Edit Label	~Reply address	Ant~wortadresse	
Text Field	Outgoing server (SMTP) Settings	Postausgangsserver (SMTP) Einstellungen	
Text Edit Label	~Server name	~Server-Name	
Text Edit Label	~Port	~Port	
DD List Box Label	~Use secure connection (SSL)	~Verschlüsselte Verbindung verwenden (SSL)	PJC: I suggest this should be a checkbox and the next two strings are unnecessary.
DD List Box Content	None	Keine	
DD List Box Content	SSL	SSL	
Check Box Label	Server requires au~thentication	Der Server erfordert Authen~tifizierung	
Text Edit Label	User~name	~Benutzername	
Text Edit Label	~Password	~Kennwort	
Button Label	Test S~ettings...	Einstellungen ~Testen...	

The user shall get feedback when she is testing her SMTP server settings. The basic information needed by the user is a success or failure message.

Figure 39 shows the a mockup of the Test Account Settings dialog.

Figure 42 Testing the created account

String list

Item	English	German	Comments
Title Bar	Test Account Settings	E-Mail-Kontoeinstellungen überprüfen	
Text Field	%PRODUCTNAME is testing the e-mail account settings...	% PRODUCTNAME überprüft die E-Mail-Kontoeinstellungen...	
Text Label	Task	Aktion	
Text	Establish network connection	Netzwerkverbindung herstellen	
Text	Find outgoing mail server (SMTP)	Postausgangsserver (SMTP) suchen	
Text	Successful	Erfolgreich	
Text	Failed	Fehlgeschlagen	
Text Label	Errors	Fehler	
	%PRODUCTNAME could not connect to the outgoing mail server. Check your system's network configuration and the settings in % PRODUCTNAME. Check the server name, the port and the secure connection settings.	%PRODUCTNAME konnte keine Verbindung zum Postausgangsserver herstellen. Bitte überprüfen Sie die Netzwerkeinstellungen des Systems und Einstellungen in %PRODUCTNAME. Überprüfen Sie den Servernamen, den Port und die Sicherheitseinstellungen.	
Button Label	~Stop	~Stopp	
Button Label	~Cancel	~Abbrechen	
Button Label	~Help	~Hilfe	
Item	English	German	Comments
Column Heading	Status	Status	

Progress of Sending E-Mails

Clicking 'Send Documents' on Step 7 prepares the sending of documents. For providing feedback of the current sending status a dialog showing a progress bar shall appear. Actual sending an e-mail merge must happen asynchronously so that the user is able to proceed to work with OpenOffice.org. And, it shall be possible to exit the wizard during sending mails. Quitting OpenOffice.org during the progress of sending out mails shall call a warning, giving users the hint that this will also quit sending mails.

String list

Item	English	German	Comments
Title Bar	%PRODUCTNAME %PRODUCTVERSION	%PRODUCTNAME %PRODUCTVERSION	
Text	There are still e-mail messages in your %PRODUCTNAME Outbox. Would you like to exit anyway?	In Ihrem %PRODUCTNAME Postausgang sind noch Nachrichten zu versenden. Möchten Sie das Programm trotzdem beenden?	Please check German!
Button Label	Yes	Ja	
Button Label	No	Nein	Default

Note: The progress dialog (Figure 40) shall appear on top of the wizard and shall be non-modal.

This dialog serves two purposes:

Display status information about the actual E-mail merge

Allow the user to control the E-mail merge process (stop, continue)

The Details View shall handle the following type of status conditions:

Completed (Everything is OK)

Failed (Invalid address)

Failed (No address)

Figure 43 Progress of delivering mails

String list

Item	English	German	Comments
Title Bar	Sending E-mail Messages	E-Mails versenden	
Text Label	Connection status	Verbindungsstatus	
Text Label	Connection to outgoing mail server established	Verbindung zum Postausgangsserver wird aufgebaut	
Text Label	Sending e-mails...	E-Mails werden versendet...	
Text Label	Transfer status	Übertragrungsstatus	
Text Label	N of X e-mails sent	N von X E-Mails wurden gesendet	
Text Label	E-mails not sent:	Nicht versendete E-Mails:	
	More >>	Mehr >>	
	<< Less	<< Weniger	
Text Label	Task	Aktion	
Text	Sending to:	Senden an:	
Text	Successfully sent	Erfolgreich versendet	
Text	Sending failed (invalid address)	Fehlgeschlagen (ungültige Adresse)	
Text	Sending failed (missing address)	Fehlgeschlagen (keine Adresse)	
Text Label	Status	Status	
Button Label	~Stop	~Stopp	
Button Label	~Continue	~Fortsetzen	
Button Label	C~lose	S~chließen	

Handling of Partially Successful E-Mail Sending Jobs

After the user has started the shipment of an merge two results are to be expected:

All e-mails were be sent successfully

Not all e-mails could be sent successfully (Possible causes are: the user stopped sending the merge in the middle of it, failures during sending occurred due to network problems, etc.)

Whatever the cause for result #2 is the user might want send the undelivered e-mail messages later after eliminating the respective reasons.

When an e-mail sending job is in progress and the user clicks the “Stop” button the transfer status shall change to 'Sending paused'. This shall be displayed right after the Transfer Status label where the numbers of mails sent is displayed. When an error occurred, for example cause by a network error an alert dialog shall appear informing the user that the progress of sending e-mails has been interrupted. The dialog shall also provide a details view. The details view shall be filled with raw warnings provided by the used email service.

Clicking OK closes the application modal dialog users can continue sending mails bay clicking the Continue button shown in the status dialog (Figure 41).

Figure 44 Warning which appears if users interrupt sending mails

String list

Item	English	German	Comments
	E-mails Could Not Be Sent	E-Mails konnten nicht versendet werden	
	The following error occurred:	Ein Fehler ist aufgetreten:	
	The network connection was lost.	Die Netzwerkverbindung wurde unterbrochen.	
	Please contact your network administrator.	Setzen Sie sich bitte mit Ihrem Netzwerkadministrator in Verbindung.	
	Detailed information	Detaillierte Informationen	
	OK	OK	

Future Tasks

OpenOffice.org 2.0 also provides a Mail Merge toolbar from where the more experienced user can perform mail merges.

Handling of partially successful e-mail Merge Jobs in the Future

After the user has started the shipment of an merge two results are to be expected:

All e-mails were be sent successfully

Not all e-mails could be sent successfully (Possible causes are: the user stopped sending the merge in the middle of it, failures during sending occurred due to network problems, etc.)

Whatever to cause for result #2 is the user might want send the undelivered e-mail messages later after eliminating the respective reasons.

When an e-mail sending job is in progress and the user clicks the “Stop” button a dialog (Figure 40) shall appear informing the user that the progress has been interrupted manually and asking the user how to continue. The dialog shall appear on top of the Sending E-Mail status dialog.

The dialog shall give users the choice of the three options listed below:

Continue sending messages (default)

Closes the alert and continuos sending e-mails

Send messages later

Closes the alert and shows a dialog from where users can save the sending job.

Abort sending messages

Aborts the sending process, deletes all temporary created

The alert shall appear automatically when an error occurred (e.g. Network connection problems). In case of an error the alert shall provide a slightly modified alert text (listed also in the string table below).

Figure 45 Warning which appears if users interrupt sending mails

If the user decides to send the not delivered messages later she must save the job. Therefore she has to give the job a name. The job shall be saved in a directory located in the user directory of the OpenOffice.org installation (/user/store/merge_sent/).

Figure 46 Dialog for saving the merge

In case the selected job name already exist an error dialog will be displayed.

In the status bar of the OpenOffice.org Writer there will be a symbol signalizing (Figure 42) that there a pending e-mail merge jobs. Clicking on this symbol shall display a dialog (Figure 43) which shows all pending e-mail merge jobs with their names and description. With this dialog the user can restart e-mail merge jobs or discard them. Like a download manager the manager shall track all out going mail jobs, and shall list them in a table format.

Completed jobs shall become the status 'Completed' (Job can be deleted from the list but not be send).

Interrupted jobs shall display the number of successful sent mail and the total number. (Job can be deleted or send)

Failed jobs shall get the status failed (Job can be deleted but not send)

Users can also clear the list by clicking 'Clear List'. This option shall clear only failed or completed jobs

The E-Mail Jobs Manager dialog shall be accessed from the status bar and also from the Tools/ Mail Merge / Menu (Compare with Table 1)

Figure 47 OpenOffice Writer showing that there are pending e-mail jobs.#

Figure 48 List of Mails sent

Notes & Issues

We need a policy for the inline help components (you call that "notes", it's the help text in the dialog). Ideally, these should come from TechPubs.

Japanese greetings for mail merge

Hello Naoyuki,

>

> I need a collective opinion from Japan SS team whether the following

> feature is a must for SO/SS8.

>

> FEATURE: Japanese greetings for mail merge

>

> At least MSWord XP and 2003 offer this feature if you install language

> pack. This feature seems to be present only for Japanese. Steps to see

> these greetings are: Tools > Letters and Mailings > Mail Merge > Step 4

> > Greeting Wizard.

>

> Please, ask Christian in the SO User Experience group (copied in this

> email) if you have questions. Otherwise, could you let him know in the

> next two weeks whether this feature needs to go into SO8?

>

>

> Thanks,

> Young

Hi Young,

I asked for marketing people about this.

They said of course this kind of feature is very nice to have because

MS Word and Ichitaro already have it.

Regards,

Naoyuki

How to access ODBC data sources ( UFI: How do I select a data source that is registered to SO by ODBC, for example? There is no file I can choose then, or is there?)

PLAIN TEXT UFI: do you have information how the text file contents must be constructed? For example, one text line per record? The first line contains the field names? Which format? -> CJ: We drop this format.

FPE: User D wants to send a fax to 12 of his friends ... CJ: This functionality is not stated as an requirement for Q.

FPE: Will the unsuccessful mails be filtered out? How does the user resend failed mails?

FPE: (Step #8 Send as E-Mail) Now where's the preview here? How would I know if the HTML/plain text/PDF version looks good enough for me? Do I have to send blindly?

References

General Wizard Specification: http://specs.openoffice.org/installation/wizards/Wizards_NewConcept.sxw

OpenOffice.org Wizard Conzept; http://specs.openoffice.org/installation/wizards/Wizards_NewConcept.sxw

Performing a Mail Merge in Word 2002 and 2003; http://www.bcentral.co.uk/technology/office/tips/word/mailmergeword2002.asp

General Wizard Specification: http://specs.openoffice.org/installation/wizards/Wizards_NewConcept.sxw

For the most current Filename and extensions please refer to:
http://specs.openoffice.org/appwide/fileIO/FileFormatNames.sxw

OpenOffice.org Base is the working name for the OpenOffice.org Database module introduced with OpenOffice.org 2.0

Mail Merge Wizard

2

http://specs.openoffice.org/writer/mail_merge/mailmerge_specification.sxw

Tino Rachui

2004-02-20T09:29:08

Matthias Müller-Prove