Hi macropod

Thanks for your help, but I am still a bit stuck. I have not had experience
with bookmarking before but have tried to follow your instructions. Although
I don't quite understand how/why maintaining a book mark can be a pain, I
opted for your suggestion to create a FILLIN field and this is what I have
entered (again * = space): -

{*FILLIN*"Enter*X*if*entering*Men's*Singles"\d**\* *MERGEFORMAT*}

(I don't understand the Mergeformat bit but presume it has been put there by
Word because this is a main document for a mail merge.) I selected all of
the Fillin and using Insert Bookmark named it CellB2.

The formula in C2 is now: - {*IF*{*CellB2*}=X*{*PRODUCT({*EntryFee*},2)\#*#0.
00*}""*}

I ran a mail merge and after answering the ASK prompts I had an error message
"A field calculation error occurred in record " for each record in the
source document, and all the sections of the resulting Form Letter had "=X"
(without quotes) in C2. I didn't get any prompt to "Enter X if entering
Men's Singles" even thought the FILLIN switch was set to \d.

Any further ideas please?

Regards

Peter



macropod wrote:
Hi Peterkins,

Table cell referencing doesn't work with text strings. To refer to a
character string in a cell, the character string (not the cell itself) must
be individually bookmarked and the bookmark referred to in the reference. So
my previous post on this was wrong (Should have read my own tutorial)!

So, if you bookmark the text range in cell B2 with something like 'Cell2B'
you could use a field coded like:
{IF{Cell2B}= X {=EntryFee*2} \# £,0.00}
Since maintaining the bookmark in such a field can be a PITA, you might find
it easiest to add a FILLIN field to cell B2 and bookmark that. Code the
FILLIN field something like:
{FILLIN "Enter 'X' if accepted"}

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...ables/200604/1