View Single Post
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail Merge HELP!!!

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