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

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
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.
Back to the top

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.
Back to the top

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.
Back to the top
APPLIES TO
  • Microsoft Office Access 2007
Back to the top
Keywords: 
kbexpertisebeginner kbtshoot kbprb KB918584
Back to the top