Mail Merge with ACCESS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy - 09 Jun 2004 04:14 GMT

Can ANYONE tell me how to do this?

We use Access for the data.
In a Word document "Template", I want to say:

If {field}(a particular field in Access) = "A" then
print "happy day". If {field] is blank, print "sad day".

I know this is easy for most of you, but I have looked and
looked and can't find it in the Help section.

Thank you!!

Roy Kaufmann

Reply to this Message

Doug Robbins - Word MVP - 09 Jun 2004 05:06 GMT

To do it in Word, use and If ... then ... Else field construction

{ IF { MERGEFIELD [The particular field in Access] } = "A" "happy day" "sad
day" }

But I would use the IIF expression in a query in Access and use that query
as the datasource.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> Can ANYONE tell me how to do this?
>
[quoted text clipped - 10 lines]
>
> Roy Kaufmann

Reply to this Message