Macropod,

The stages are as they appear. The first stage is entering the field code into the field. The second stage is when I toggle the field codes off (and you can see that this code we're discussing has disappeared). The third stage is what happens when I actually do the mail merge.

I have attached the Excel document from which the data transfers, as well as the word document in which the merge occurs. You will have to amend the file paths where, in the code, you have " Set oMailMergeDoc = appWord.Documents.Add("Q:\HIU\Documents\CHP Quotation.dotm")"

CHP Clean.xlsm

Thanks,

dirtychinchilla