How To Use Mail Merge in AbiWord


Home > How To > How to Mail Merge Top Page Tutorial How To Information The process involves three main steps: creating the data source, creating the document template, and printing the merged result. Then you can get a little fancy. Interface Plug-ins Problems Creating the data source Credits Index As of this writing, there are three common options for data source format: GNU 1. Comma-delimited text FDL 2. Tab-delimited text 3. XML

How to Mail Merge

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. 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 first row is a list of field names, separated only by commas, as follows: field1,field2,field3 Note that the last field on the line does not have a comma at the end. 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. All subsequent lines in the data source will be as follows: value1_a,value2_a,value3_a value1_b,value2_b,value3_b Again, note the lack of comma (or any other unwarranted delimiter) at the beginning and end of each line. Each value is the text with which the field name will be substituted when you print your merged file. 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). Values can be empty but must still be comma delimited: value1_a,,value3_a Therefore the above would leave field2 blank, without interrupting the flow of the merge. Let's make a more realistic example for later use: FirstName,LastName,StreetAddr,City,State,Zip Mark,Gilbert,666 Microsoft Way,Redmond,WA, David,Chart,123 Easydoc Street,Userville,MD,12345 Dom,Lachowicz,777 GNU Ave.,Utopia,CA,02111 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). Note that there is a comma at the end of the first line. This is because, while there is no data for field Zip in that value set, the field still exists and needs to be accounted for. Forgetting to do this will cause problems; read on.

Creating the document template This is very simple. You create whatever document you want in AbiWord, and where you want values substituted for fields during the merge, you insert mail merge fields. The easiest way to do this involves prepopulating the mail merge field dialog with the fields in your csv file. To do so, run AbiWord with the -m argument, For example: AbiWord-2.0 -m mergeme.csv (via the command prompt, run dialog, or shell prompt) Now, to access the mail merge field insertion dialog, open the 'Insert' menu and click 'Mail Merge Field'. You should see a list of fields as shown in the dialog below.

All you have to do to insert a field at the cursor's current location in the document is select the appropriate field in the list and click Insert. The dialog even stays open and on top for you so you can move the cursor around in the document and insert however many fields you like, where you like. When done, click Close to close the dialog. Save the file as a normal AbiWord file (for this example, mergeme.abw). An example is shown below.

Printing the merged result There is not yet a working mechanism to print from the graphical interface, but the command to perform the merge and print is magnificently simple: AbiWord-2.0 -m mergeme.csv -p mergeme.abw (again from the command prompt, run dialog, or shell prompt) The first parameter, '-m mergeme.csv' is still simply telling the program where to get its data. The second parameter, '-p' is the switch to print with the file name to print postscript to, but all the usual potential values for -p work, if you want to print directly to your printer or filter or anything else. The third and last parameter, 'mergeme.abw' is the document template you just created. Note that when you print, there's a separate copy of the entire document for every set of values in the csv source. If you print to file, the files will be named like,, That's one .ps file for every set of values, with the numbering starting at 0. Beware of a corrupted csv. If a field is not accounted for (in other words, your file is missing a comma somewhere), the merge and print process won't work. Remember, if you don't have the data for a given field in one value set, just type another comma and move on. The field will be substituted with nothing (effectively deleted for that value set).

Uses Aside from inserting names on letters, you can use the mail merge system in the same manner to create envelopes for those letters. Mail merge, despite its name, is not just for mailing. It can also be used whenever you need to efficiently substitute multiple similarly formatted value sets from a data source, for any task or project. If you can create a csv of it, you can merge it. Other sources will soon be available such as various databases types, but many such database and address book applications support exporting to csv. Use your imagination to make the most use out of merging!


How To Use Mail Merge in AbiWord

Home > How To > How to Mail Merge Top Page Tutorial How To Information The process involves three main steps: creating the data source, creating the d...

25KB Sizes 3 Downloads 39 Views

Recommend Documents

To use Mail Merge:
1 | Page. To use Mail Merge: 1. Open and existing Word document, or create a new one. 2. From the Mailings tab,. 3. Clic

How to Use Mail Merge in Microsoft Word |
When you click on that, 'Start Mail Merge' is the third option from the left side of your screen. After clicking that, y

How To Use Mail Merge in Word 2016 | UniversalClass
To execute Mail Merge, simply select Start Mail Merge from the Start Mail Merge under the Mailings tab. Choose the appro

How to Use Mail Merge in Microsoft Word | Webucator
In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge

How to mail merge in Kingsoft Office?
Mar 31, 2012 - Redo the fifth and sixth steps to insert the Address. mail merge. 7) Once you have succeeded in merging t

How to use Mail Merge to automate Employee Appointment letters
Warning: This process involves handling sensitive PII. Ensure that sensitive information is only stored on an approved M

How To Use Yesware's Mail Merge for Gmail - Yesware Blog
Below, we walk through the creation of a 3-step Gmail campaign for new leads. As you read, keep in mind that Mail Merge

Introduction to Mail Merge Use IT+
Open an existing Word document, or create a new one. 2. From the Mailings tab, click the Start Mail Merge command and se

How to create a mail merge
Click on Mail merge wizard. Notice that the mail merge task pane is on the right side of the screen. The mail merge wiz

How To Mail Merge PDF Documents - Evermap
[HOW TO MAIL MERGE PDF DOCUMENTS ]. 15 Select “Employees” from a list of available Excel sheets (th