![]() ![]() If anyone can refine this method to get closer to dynamic data processing - eg. This method does not link to TB contact data dynamically but refers to a snapshot CSV intermediate file which means that the more regularly names and addresses are changed, the more frequently the CSV needs to be rebuilt (steps 8-11) BE PREPARED TO REPEAT STEPS 8-11 TO REFRESH THE LABEL DATA FILE. To print your envelope, open the gLabels template and perform steps 22 & 23.ĬHECK YOUR ADDRESS BEFORE PRINTING! YOU ARE NOT ACCESSING THUNDERBIRD DATA DIRECTLY.Fine tune the layout by editing the gLabels template file.Select File>Print.>Preview to see how the envelope will print.Unselect All> then Tick the record corresponding to the contact you want to address on the envelope. Click Edit Merge Properties icon to see a list of contacts. ![]() Check your work with a print preview as follows (and edit if required) These fields can be arranged on the same line with spaces or placed on new lines by editing the text in the right pane window. A pick list allows you to select the fields you need for the envelope using the field numbers mentioned in step 18. Select the Text tab in the right pane and click the Insert merge field button. Click the 'Create Text Object' and click/drag to create a text rectangle aligned to the top left corner of the envelope area.You can create a shortcut to this on your desktop for convenience. Clicking the left triangle next to the contact data will expand the record vertically showing field numbers and the data held therein. Unselect All> then tick the record corresponding to the contact you want to address on the envelope.You'll be able to check all is OK because you will see data listed from the first field in the preview pane. Location: - Navigate to the CSV saved in step 11. Select Objects>Merge properties> Format: Text:Comma Separated Values (CSV).Open the envelope template you have created.You have an orientation option at this point - select 'Rotated'. When your envelope template is completed click File>New>Custom and follow the wizard.You only want 1 label - about envelope sized! This can be confirmed in the Layout(s) tab. Use the dimensions width and height from the Page size tab to define the label dimensions on the 'Label or Card Size' tab.Follow the Wizard using the page size to define the size of the envelope.This is the CSV that will be used by gLabels.ĬREATE ENVELOPE TEMPLATE FILES IN gLabels Save the Calc file as CSV in a location you will remember.Right Mouse click in cell A1 and select. ![]() Select File>New>Spreadsheet to open a new LO Calc file.Right click on the Base query and select.This will be used as a record identifier in gLabels.ĮXPORT THE REQUIRED DATA TO A CSV FILE THAT CAN BE READ BY gLabels TOP TIP Have the first field/column containing concatenated first and family names (in TB Contacts this is called 'Display'). Change the order of fields and sort/filter the data as required. Right mouse click on the query and select Edit.Select Queries>Use Wizard to Create Query>Select the table storing your contact data and pick the fields holding the salutations, names and address data.Open LO Base>Open an existing database file>navigate to your saved.odb file.ĬREATE A LIBREOFFICE DATABASE FILE TO PROCESS THUNDERBIRD CONTACT DATA This creates a data connection between TB contacts and LO. In LO Writer select File>Wizard>Address Data Source> Thunderbird/Icedove>.GIVE LIBREOFFICE ACCESS TO THUNDERBIRD CONTACT DATABASE gLabels installed from Ubuntu Software Centre.LO Base (the database module) installed.Once the templates are there, printing direct to envelopes is easy. This method requires a fair amount of non-technical effort to set up. That software is gLabels and it is available from the Ubuntu Software Centre. If anything doesn't work as advertised, bugs can be reviewed and reported here: Īn additional software application is needed to print a selected Thunderbird (TB) contact to an envelope using LibreOffice (LO). Make final adjustments/corrections so that everything aligns the way you want, insert your envelope in the printer based on the orientation chosen previously and click print. ![]() (For more on registering a database see Help, address books registering)or check the documentation here or perhaps hereĬhange to the Format tab displaying this:įinally, move to the Printer tab and choose the orientation at which you will feeding your envelope as below, adjusting any other settings as necessary to your requirements: Here you'll choose your registered database details for pulling your contact info in. Personally, I put addresses on my letters and use window envelopes but perhaps this will be more to your liking.įrom the writer menu select File->Insert->Envelope. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |