The first label will be editable for editing and fine tuning.
"Horizontal pitch" is the distance between a label's left border and the next left border. "Vertical pitch" is the distance between a label's upper border and the next upper border. You may use this dialog page to compose your own label layout. Shows the layout setting for the chosen label type. You may also type in additional fixed content. Select the database, the table and add fields to the left box which represents one label. Select the label type (for instance Avery Letter Size, type 5159) The mail merge document will always request its data from a database document which provides the actual connection to the source. Tabular source data can be any kind of true database, a directory of dBase files, text files or a spreadsheet document. You can add and remove registrations or change them when a database document has been moved. shows the list of currently registered databases as shown in the data source window. allows you switch to another spreadsheet when the current spreadsheet has been moved or when you want to connect the same database to another spreadsheet.Ģ) Registered Databases. Your data remain in the spreadsheet and the database document makes it look like a database. The database document do not contain any data. It indicates that this database is connected to a spreadsheet file. There you should find your spreadsheet data in tables that are named after the sheet names. The context menu shows 2 items:ġ) Edit Database File.
In the left pane you see a "Bibliography" (shipped with your office suite) and the registered name of your database. Get the data source window (menu:View>Data Sources). To understand what the Base document does: Then you can open the output file and send that to a printer if the result looks fine or you can print the label document a second time and choose a printer. Having such a Writer document, just print it, confirm the message that you are going to print a serial letter and choose an output file in the next dialog Each mail merge field is a place holder for a specific column of a specific table in a specific database. A database document can be connected to a wide variety of tabular data, including spreadsheets.ġ) a registered database document (*.odb) serving the data.Ģ) a Writer document hosting the page layout with labels and the layout of individual labels with mail merge fields. Mail merge (and labels) always pull data from a database document. The label wizard and the mail merge wizard obfuscate the whole process because they completely hide away the database document (.odb) from the user.
0 kommentar(er)
