merge in a merge

[shogunjp]

Hey, I am working on a memebership database, and we have like 20 letters that follow similar formats but have to say different things. My idea was to put all the letters in a related database and link to them via a pull down value list that is compiled based on the titles of the letters.

So I pick a letter title in the main database, and it merges in the letter, which works great, until I put a merge field the body of the letter.

I know why it isn't working (filemaker only processes the original merge field and not the merge field that is in the letter) I was wondering if anyone had an idea as to a way around this?

Nathaniel

[BobWeaver]

You could use the Substitute function to replace merge type markers in your Letter text field like this:

MergedText = Substitute(Substitute(Substitute(Substitute(TemplateText,

"<<DataField1>>",DataField1),

"<<DataField2>>",DataField2),

"<<DataField3>>",DataField3),

"<<DataField4>>",DataField4)

[shogunjp]

Thank you, it worked like a charm!