Mail merge from Access to Word

[Matthew7]

I am preparing a Word document for a mail shot, and need to import data from my access file. I am trying to build a formula that will take a field from the Access file and, if it is true, print some data.

So far, I have =IF(Schedule 2014=40,full page). Schedule 2014 is a column in the query I am using in this mail merge, 40 is an amount of money in that column and full page is the text that should appear in the Word document. The result I am getting is!Syntax Error, 2014 .

The remainder of the information I am merging is working well. I am asking for the 40 to appear in the relevant recipient's letter which is fine, but I want it to print full page before it (or half page for 30, or quarter page for 20)

Anyone help?

[NTC]

well that syntax is not valid Access syntax for sure - but one can't say what is because it is not clear where this code resides...

on another topic however; in general: for the Word Merge feature of Office: the role of Access is to supply the data - not to format a Word document. So for dynamic Word doc design you probably are best seeking out developers that do Word design.....