See Conditionally Merge Spouse Data in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum. Although the field coding there doesn't specifically address the honorifics issue, it could easily be extended to do so. There is also no need to output the data to Excel before merging - it can be done just as easily using the Access database.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Paul,

Thank you for your reply. We are moving away from Access due to the employee who will be merging the files is unfamiliar with it, and we think this would be easier for her. I will check out the site you mentioned.

Thanks again.