View Single Post
  #18  
Old April 15th, 2006, 05:08 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default MS Word table - problem with conditional formula

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