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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|