Difference between revisions of "Documentation/OOo3 User Guides/Writer Guide/Create data source"
(New page: {{DISPLAYTITLE:Creating the data source - DRAFT}} {{Documentation/WG3MailMergeTOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Writer Guide/Using Mail Merge |NextPage=Docum...) |
Clairedwood (Talk | contribs) m |
||
(One intermediate revision by one other user not shown) | |||
Line 1: | Line 1: | ||
− | {{DISPLAYTITLE:Creating the data source | + | {{DISPLAYTITLE:Creating the data source}} |
{{Documentation/WG3MailMergeTOC | {{Documentation/WG3MailMergeTOC | ||
|ShowPrevNext=block | |ShowPrevNext=block | ||
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). |