[Chris]

Hello,

I'm trying to initiate a Mail Merge in Word 2007 from an Access 2007
database. In this database, there is an Image column which is actually just
an integer. I'm using it as a Flag to indicate which of the 8 images are
actually stored for a particular record. The path creation is rather simple,
Static_Path\ID-Flag_Bit.jpg.
So, in access, I would normally do something like
If Me!Image And 4 Then
//This image slot is being used
End if

This has worked well for Access. It's efficient and matches the project's
objectives exactly.
Unfortunately, I can't seem to get it to work in the Mail Merge process.

I've tried the following with no success:

{INCLUDEPICTURE "{IF {MergeField Image} And 4 "C:\\pics\\{MergeField
ID}-4.jpg" "C:\\pics\\blank.jpg"}" }

The error i receive is:
"A field calculation error occured in record 1."

And the field now reads
{ INCLUDEPICTURE "Error! Unknown op code for conditional." }

To make sure it wasn't just me misunderstanding, I changed And to =, and the
picture merged fine. This leads me to believe the And is the problem.

So, is there some special trick to getting bitwise operations working with
mail merge?

Thanks for the help,
Chris