Mail Merge HELP!!!

[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]

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

 

[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

 

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>