[Art Lewis]

I am running a mail merge document from Access 2007 to Word 2007.
The “CurCln” field has twelve iterations of four letters: G, GR, GS, GSR, GSU, GSUR, GU, GUR, S, SR, SU AND SUR.

I want to enter a MAILMERGE statement in four places in a merge Word document using the Ctrl F9 method. There will be four statements that will select for each of the four letters ( G, S, R, U) that will enter a corresponding paragraph contained in a bookmarked separate Word document.

The logic I want is something like the following, but I do not know how to translate it to work in MAILMERGE and obviously, I don’t know how to call up a bookmark. I would be grateful for any help you can give me.

Field “CurCln” contains: G, GR, GS, GSR, GSU, GSUR, GU, GUR, S, SR, SU, SUR
C:\GSUR.docx has four bookmarked paragraphs named bmG, bmS, bmR, bmU

Eq G: IF(“CurCln” Like "G*", C:\GSUR.docx bmG,””)
Eq S: IF(("CurCln" Like “S*” or CurCln Like "*S*"), C:\GSUR.docx bmS,””)
Eq R: IF(("CurCln" Like “"*R", C:\GSUR.docx bmR,””)
Eq U: IF(("CurCln" Like “*U” or "CurCln" Like "*U*"), C:\GSUR.docx bmU,””)

Perhaps this could be done another way by selecting paragraph sets: Four paragraphs for GSUR, three for GSU, one for S and so on for all twelve iterations.

Art Lewis

[Natalie Lanoville]

Have you figured this out yet?