Mail Merge with ACCESS

[Roy]

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

 

[Doug Robbins - Word MVP]

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.

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