Article ID: 918584 - Last Review: November 3, 2006 - Revision: 1.1

You cannot process a data collection e-mail reply when the query that the e-mail was based on contains an Access 2007-defined function

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access database (.accdb).
Novice: Requires knowledge of the user interface on single-user computers.
Expand all | Collapse all

SYMPTOMS

You cannot process a data collection e-mail reply when the query that the e-mail was based on contains a Microsoft Office Access 2007-defined function, such as the PlainText function in Access 2007. The e-mail reply does not process automatically into Access 2007, even if you select this option. You may notice that the data collection status in Microsoft Office Outlook 2007 displays the following information:
Failure: Undefined function 'FunctionName' in expression.
Note FunctionName represents the name of the function that you use in the query.

Additionally, you receive the following error message if you manually process the data collection:
Cannot export data due to errors. Failure: Undefined function 'FunctionName' in expression.

CAUSE

This problem occurs because the query contains an Access-defined function, such as the PlainText function. This problem occurs even though the expression field that contains the Access 2007-defined function is not in the e-mail.

WORKAROUND

To work around this problem, remove the reference to the Access-defined function, or remove the field that contains the function call from the query.

APPLIES TO
  • Microsoft Office Access 2007
Keywords: 
kbexpertisebeginner kbtshoot kbprb KB918584
 

Article Translations

 

Related Support Centers