F
Fritz Anton
Hi,
I have an Access 2003 database with 4 queries; 2 of them use only default
functions, the other 2 contain user-defined functions (VBA). All 4 queries
work flawlessly within Access.
When I try to mail-merge the query results into Word 2003, the documents
based on queries with default functions are generated as expected, the ones
with user-defined functions display an error message - "too few fields in
data set 1/2" (translation from German). Word offers two data sets only, one
named M___, the other M___1 and both are empty of data.
This happens when I create a mail merge in Word or when I export the query
from Access via "Office-link/mail merge into Word". I can, however, create a
Word table via "Office-link/publish with Word" (again, translated from
German) and using this table as data source, Word succeeds to create a mail
merge document.
This problem turned up after a re-installation of Windows XP (SP1+2) and
Office 2003 Pro.
Can somebody point me in the right direction, please?
Fritz
I have an Access 2003 database with 4 queries; 2 of them use only default
functions, the other 2 contain user-defined functions (VBA). All 4 queries
work flawlessly within Access.
When I try to mail-merge the query results into Word 2003, the documents
based on queries with default functions are generated as expected, the ones
with user-defined functions display an error message - "too few fields in
data set 1/2" (translation from German). Word offers two data sets only, one
named M___, the other M___1 and both are empty of data.
This happens when I create a mail merge in Word or when I export the query
from Access via "Office-link/mail merge into Word". I can, however, create a
Word table via "Office-link/publish with Word" (again, translated from
German) and using this table as data source, Word succeeds to create a mail
merge document.
This problem turned up after a re-installation of Windows XP (SP1+2) and
Office 2003 Pro.
Can somebody point me in the right direction, please?
Fritz