Difference between revisions of "Printing labels"
From Wiki2
(Created page with "===printing labels=== * If you have a template file you don't need to know anything about 'avery label/number' in Word * The template has field names Fname, Lname, section,...") |
|||
| Line 2: | Line 2: | ||
* If you have a template file you don't need to know anything about 'avery label/number' in Word | * If you have a template file you don't need to know anything about 'avery label/number' in Word | ||
* The template has field names Fname, Lname, section, the excel file has First, Last Section and a bunch of hidden fields. One way to deal with that is to copy all the rows into another sheet(2) rename the fields you need and delete the columns you don't. | * The template has field names Fname, Lname, section, the excel file has First, Last, Section and a bunch of hidden fields. One way to deal with that is to copy all the rows into another sheet(2) rename the fields you need and delete the columns you don't. | ||
* Open the template file, go mailings/select_recipients, find the excel file then select sheet2. | * Open the template file, go mailings/select_recipients, find the excel file then select sheet2. | ||
* You might then want to go mailings/edit_recipient_list and just select a page worth of names to check that everything is OK | * You might then want to go mailings/edit_recipient_list and just select a page worth of names to check that everything is OK | ||
* Goto mailings/preview/preview_results and then mailings/preview/finish&merge/print_documents. | * Goto mailings/preview/preview_results and then mailings/preview/finish&merge/print_documents. | ||
* If everything is copascetic goto mailings/preview/preview_results again and toggle preview off then go back to mailings/edit_recipient_list and select all the rest. The preview and print the rest. | * If everything is copascetic goto mailings/preview/preview_results again and toggle preview off then go back to mailings/edit_recipient_list and select all the rest. The preview and print the rest. | ||
* If you are using the single column labels, they need to be centered in the paper feed tray. | |||
Revision as of 22:06, 31 October 2019
printing labels
- If you have a template file you don't need to know anything about 'avery label/number' in Word
- The template has field names Fname, Lname, section, the excel file has First, Last, Section and a bunch of hidden fields. One way to deal with that is to copy all the rows into another sheet(2) rename the fields you need and delete the columns you don't.
- Open the template file, go mailings/select_recipients, find the excel file then select sheet2.
- You might then want to go mailings/edit_recipient_list and just select a page worth of names to check that everything is OK
- Goto mailings/preview/preview_results and then mailings/preview/finish&merge/print_documents.
- If everything is copascetic goto mailings/preview/preview_results again and toggle preview off then go back to mailings/edit_recipient_list and select all the rest. The preview and print the rest.
- If you are using the single column labels, they need to be centered in the paper feed tray.
