|
|
Using the Mail Merge Wizard
From NeoWiki
| Revision as of 13:24, 22 December 2006 (edit) Amayze ( | contribs) ← Previous diff |
Revision as of 17:39, 22 December 2006 (edit) (undo) Sardisson (Talk | contribs) m (categories) Next diff → |
||
| Line 3: | Line 3: | ||
| ===1. The Mail Merge Wizard=== | ===1. 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 | + | 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 passed the bug: | ||
| Line 10: | Line 10: | ||
| * In the dialogue that appears the correct database should already be highlighted. | * In the dialogue that appears the correct database should already be highlighted. | ||
| * Click "Change Table…" | * Click "Change Table…" | ||
| - | * In the dialogue that appears the table is highlighted, not the | + | * In the dialogue that appears the table is highlighted, not the Query. |
| - | * Select the | + | * Select the Query and click OK. |
| * Click OK again | * 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. | * 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. | ||
| 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). | ||
| + | |||
| + | [[Category:NeoOffice]][[Category:Tips and Hints]] | ||
Revision as of 17:39, 22 December 2006
NeoOffice includes two different ways of printing form letters.
1. 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.
2. 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 From 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.
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).
