Before you begin preparing templates for use with Redtail, it’s a good idea that you become familiar with what fields Redtail supports as available for Mail Merge documents. You can view that list of fields here.
Preparing Your New Mail Merge Template
Open up Microsoft Word and pull up either a blank document or an existing document that you would like to make available as a Mail Merge template.
Date and Time
If you are preparing a letter or some other document and you want to include the date and/or time, be aware that Redtail has no mail merge field for this because Microsoft Word has this function built in as an Insert. Within Microsoft Word, select Date & Time under the Insert menu. You will then see the dialog box below with many available Date and Time formats from which to choose:
Make your selection and click OK.
Adding Mail Merge Fields to your Template
If you’re ready to begin adding Mail Merge Fields to your template, the process is largely the same regardless of the version of Word you are using. The one difference is how you go about getting to the dialog box which allows you to add fields. In older versions of Word, under the Insert menu choose Field. In versions available since 2007, the Field option is available in a dropdown menu under Quick Parts on the Insert menu:
Either way, the dialog box below is what you’ll be working with. Instructions for completing it are below the dialog box:
Categories: Choose “Mail Merge” from the dropdown box.
Field Names: Choose “MergeField” from the choices available. Options under Field Properties do not become available until you have performed this step.
Field Properties: In the Field name text box, type in the Merge Field name you want to use (pick from the list of acceptable Field names on Redtail’s Mail Merge Fields document.)
Format: Leave this as “(none).”
Click OK and the dialog box will disappear.
You’ll then see the example below (where we used "Firstname" as our Field name) in your Word document, indicating the Mail Merge Field for First Name is now in your document (along with the verbiage around that merge field:
Note: if you wanted to include personalization to a spouse as well if one is present, see instructions here for doing so.
Proceed to add all the Mail Merge Fields that you need in your document. NOTE: It’s important to remember that if you’re adding an address block you should always add all three lines of the address. If a recipient doesn’t have address information that would ordinarily populate the Address 2 field, the spacing will adjust automatically within the document intended for them. If including an address block, it should look like the example below once in your document:
If you created a Mail Merge Document Template that included a Date & Time, an Address Block and a Salutation addressed to a First Name, the template might look something like the following:
If this were your document and you were happy with the layout, your next step would be to save the Word document somewhere on your computer so that you can upload it for use within your Redtail account. We recommend creating a folder either on your desktop or somewhere else that you can remember easily and calling the folder something like Mail Merge Document Templates for Redtail. Save your templates to this folder so you can easily find them when attempting to upload to Redtail. Note: You must save the file as a Word 97-2003 Document (*. doc) in order to be able to upload and use it as a mail merge template in Redtail.
Once the document is saved, you can then navigate within your database to Manage Your Account --> Mail Merge Templates. You’ll then see a library of your current Mail Merge Document Templates, if any. In the Select Files area to the right of these, you should see an add files link:
Click Add Files to locate the template file you just saved on your computer. Once you locate that file and click Open, you can then click the "start upload" button. After upload, the template will be available for your use in your library of current Mail Merge Templates.
Note that you also have a "filter" button that will allow you to filter the Mail Merge Templates you are viewing based upon any Categories you may have assigned to them.
Also, to the right of your Templates is a Templates by Category area, which is a visual representation of your Mail Merge Templates by Category (if you assign Categories to your Templates).