Field Results Won't Display

[Jean Peterson]

I am creating a Merge Catalog that is a Contact List using
an Access Query as a Data Source. I am trying to insert an
If/Then/Else field so that if there is a Work Phone#, it
will insert the text: "Work Phone: { MERGEFIELD
WorkPhone }" otherwise it will insert nothing. I'm using
the "Insert Word Field" button. When I toggle to "View
Merged Data" no one has a "Work Phone" even though the
majority of the people do. I have several other
If/Then/Else fields I'm trying to utilize and am also
getting zero results displayed for them. Following is the
field I copied from my document. Any idea what I'm doing
wrong?

{IF { MERGEFIELD WorkPhone } <> "" ""Work Phone: {
MERGEFIELD WorkPhone } "" ""}

Thanks.
Jean Peterson

 

[Peter Jamieson]

If you execute the query in Access, do you definitely see the phone number?

Which version of Word, and how is the connection to Access made?

 

[macropod]

Hi Jean,

Too many double quotes in your field. It should look like:
{IF{MERGEFIELD WorkPhone}<> "" "Work Phone: {MERGEFIELD WorkPhone}" ""}
or
{IF{MERGEFIELD WorkPhone}= "" "" "Work Phone: {MERGEFIELD WorkPhone}"}

Cheers

 

[Guest]

If the other options don't work, here's something else to
try.

I don't know anything about Access but when in word, I've
found that the merge data won't show if you are in the
field code format.

Click Alt/F9 to get into the regular merge format. The
View Merged Data toggle should work. At least it works in
Word 2000.

An alternative way to do the same thing is to go to the
Tools Menu and select Options. Click the View Tab and
click OFF field codes.

Good Luck

 

[Guest]

If you execute the query in Access, do you definitely see
the phone number?Yes. There is WorkPhone data.

Which version of Word, and how is the connection to Access made?

I'm using Office 2000. I used the Open Data Source button.

Jean Peterson

 

[Jean Peterson]

Too many double quotes in your field. It should look like:

{IF{MERGEFIELD WorkPhone}<> "" "Work Phone: {MERGEFIELD WorkPhone}" ""}
or
{IF{MERGEFIELD WorkPhone}= "" "" "Work Phone: {MERGEFIELD WorkPhone}"}

OK, I think this helped. I was following the instructions
and copied the quotes into the "Insert this text" box. Now
when I merge to a new document, I get the If...Then
statement instead of the data. I thought I read something
on this list about updating the data or something to
change that but I can't find it.

Jean Peterson

 

[macropod]

Hi Jean,

A simple copy & paste from the newsgroup posting won't work - the braces in
the posting have to be inserted as/converted into FIELD braces, via CTRL-F9.
If you take the first example, select the first 'MERGEFIELD WorkPhone'
string and press CTRL-F9, then delete the typed braces at either end. Do the
same with the second. Finally, do the same with the whole field. In the end,
your field should look like the example, but with Word's FIELD braces
instead of the typed ones. Don't worry if Word puts in extra spaces inside
the FIELD braces - they're inconsequential.

Cheers