shogunjp Posted May 16, 2001 Share Posted May 16, 2001 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 Link to comment Share on other sites More sharing options...
BobWeaver Posted May 16, 2001 Share Posted May 16, 2001 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) Link to comment Share on other sites More sharing options...
shogunjp Posted May 23, 2001 Author Share Posted May 23, 2001 Thank you, it worked like a charm! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8396 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now