Formula in Word

Posted on 2016-09-26
Medium Priority
Last Modified: 2016-11-08
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
SPC:  via Fedex Airbill #
SPC:  hand deliver or other language, but no numeric values.
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
Question by:Bill Golden
  • 2
  • 2
LVL 77

Expert Comment

ID: 41815977
Is the Tags field a custom document property?

What sort of formula are you looking for - a test using Word Fields, VBA or something else?

Author Comment

by:Bill Golden
ID: 41817371
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

Author Comment

by:Bill Golden
ID: 41817402
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.
LVL 77

Accepted Solution

GrahamSkan earned 2000 total points
ID: 41817765
Tags in that sense are data external to the Word document file., so copying the document doesn't copy the Tags.  They are seen in the document properties 'Keywords, so you would need to use the DOCPROPERTY field. The next condition would be nested in the False part of the previous condition.
{ IF {DOCPROPERTY Keywords} <  1000000000000000000 "Fedex Airbill # " { IF {DOCPROPERTY Keywords} >  100000000000 "Certified Mail" "...}}

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
With the emergence of Office 365 as a superior email communication platform, many organizations have started switching over to it.  After migrating to Office 365, sometimes users, as well as organizations, will have to import PST files to Office 36…
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question