How do I setup mail merge?
From Apache OpenOffice Wiki
< Documentation | FAQ | Writer | Printing
How do I setup mail merge?
There are three main steps: creating the data source, creating the mail merge document, and printing. It's simple once you get the hang of it.
- 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 {{#if: File |File}}{{#if: Wizards | → Wizards}}{{#if: Address Data Source | → Address Data Source}}{{#if: | → {{{4}}}}}{{#if: | → {{{5}}}}}{{#if: | → {{{6}}}}}{{#if: | → {{{7}}}}}{{#if: | → {{{8}}}}}{{#if: | → {{{9}}}}}{{#if: | → {{{10}}}}} from the menu bar and follow the wizard's pages. You must have Base installed for this wizard to be available.
- Choose {{#if: File |File}}{{#if: Wizards | → Wizards}}{{#if: Letter | → Letter}}{{#if: | → {{{4}}}}}{{#if: | → {{{5}}}}}{{#if: | → {{{6}}}}}{{#if: | → {{{7}}}}}{{#if: | → {{{8}}}}}{{#if: | → {{{9}}}}}{{#if: | → {{{10}}}}} 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 {{#if: File |File}}{{#if: New | → New}}{{#if: Text Document | → Text Document}}{{#if: | → {{{4}}}}}{{#if: | → {{{5}}}}}{{#if: | → {{{6}}}}}{{#if: | → {{{7}}}}}{{#if: | → {{{8}}}}}{{#if: | → {{{9}}}}}{{#if: | → {{{10}}}}}, create a new Writer document, select {{#if: View |View}}{{#if: Data Sources | → Data Sources}}{{#if: | → {{{3}}}}}{{#if: | → {{{4}}}}}{{#if: | → {{{5}}}}}{{#if: | → {{{6}}}}}{{#if: | → {{{7}}}}}{{#if: | → {{{8}}}}}{{#if: | → {{{9}}}}}{{#if: | → {{{10}}}}} (or press F4 ) and drag the fields you want onto the document.)
- To print, choose {{#if: File |File}}{{#if: Print | → Print}}{{#if: | → {{{3}}}}}{{#if: | → {{{4}}}}}{{#if: | → {{{5}}}}}{{#if: | → {{{6}}}}}{{#if: | → {{{7}}}}}{{#if: | → {{{8}}}}}{{#if: | → {{{9}}}}}{{#if: | → {{{10}}}}}. 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.