View Single Post
  #17  
Old April 14th, 2006, 10:52 AM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default MS Word table - problem with conditional formula

Thanks Charles,

The situation Peterkins described indicates the ASK field fires repeatedly
but the FILLIN field was firing only once. To me, this implies the likely
presence of the \o switch on the FILLIN field. As for the impact of the
merged output, not having used a FILLIN (or ASK) field in a mailmerge, I
wasn't sure how much would survive the merge process.

Cheers


"Charles Kenyon" wrote in message
...
Nope. I haven't followed this entire thread so I hope you'll forgive me if
I'm off base.
When an Ask of a FillIn field is used in a mail merge, where the box isn't
checked to Ask Once, it will be asked each time. Further, where a Ref

field
is to a bookmark which contains a FillIn field, the Ref field will give

the
result for each answer in turn. As each merge is performed, the Ref field

is
unlinked so the reference will reflect each answer rather than only the

last
one.
--
Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!

My criminal defense site: http://addbalance.com
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.


"macropod" wrote in message
...
Hi Peterkins,

If you're using a FILLIN field in a mailmerge, you *should* get a prompt
for
each record, unless you've added the \o switch to the FILLIN field.

I didn't see any mention of a mailmerge before your latest post. This
raises
additional issues, since each merged record will be setting the same
bookmark, and (subject to the above), the merged output will end up
holding
only the last bookmark value. If the FILLIN fields are still there in

your
merged output, you could use Ctrl-A then F9 to update them all after
merging, following which I'd either lock the fields via Ctrl-F11, or
permanently convert them to their calculated values via Ctrl-Shift-F9.

Cheers


"Peterkins via OfficeKB.com" u20492@uwe wrote in message
news:5eabff5860a06@uwe...
Hi macropod

Sorry for the delay in coming back to this forum, but have been rather

busy
for the last few days. I am sorry to say I am still having great

difficulty
in resolving this problem.

The formula in C2 is now: -

{*IF{*CellB2*}=X*{=PRODUCT(EntryFee,1)*}*\#*#0.00}
and in C3 a similar formula but with a 2 instead of a 1 after the

EntryFee.

The contents of B2 are [{*FILLIN*"Enter*X*for*Men's*Singles"\d*}] with

a
bookmark title of CellB2. A similar Filllin in C2 with Pairs in place

of
Singles has been bookmarked as CellB3.

Running a mail merge first prompts for each of the ASK fields, and then
immediately issues 'A field calculation error occurred for record ' for

each
of the selected records in the source document. The resultant Form
Letter
has the correct calculation in C2 and C3 (i.e. EntryFee x 1 or x2), but

these
appear in those cells in EACH of the sections. Since no prompts were

issued
for the Fillins this is probably not surprising, except that I would

have
thought that since there is no X in B2 or B3 the formula result would
have
been 'False' and therefore C2 and C3 should have remained blank.

It seems that the Fillin function is not working correctly. At first I
thought this might be the cause of the error message, but since I only
get
one error message per record, and not one for each Fillin for each

record
I
now have my doubts.

I would be grateful if you, or anyone else, can identify why this

feature
is
not working.

Regards
Peter

macropod wrote:
Hi Peterkins,

You can safely delete the \* MERGEFORMAT switch.

For the formula, use any of:
{IF{Cell2B}= X {=EntryFee*2} \# ,0.00}
{IF{Cell2B}= X {=EntryFee*2} \# £,0.00}
{IF{Cell2B}= X {=PRODUCT(EntryFee,2)} \# ,0.00}
{IF{Cell2B}= X {=PRODUCT(EntryFee,2)} \# £,0.00}
Note that you mast have a '=' sign in the second field, and the false

output
(ie "") isn't necessary.

--
Message posted via http://www.officekb.com