J
Jon Gammon
I'm trying deparately to automate a document as follows:
a) I have a bookmark in a template document that will
contain "Sir", "Madam" or a name of a person
b) I want to use the contents of the bookmark to determine
how the letter is signed - the rule is that if the
bookmark is Sir or Madam the letter is signed "Yours
faithfully", if it contains anything else it is
signed "Yours sincerely" (very British I know!)
c) I have tried every which way using the W97 help using
nested formulae with the IF and OR/COMPARE formulae and I
cannot get it to work - keep getting syntax errors. I can
get components to work but not the whole thing.
Can anybody help please!
Jon
a) I have a bookmark in a template document that will
contain "Sir", "Madam" or a name of a person
b) I want to use the contents of the bookmark to determine
how the letter is signed - the rule is that if the
bookmark is Sir or Madam the letter is signed "Yours
faithfully", if it contains anything else it is
signed "Yours sincerely" (very British I know!)
c) I have tried every which way using the W97 help using
nested formulae with the IF and OR/COMPARE formulae and I
cannot get it to work - keep getting syntax errors. I can
get components to work but not the whole thing.
Can anybody help please!
Jon