Retaining Excel Formats in Mail Merge

Getting the formatting right when you use an Excel data source for mail merge can be extremely frustrating. There are ways to correct the formatting by using switches in the field codes, but it can be a time-consuming and frustrating exercise. Fortunately, there is an easy way to circumvent the use of switches and still have your data appear as you would like it.