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]
|