Using the Mail Merge Wizard

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 15:53, 13 February 2008 (edit)
Lorinda (Talk | contribs)
(2. DIY Form Letters - correct Neo version number)
← Previous diff
Revision as of 01:29, 18 June 2008 (edit) (undo)
Lorinda (Talk | contribs)
(add External Links section and a link)
Next diff →
Line 1: Line 1:
NeoOffice includes two different ways of printing form letters. NeoOffice includes two different ways of printing form letters.
-===1. The Mail Merge Wizard===+===The Mail Merge Wizard===
This wizard holds your hand to produce a form letter with an address block at the top and an optional salutation tailored to the gender of the recipient. You can use it with any database that is registered in NeoOffice and it will work with both tables and queries. However there is a bug that causes it not to recognise the database if you are trying to use the results of a query. This wizard holds your hand to produce a form letter with an address block at the top and an optional salutation tailored to the gender of the recipient. You can use it with any database that is registered in NeoOffice and it will work with both tables and queries. However there is a bug that causes it not to recognise the database if you are trying to use the results of a query.
Line 15: Line 15:
* In the Mail Merge Wizard steps 4 and on should now be black and under the "Select Different Address List…" button should be the name of the database you are wanting to use. * In the Mail Merge Wizard steps 4 and on should now be black and under the "Select Different Address List…" button should be the name of the database you are wanting to use.
-===2. DIY Form Letters===+===DIY Form Letters===
If you don't like Wizards (and quite frankly the Mail Merge Wizard is not a great example) then you can build your own Form Letters. If you don't like Wizards (and quite frankly the Mail Merge Wizard is not a great example) then you can build your own Form Letters.
Line 22: Line 22:
This is much simpler than using the Mail Merge Wizard, however if your address data contains blank fields there is no way of hiding them (something that the Wizard does well). This is much simpler than using the Mail Merge Wizard, however if your address data contains blank fields there is no way of hiding them (something that the Wizard does well).
 +
 +===Related External Links===
 +[http://www.freesoftwaremagazine.com/articles/mail_merge_openoffice_org Maili merge in OpenOffice.org]
 +:An extensive article that details a way to use dBase files to make mail merges easier. May also be downloaded as a pdf.
{{botlangbarEN|[[Fr:Utilisation_de_l'Assistant_Mailing|Français]] [[It:Uso_della_Stampa_Guidata_in_Serie|Italiano]]}} {{botlangbarEN|[[Fr:Utilisation_de_l'Assistant_Mailing|Français]] [[It:Uso_della_Stampa_Guidata_in_Serie|Italiano]]}}
[[Category:NeoOffice]][[Category:Tips and Hints]] [[Category:NeoOffice]][[Category:Tips and Hints]]

Revision as of 01:29, 18 June 2008

NeoOffice includes two different ways of printing form letters.

The Mail Merge Wizard

This wizard holds your hand to produce a form letter with an address block at the top and an optional salutation tailored to the gender of the recipient. You can use it with any database that is registered in NeoOffice and it will work with both tables and queries. However there is a bug that causes it not to recognise the database if you are trying to use the results of a query.

These instructions should help you get passed the bug:

  • At stage 3 of the Mail Merge Wizard click "Select Different Address List…"
  • In the dialogue that appears the correct database should already be highlighted.
  • Click "Change Table…"
  • In the dialogue that appears the table is highlighted, not the Query.
  • Select the Query and click OK.
  • Click OK again
  • In the Mail Merge Wizard steps 4 and on should now be black and under the "Select Different Address List…" button should be the name of the database you are wanting to use.

DIY Form Letters

If you don't like Wizards (and quite frankly the Mail Merge Wizard is not a great example) then you can build your own Form Letters.

Open the Data Sources frame and drag the field names from your database into your document. When you are happy with the layout simply choose Print… from the File menu and a dialogue will appear asking you to confirm if you are printing a from letter or not. If you choose yes a simple dialogue opens allow you to choose which records to print and whether to send the results to printer or file. Do NOT check the "don't show this message again" checkbox! If you do, when printing you will only be able to print the field names in a document. The only way to "uncheck" this box is to trash the NeoOffice 2.2 folder found in username/Library/Preferences. (If you need to to this, see Recovering Settings from Old or Corrupt Preferences to learn how to salvage templates, autotext, and other data stored in NeoOffices preferences folder).

This is much simpler than using the Mail Merge Wizard, however if your address data contains blank fields there is no way of hiding them (something that the Wizard does well).

Related External Links

Maili merge in OpenOffice.org

An extensive article that details a way to use dBase files to make mail merges easier. May also be downloaded as a pdf.


This article in other languages: Français Italiano
Personal tools