fields won't merge, if statement, popups

July 28, 2011 at 10:12:47
Specs: Windows XP
Hi there,

My office currently uses a legal databased called Client Profiles ("CP"). We generate documents in Word or Adobe with merge codes. The datebase (CP) then populates the fields with the codes in them.

This morning we changed the letterhead. (Our cities have changed.) Now we have to go into Word and change every document individually. Ideally, while I'm there, we would like to create some sort of If statement to populate that offices contact info. Staff from 10 offices go into the database and click on the form-form example "appeal21" and the information than populates.

So the form or letter is set up like this:

form data

We would like the city office contact info to merge right here.

Here is the statement I'm using:
{if {city}= "CHERRY HILL" "1101 N. Kings Highway, Suite 405, Cherry Hill NJ 08034.” "{if {city}= "DOVER" "19 South State Street, Suite 100, Dover, DE 19901." “{if {city}= "HARRISBURG" "200 N. 3rd Street, Suite 9A, Harrisburg, PA 17101." "{if {city}= "LONDON" "10 Fenchurch Avenue, London, EC3m 5BN.” “{if {city}= "NEWARK" "P.O. Box 10170 Newark, NJ 07101, 430 Mountaiin Avenue, 4th Floor, Murray Hill, NJ 07974.” “{if {city}= "NEW YORK" "405 Lexington Avenue, Chrysler Building, 26th Floor, New York, NY 10174.” “{if {city}= "NORRISTOWN" "One Montgomery Plaza, 425 Swede Street, Suite 1001, Norristown, PA 19401.” “{if {city}= "PHILADELPHIA" "2000 Market Street, 13th Floor, Philadelphia, PA 19103.” “{if {city}= "PITTSBURGH" "2 Gateway Center, Suite 1450, 603 Stanwix Street, Pittsburgh, PA 15222.” “{if {city}= "SCRANTON" "201 Penn Avenue, Suite 400, Scranton, PA 18503.” }”}”}”}”}"}"}"}”}”}.

Is this IF statement formatted correctly?

How do I tell word to use a specific city? (I know there are documents where word asks the user a few questions like phone number or something right when the document opens. If I can get it to do that, asking what city, the user could enter the city name in, and then hopefully that city contact info would populate in the footer. How do I do this?

We using "insert--quick parts--include text ---pasting the filepath to accomplish inserting the new cities and citiy contact info into the letters. The city list changed correctly, but the bottom of the form looks like that really long string.

I called the Client Profile people and they said that this has to be done in word via an IF statement, but they couldn't provide anymore help than that.


See More: fields wont merge, if statement, popups

Report •

July 28, 2011 at 12:49:43
I cant answer your question about if it is formatted correctly, but thought I would give you an alternative. Have the document pull the letter head info from your if statement from the Local office server if it has one, or computer. Each office server has the filenamed the same. OffifeInfo.txt as an example. Then each office can fill in their own info. Since your merge will pull OfficeInfo.txt from the local office server/computer that is printing, it will grab one small piece of text, rather then having a document with a bunch different offices embedded in it.

Depending on what you trying to achieve in the end this may or may not work for you. Our office did what you were describing to a degree for titleblocks in our CAD drawings, and I found it to be more of a pain in the but then a time saver to have all the info embedded in one place.

Food for thought or maybe not

Report •

July 29, 2011 at 12:29:11
That's a lot of "Ifs" :) I don't see an "Else" in there though.

Have you contacted CP's support to see if they can help?

Report •

Related Solutions

Ask Question