Using the Mail Merge Wizard

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 01:29, 18 June 2008 (edit)
Lorinda (Talk | contribs)
(add External Links section and a link)
← Previous diff
Current revision (04:11, 10 August 2012) (edit) (undo)
Sardisson (Talk | contribs)
(Related External Links - add the link patrick posted on trinity, which seems more current (and also handles labels))
 
(3 intermediate revisions not shown.)
Line 5: Line 5:
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.
-These instructions should help you get passed the bug:+These instructions should help you get past the bug:
* At stage 3 of the Mail Merge Wizard click "Select Different Address List…" * At stage 3 of the Mail Merge Wizard click "Select Different Address List…"
Line 19: Line 19:
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.
-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).+Open the Data Sources frame in the View menu. If your database or spreadsheet is not in the box on the left side of the frame, use Exchange Database in the Edit Menu to add your data source to the list. 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 form letter or not. If you choose yes a simple dialogue opens allowing 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 do 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).+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=== ===Related External Links===
-[http://www.freesoftwaremagazine.com/articles/mail_merge_openoffice_org Maili merge in OpenOffice.org]+[http://blog.worldlabel.com/mail-merge-in-openofficeorg-everything-you-need-to-know Mail Merge in Openofficeorg: Everything You Need to Know]
 +:A thorough article from OOo tutorial expert Solveig Haugland, provided by mailing label specialists Worldlabel.com. May also be downloaded as a pdf.
 +[http://www.freesoftwaremagazine.com/articles/mail_merge_openoffice_org Mail 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. :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]]

Current revision

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 past 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 in the View menu. If your database or spreadsheet is not in the box on the left side of the frame, use Exchange Database in the Edit Menu to add your data source to the list. 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 form letter or not. If you choose yes a simple dialogue opens allowing 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 do 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

Mail Merge in Openofficeorg: Everything You Need to Know

A thorough article from OOo tutorial expert Solveig Haugland, provided by mailing label specialists Worldlabel.com. May also be downloaded as a pdf.

Mail 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