Letter Replace Conditional Fields For Free

One of the little known features of Microsoft Word is the ability to do calculations based on mail merge fields. The process is as easy as creating an expression field and adding the formula field but somewhat hidden from the normal options Word gives you for using the mail merge fields.

Fill-inPlace your cursor where you want the fill-in text to go.In the Mailings tab, go to Rules > Fill-in.Enter a prompt, like "Event date?" in the Prompt box.Select OK, and then OK again.At the end of the process, when you hit Finish & Merge, select Edit Individual Documents.

Add individual merge fieldsClick or tap where you want the merge field.Choose the down-arrow under Insert Merge Field, and select a field.If you don't see your field name in the list, choose Insert Merge Field.Choose Database Fields to see the list of fields that are in your data source.Choose Insert.

Click Insert Word Field and select If...then...else. A screen appears allowing you to select the field you want to evaluate. Select the field name from the Field name list that corresponds to the data field on your Control Report that will be used to create the conditional statements.

Adding Font Formatting to Mail Merge Fields Simply highlight the entire merge field and apply the formatting from the Microsoft Word Home tab in the Ribbon. Try these options for formatting date and text mail merge fields to get the results you want in your documents.

When entering the IF function, format the true text and false text as you want them to appear. This could be a different colour, bold, underlined, larger. Whatever you need.

A conditional mail merge combines a set of simple merge documents with one data file; one or more conditional statements route each record in your data file to the appropriate merge letter. Select File, New from the menu bar. Select Blank and click OK. Select Tools, Mail Merge from the menu bar.