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
____
CHERRY HILL • DOVER • HARRISBURG • LONDON • NEWARK • NEW YORK • NORRISTOWN • PHILADELPHIA • PITTSBURGH • SCRANTON
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.

Any help is GREATLY APPRECIATED!