Mail Merge HELP!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daniel Wheeler - 03 Aug 2006 09:50 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 03 Aug 2006 11:43 GMT

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

Signature

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

> Hi all, appologies for the very unhelpful title, but need help.
>
[quoted text clipped - 10 lines]
>
> Dan

Reply to this Message

Daniel Wheeler - 03 Aug 2006 12:05 GMT

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

> In the mail merge main document, use and If...then...Else... field
> construction that inserts the appropriate symbols for the true and false
[quoted text clipped - 14 lines]
> >
> > Dan

Reply to this Message

Peter Jamieson - 03 Aug 2006 13:02 GMT

{ 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

> Could you please show me an example...... as am trying to use that IF
> clause
[quoted text clipped - 30 lines]
>> >
>> > Dan

Reply to this Message

Graham Mayor - 03 Aug 2006 13:15 GMT

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.

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> 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
[quoted text clipped - 33 lines]
>>>
>>> Dan

Reply to this Message

Graham Mayor - 06 Aug 2006 10:10 GMT

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"}

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

> If the result of the field really is "True" then
>
[quoted text clipped - 47 lines]
>>>>
>>>> Dan

Reply to this Message