Bill Golden
asked on
Formula in Word
I need a formula that test the contents of the Tags field in Word.
Our firm has a line at the bottom of correspondence with reads
SPC: via Certified Mail #1111 0000 0000 0000 0000 - Return Receipt Requested
or
SPC: via Fedex Airbill #
or
SPC: hand deliver or other language, but no numeric values.
or
the SPC line does not appear at all if the Tags field is blank.
Tags field in Properties will either have a number greater than 1000000000000000000 (Certified Mail)
greater than 100000000000 and less than 1000000000000000000 (Fedex)
or verbiage, if any, which should appear exactly as written
Our firm has a line at the bottom of correspondence with reads
SPC: via Certified Mail #1111 0000 0000 0000 0000 - Return Receipt Requested
or
SPC: via Fedex Airbill #
or
SPC: hand deliver or other language, but no numeric values.
or
the SPC line does not appear at all if the Tags field is blank.
Tags field in Properties will either have a number greater than 1000000000000000000 (Certified Mail)
greater than 100000000000 and less than 1000000000000000000 (Fedex)
or verbiage, if any, which should appear exactly as written
ASKER
Tags is a standard field used by Word. It is in the Word properties section.
Previously, Word 2003, we used Word fields with an If Statement
Previously, Word 2003, we used Word fields with an If Statement
ASKER
Currently, I have the following formula...
IF TAGS<1000000000000000000 "Fedex Airbill # "Tags"" "Certified Mail #"Tags" - Return Receipt Requested" \* MERGEFORMAT
I do not understand the nomenclature involved to get the value of Tags to print and my IF statement is not working.
IF TAGS<1000000000000000000 "Fedex Airbill # "Tags"" "Certified Mail #"Tags" - Return Receipt Requested" \* MERGEFORMAT
I do not understand the nomenclature involved to get the value of Tags to print and my IF statement is not working.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What sort of formula are you looking for - a test using Word Fields, VBA or something else?