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

Hi Peterkins,

The FILLIN field's '\d' switch doesn't cause it to prompt for *every* record
being merged - it simply sets a default value which, in the field codes
you've posted, is undefined. That's most likely the cause of your problem,
since it typically prevents the FILLIN field from prompting for an update.
To correct this, you could delete the '\d', though you might prefer to
change it to '\d "X"', so that the "X" response becomes the default.

Cheers
PS: I wasn't saying you hadn't mentioned doing a mailmerge, just that I
hadn't *seen* the reference beforehand.


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

First of all I would like to correct a typo in my post above dated 12

April.
In the third paragraph, the second FILLIN named CellB3 I stated to be in

cell
C2, but that should of course read cell B3. Also I should state that I am
using the version of Word that comes with MS Office Professional 2000.

Regarding your last response, with respect, I would point out that I *did*
refer to mail merge in my post which started this thread. Also regarding

the
switch for the FILLIN’s I showed this in my posts on 07 April and 12 April

as
\d – i.e. to prompt for *every* record being merged from the source

document.

It might help if I explain in more detail exactly what I am trying to do.

I
belong to a bowls club (lawn green *not* ten-pin) some of whose members

enter
National Competitions. There are four basic competitions (Singles – 1
entrant, Pairs – 2 in a team, Triples – 3 in a team and Fours – 4 in a

team)
and also age related variants on these. I have a database with columns

for
the variables – name, address, date of birth etc – and another column in
which I put an X to select that particular record for the mail merge.

There
is a record for each of the single entrants and team leaders with their
relevant details.

The main document has places amongst the text for the insertion of the
relevant mail merge fields and also has a table with a row for each of the
competitions. I have an ASK field that prompts *once only* for the for

the
competition year, and another ASK prompting *once only* for the Entry Fee

per
person which can vary each year.

From a list of names who are entering the competitions I select (with an

X)
the relevant records in the database. Running the mail merge produces a

Form
Letter with one section for each of the selected source records.

Initially I
proposed to key in an X in Column B of each section for the competitions
entered by that person or his teams. Then the formula in Column C on

finding
an X in Column B would calculate the total Entry Fee and when the whole
document was updated using F9 the results of the calculation would be seen

in
Column C.

When the formula would not recognise the character X, I posted the problem

in
this forum and then adopted your suggestion of using FILLIN’s. Once I can
get that working properly I will put FILLIN’s in *each* of the Column B

cells
with appropriate wording for the competition for that row. To know which
source record I am at, I would also include in the FILLIN prompt wording

the
{ MERGEFIELD LastName } field. I would then expect to get only one prompt
for each of the ASK fields (as I do at present) and ONE prompt for EACH
FILLIN for EACH source record as it is merged. If the person is not

entering
the competition for that FILLIN prompt I would press the space bar (or

Enter
key?) so a blank would go in Column B.

I hope the above will enable you to suggest why I am getting NO PROMPTS AT
ALL from the FILLIN’s only an error message about a field calculation

error
for EACH selected source record. In fact when the formula does the
calculations the results are correct, but they are done for EACH source
record irrespective of an X or blank in the cells in Column B.

If it would help I am willing to forward to you the files for the source

and
main documents for you to try running the mail merge. If you agree can

you
give me an address they can be sent to please?

Regards
Peter

Charles Kenyon wrote:
Nope. I haven't followed this entire thread so I hope you'll forgive me

if
I'm off base.


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