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]

Thanks Macropod! I changed the details to fit my specific case and got most of what I need. I even added in a jpg image (feeling quite proud of myself).

I need the BENEFIT (medical, dental, life ins, etc) to list the cost the employee pays or the benefit (like in life insurance). Since this would throw my Dependents down a line - would that mean that I need a 3rd key? If so, I need help inserting that. And knowing where to put the key "end" (so it will repeat).

I have attached the HAVE NOW file and the WOULD LIKE file. My HAVE NOW file is amazing - thanks to you. I also have my coded doc attached too.

Also - how do I find out more about this code syntax? Does this language have a name or something to search by? How would I find out the questions above if I didnt have you to help me? Not that I mind you helping me but if I need to make modifications based on different circumstances, I would like to know how to learn more.

Attached Files

	Have Now.pdf (427.9 KB, 12 views)
	Would Like.pdf (257.3 KB, 11 views)
	Benefit Confirmation merge with two keys.docx (76.6 KB, 21 views)