[Daniel Wheeler]

Hi all, appologies for the very unhelpful title, but need help.

I am doing this mailmerge from a access2003 database to word2003 document.

Some of the fields i want to merge with are check boxes on the database so
when i merge them into the word document they appear as "true" "false"
options. Is there away of viewing the results in the word document as tick
boxs or even just ticks when the answer is true and blank when the answer is
false???

Thanks

Dan

[Doug Robbins - Word MVP]

In the mail merge main document, use and If...then...Else... field
construction that inserts the appropriate symbols for the true and false
cases.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Daniel Wheeler" wrote in message
...
Hi all, appologies for the very unhelpful title, but need help.

I am doing this mailmerge from a access2003 database to word2003 document.

Some of the fields i want to merge with are check boxes on the database so
when i merge them into the word document they appear as "true" "false"
options. Is there away of viewing the results in the word document as tick
boxs or even just ticks when the answer is true and blank when the answer
is
false???

Thanks

Dan

[Daniel Wheeler]

Could you please show me an example...... as am trying to use that IF clause
but with no luck.... here is what i have tried, but yet to work. Can you see
where im going wrong????

IF {MERGEFIELD "Consultant_Desmond_High"} = True "moo" "cow"

Thanks

Dan

"Doug Robbins - Word MVP" wrote:

In the mail merge main document, use and If...then...Else... field
construction that inserts the appropriate symbols for the true and false
cases.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Daniel Wheeler" wrote in message
...
Hi all, appologies for the very unhelpful title, but need help.

I am doing this mailmerge from a access2003 database to word2003 document.

Some of the fields i want to merge with are check boxes on the database so
when i merge them into the word document they appear as "true" "false"
options. Is there away of viewing the results in the word document as tick
boxs or even just ticks when the answer is true and blank when the answer
is
false???

Thanks

Dan

[Peter Jamieson]

{ IF { MERGEFIELD "Consultant_Desmond_High" } = "True" "put a tick symbol
here" put a cross symbol here or leave it blank" }

All the {} need to be the sort you can insert using ctrl-F9 - you can just
insert two nest pairs and type everything else in the usual way.

Make sure you need "True" and not "true".

You can insert the symbol you want using Insert|Symbol

Peter Jamieson

"Daniel Wheeler" wrote in message
...
Could you please show me an example...... as am trying to use that IF
clause
but with no luck.... here is what i have tried, but yet to work. Can you
see
where im going wrong????

IF {MERGEFIELD "Consultant_Desmond_High"} = True "moo" "cow"

Thanks

Dan

"Doug Robbins - Word MVP" wrote:

In the mail merge main document, use and If...then...Else... field
construction that inserts the appropriate symbols for the true and false
cases.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Daniel Wheeler" wrote in
message
...
Hi all, appologies for the very unhelpful title, but need help.

I am doing this mailmerge from a access2003 database to word2003
document.

Some of the fields i want to merge with are check boxes on the database
so
when i merge them into the word document they appear as "true" "false"
options. Is there away of viewing the results in the word document as
tick
boxs or even just ticks when the answer is true and blank when the
answer
is
false???

Thanks

Dan

[Graham Mayor]

If the result of the field really is "True" then

{IF {MERGEFIELD "Consultant_Desmond_High"} = "True" "moo" "cow"}

(or if you want a tick for true and nothing for false {IF {MERGEFIELD
"Consultant_Desmond_High"} = "True" "Put a tick character from the Wingdings
2 character set here"})

will work (use CTRL +F9 for both sets of field boundaries.
Update the field to show the changed information before merging.

Note that long fieldnames (greater than 10 digits) can cause problems if
some of your field names are similar.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Daniel Wheeler wrote:
Could you please show me an example...... as am trying to use that IF
clause but with no luck.... here is what i have tried, but yet to
work. Can you see where im going wrong????

IF {MERGEFIELD "Consultant_Desmond_High"} = True "moo" "cow"

Thanks

Dan

"Doug Robbins - Word MVP" wrote:

In the mail merge main document, use and If...then...Else... field
construction that inserts the appropriate symbols for the true and
false cases.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Daniel Wheeler" wrote in
message ...
Hi all, appologies for the very unhelpful title, but need help.

I am doing this mailmerge from a access2003 database to word2003
document.

Some of the fields i want to merge with are check boxes on the
database so when i merge them into the word document they appear as
"true" "false" options. Is there away of viewing the results in the
word document as tick boxs or even just ticks when the answer is
true and blank when the answer is
false???

Thanks

Dan

[Graham Mayor]

Just a thought - your original question reports the result at "true". The
conditional field is case sensitive so if that is the case checking "True"
will not work. Use instead:

{IF {MERGEFIELD "Consultant_Desmond_High" \*Lower} = "true" "moo" "cow"}


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Graham Mayor wrote:
If the result of the field really is "True" then

{IF {MERGEFIELD "Consultant_Desmond_High"} = "True" "moo" "cow"}

(or if you want a tick for true and nothing for false {IF {MERGEFIELD
"Consultant_Desmond_High"} = "True" "Put a tick character from the
Wingdings 2 character set here"})

will work (use CTRL +F9 for both sets of field boundaries.
Update the field to show the changed information before merging.

Note that long fieldnames (greater than 10 digits) can cause problems
if some of your field names are similar.


Daniel Wheeler wrote:
Could you please show me an example...... as am trying to use that IF
clause but with no luck.... here is what i have tried, but yet to
work. Can you see where im going wrong????

IF {MERGEFIELD "Consultant_Desmond_High"} = True "moo" "cow"

Thanks

Dan

"Doug Robbins - Word MVP" wrote:

In the mail merge main document, use and If...then...Else... field
construction that inserts the appropriate symbols for the true and
false cases.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of
my services on a paid consulting basis.

Doug Robbins - Word MVP

"Daniel Wheeler" wrote in
message ...
Hi all, appologies for the very unhelpful title, but need help.

I am doing this mailmerge from a access2003 database to word2003
document.

Some of the fields i want to merge with are check boxes on the
database so when i merge them into the word document they appear as
"true" "false" options. Is there away of viewing the results in the
word document as tick boxs or even just ticks when the answer is
true and blank when the answer is
false???

Thanks

Dan