docs:openoffice:mail_merge

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
docs:openoffice:mail_merge [2007/03/27 12:40] billhdocs:openoffice:mail_merge [2010/06/10 20:58] (current) billh
Line 63: Line 63:
   - when you are finished dragging columns, close the Data Sources dialog (View -> Data Sources, or use the toolbar button)   - when you are finished dragging columns, close the Data Sources dialog (View -> Data Sources, or use the toolbar button)
   - save your letter template document (suggestion: same folder as spreadsheet, Example: "Letter - Easter.odt"   - save your letter template document (suggestion: same folder as spreadsheet, Example: "Letter - Easter.odt"
 +
  
 ===== Printing ===== ===== Printing =====
 +:!: if you have any trouble getting your printer to cooperate, you can also try making a letter size template and positioning the fields in the right place for your printer; typically this would be to make a landscape oriented letter size document
 +
 +=) it may be easier to save the document to a pdf instead of actually printing it so you can send the pages you want to the printer as many times as you need in case of feed issues, etc...
 +
   - with your envelope or letter template open, File -> Print   - with your envelope or letter template open, File -> Print
-  - on the dialog asking if you want to print a form letter, click "Yes"+  - on the dialog asking if you want to print a form letter, click "Yes" (DO NOT CHECK THE WARNING BOX!  See form letter warning section below if you messed this up)
   - if you are presented with a dialog asking if you want to print field names, click No   - if you are presented with a dialog asking if you want to print field names, click No
   - (optional - filtering) when presented with columns of your data, click on a cell that has a distinguishing characteristic of your choice, such as a cell with an "x" in an Easter column, or a specific code, and click the "AutoFilter" button   - (optional - filtering) when presented with columns of your data, click on a cell that has a distinguishing characteristic of your choice, such as a cell with an "x" in an Easter column, or a specific code, and click the "AutoFilter" button
Line 73: Line 78:
   - click Print   - click Print
   - follow your normal print dialogs accordingly   - follow your normal print dialogs accordingly
 +
 +===== Form Letter Warning Dialog =====
 +If you made the **BIG** mistake of checking the "Do not show warning again" box when printing, you need do the following:
 +  * close OpenOffice
 +  * find your user preferences
 +  * edit the file user/registry/data/org/openoffice/Office/Writer.xcu in a text editor, such as TextWrangler (Mac) or Crimson Text Editor (Windows)
 +  * find the section with <prop oor:name="AskForMerge">, find the "false" text and change it to "true"
 +  * save the file
 +  * OpenOffice should now present you with this warning dialog again
 +  * the long explanation of this: [[http://openoffice.blogs.com/openoffice/2006/10/how_to_get_the_.html|How to Get the "Do You Want to Print a Form Letter?" Message Back for OpenOffice Mail Merges]]
  
 ===== Advanced Fields ===== ===== Advanced Fields =====
  • docs/openoffice/mail_merge.1175020834.txt.gz
  • Last modified: 2008/08/03 00:25
  • (external edit)