Hi Lisa,

Attached is a document containing a two-key application of the field code with before & after text, using the ‘State’ and ‘City’ fields in the tutorial’s sample data. Since I don't have access to your data source, it would be difficult for me to tailor the field code to that. Nevertheless, that's largely a matter of replacing the relevant mergefields in the sample with the ones you use, plus editing the associated text.

I note from your post that you're using an Access database. Unless you're able to add a dummy final record, your last letter will not include the post-data text and you'll need to add that manually (e.g. via copy/paste from an earlier record).

PS: We needed to delete the 'code' image you had as it wasn't showing anything (perhaps because it was corrupt) and was causing problems with the thread display.

Attached Files

Directory Mailmerge Main Document for Letters with Two Keys.docx (22.5 KB, 35 views)

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