Mail Merge

[Cookie]

Good Afternoon,
Is there a way to force MS Word to place the field name from an Access
database instead of the data? I have a database with 'yes/no' fields
but what I need for the mail merge is the field name.
Thank you.
Cookie

 

[Doug Robbins - Word MVP]

Just type the field name.

I guess however that what you really meant to ask is "How do I get mailmerge
to display "Yes" or "No" instead of -1 or 0?"

To do that, the best thing to do really is use a Query in Access with an IIF
field construction that returns "Yes" if the value of the field that is
being checked is -1 and returns "No" if it is not -1

If can also be done with an { IF } field construction in Word, but I would
do the manipulation in the data source.

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