Note that there is a comma at the end of the first line. In the example that follows, the above will be saved to a plain text file called mergeme.csv (csv for Comma Separated Values, if it helps). Mark,Gilbert,666 Microsoft Way,Redmond,WA,ĭavid,Chart,123 Easydoc Street,Userville,MD,12345ĭom,Lachowicz,777 GNU Ave.,Utopia,CA,02111 Let's make a more realistic example for later use:įirstName,LastName,StreetAddr,City,State,Zip Therefore the above would leave field2 blank, without interrupting the flow of the merge. Values can be empty but must still be comma delimited: For every field, a value exists, in corresponding order within each line, and each line is a separate instance of the document (a separate copy printed). Each value is the text with which the field name will be substituted when you print your merged file. All subsequent lines in the data source will be as follows:Īgain, note the lack of comma (or any other unwarranted delimiter) at the beginning and end of each line. These names define what fields of data are going to be available in the data source, though you do not necessarily have to use them all in your merge. Note that the last field on the line does not have a comma at the end. The first row is a list of field names, separated only by commas, as follows: Using any text editor (or AbiWord, if you remember to save as plain text) you will create a text file with two or more rows of data. The third option is usually more trouble than it is worth for basic mail merge operations, and the second is identical to the first only with tabs instead of commas, so this document will keep it simple by only introducing the first. As of this writing, there are three common options for data source format:
0 kommentar(er)
