Your database data are still NOT in the database document. Switch from Spreadsheet to dBase, click and choose the directory where you stored the dBase file. Right-click>Edit in the data source window is a handy way to access that file.Ĭall menu:Edit>Database>Connection type. Save your spreadsheet as a dBase (*.dbf) file. If you change from a spreadsheet connection to a dBase connection you get rid of this annoyance and you get the ability to edit your data directly in the data source window. The next dialog lets you choose if you want to print into a document or directly to a printer.Īfter you changed any data or structure in your spreadsheet, you have to save the spreadsheet and restart the entire office suite before the changes take place in Base and in your mail merge documents. ![]() In order to do the actual mail merge, just print, answer "yes" when asked if you are going to print a serial letter. Drag the grey column headers into your Writer document (or into your letter template) in order to insert mail merge fields. In the right pane your spreadsheet list appears. ![]() In Writer call menu:View>Data Sources, drop down the name of your database, then "Tables" and select your table. Now you may close and forget the database document but don't move it nor delete it. They are stored in the connected spreadsheet. Your database data are NOT in the database document. ![]() Register the database (as a source for serial letters, labels and such) Once you got the columns right you should switch over to a dBase database. The structure (columns, column labels, column order) of a spreadsheet is easier to change. Then you can use that spreadsheet as an address database (no recommended) or you can save the sheet as a dBase file which is easier to maintain in Base. Consistently means:Īnd the other rows get forenames, surnames, zip codes, cities, phones etc in their respective columns. For a very quick solution, type everything consistently into a spreadsheet.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |