Mail Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cookie - 01 Mar 2007 18:11 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 01 Mar 2007 21:32 GMT

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.

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

> 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

Reply to this Message

Rate this thread: