Pt.openoffice.org/FAQ/Writer/ImprimirMailMerge

Porque é que o meu documento fica marcado como alterado depois de o imprimir?

Esta situação deve-se ao facto de alguma informação relativa à impressora é guardada no documento. É possível desactivar esta opção no menu Ferramentas->Opções->OpenOffice.org->Geral. Desactive a opção A impressão define o estado 'documento modificado'

Como posso imprimir um envelope no OpenOffice.org?

Para imprimir um envelope siga os seguintes passos::

1. Menu Inserir->Envelope
2. No separador Envelope preencha os dados relativos ao destinatário e remetente.
3. No separador Formato insira o tamanho do envelopes (e dos campos de remetente e destinatário)
4. No separador Impressora indique a orientação do envelope
5. No mesmo separador pressione o botão Configurar e de seguida pressione no botão Propriedades
6. Na janela das propriedades da impressora, seleccione o tamanho do envelope e a orientação
7. Click OK.
8. Click OK.
9. Pressione o botão Novo Doc. caso queira apenas o envelope ou Inserir caso deseje adicionar o envelope ao documento em utilização
10. Na nova janela verifique que tudo está correcto e imprima normalmente

Como posso remover um envelope do meu documento?

Remover um envelope de um documento pode ser uma tarefa árdua e está a ser desenvolvido um esforço para facilitar esta tarefa no futuro. Aqui fica os passos para remover o envelope manualmente:

1. Posicione o o cursor no início do envelope
2. Caso a janela de Estilos e formatação não se encontrar activo pressione a tecla F11
3. Seleccione o ícone de Estilo de página (quarto ícone a contar da esquerda)
4. Duplo clique na opção Predefinição.
5. Remover os restantes elementos.

Como configuro o mail merge?

Existem três passos: Criar a fonte de dados, Criar o documento, Imprimir.

1. First you need to "register" the data source (spreadsheet, address book, other file, or database) that the mail merge will use. To do this, choose File > Wizards > Address Data Source from the menu bar and follow the wizard's pages.
2. Choose File > Wizards > Letter and work through the wizard. It will let you pick the data source you want to use. Then just insert the fields you want. (Another approach is to choose File > New > Text Document, create a new Writer document, select View > Data Sources (or press F4) and drag the fields you want onto the document.)
3. To print, choose File> Print. Pick the range of data source records to use, then click OK and you get the regular print options window. If you're printing on envelopes MAKE SURE your printer is set up for the same size envelope in the paper tray as you're set up to print to.

How do I create labels in OpenOffice.org?

Select: File -> New -> Labels. In the dialog that appears, you will be able to enter the initial text for the label(s) and select the label type (Avery, etc.) desired. Click on "New Document" to open the document using the settings you selected.

For a detailed description of the process, and problem-solving tips, see Chapter 11, Using Mail Merge in the Writer Guide.

How do I hide a blank address line (or a NULL field value) when doing a mail merge?

Mail addresses for letters or envelopes have a different number of lines. There are two separate things you have to do.

Firstly create the form letter with all the fields that might appear - test that it works and that is shows extra blank lines and spaces where some fields are null.

Then you need to do the work required to make the extra spaces/paragraph marks disappear.

Consider a layout like this:

<First_Name>[space]<Surname>[Return] <House_Name>[Return] <House_No>[space]<Number_Modifier>[space]<Street>

Some houses don't have names, and some addresses are of the form 13 b High Street and some are 121 Acacia Avenue.

You do this by running a test on the values.

First ensure that Hidden Fields are shown on screen, otherwise you will get in a terminal head spin. This is the menu option: View->Hidden Paragraphs

To make the line disappear, put the cursor between and [Return] and choose the menu option: Insert->Fields->Other (or [CNTL][F2] if your desktop manager doesn't intercept it).

The third tab is Functions - choose that. The option Hidden Paragraph is the one we want.

On the right hand side there are three options for invoking a hidden paragraph. We just want the Condition.

Enter 'not(House_Name)' - without the quotes. This tests the field, and if it is empty makes the para disappear. You could also use the condition 'House_Name EQ ""' - this format should be used when the database returns a NULL, with '""' replaced by 'NULL'.

To make the extra space after disappear, select the space. Chose Insert->Fields->Other and the Functions Tab. This time you select 'Hidden Text' on the left and use a similar conditional.