Difference between revisions of "Documentation/OOo3 User Guides/Writer Guide/Create data source"
m |
Clairedwood (Talk | contribs) m |
||
| Line 11: | Line 11: | ||
For the following example we use a spreadsheet with the following column (field) headers: ''Title, First name, Last name, Address, State/County, Country, Post Code, Sex, Points''. A sample data source is shown below. | For the following example we use a spreadsheet with the following column (field) headers: ''Title, First name, Last name, Address, State/County, Country, Post Code, Sex, Points''. A sample data source is shown below. | ||
| − | [[Image: | + | [[Image:CH11_SpreadsheetDataSource.png|thumb|none|500px|''Spreadsheet data source.'']] |
{{CCBY}} | {{CCBY}} | ||
[[Category: Writer Guide (Documentation)]] | [[Category: Writer Guide (Documentation)]] | ||
Latest revision as of 09:32, 4 June 2010
A data source is a database containing the name and address records (and optionally other information) from which a mailing list may be derived. Although you can create and print mailing labels and envelopes without using a data source, in most cases using one is the best approach. This chapter assumes that you are using a data source.
OOo can access a wide variety of data sources, including spreadsheets, text files and databases such as MySQL, Adabas, and ODBC. If the information to be used in the mail merge is currently in a format that OOo cannot access directly, you need to convert it, for example by exporting it to a comma-separated values (CSV) file.
For the following example we use a spreadsheet with the following column (field) headers: Title, First name, Last name, Address, State/County, Country, Post Code, Sex, Points. A sample data source is shown below.
| Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |
