Using office 2007 for Word and Access.
Tested query in MS Access which is working OK.
Have set up an odbc link to the access database.
Tried to set up the mailmerge in Word 2007 using blank document.
On MAILINGS tab have used 'Select recipients', 'use existing list'. Presented with form 'Select data sources'.
Selected 'new source' then 'odbc dsn'.
Selected odbc link from the list. Next form shows correct database and location. Correct query selected from the list.
Clicked finish.
Presented with mailmerge information boxes 'record 1 too few fields'.
On checking the tab Mailings' again and clicking on 'edit recipient list' I get the same mailmerge information boxes as above and then the form 'Mailmerge Recipients'.
This shows that the datasource is the mydatasource file and the selectable fields are the fields within the mydatasource records.
What am I doing wrong? How can I get rid if this forced link to mydatasource folder and back to my own datasouce, the MS Access database?
I whole day wasted trying to find a way out.
NB previous mailmerge on Office2003 all work fine!
Tested query in MS Access which is working OK.
Have set up an odbc link to the access database.
Tried to set up the mailmerge in Word 2007 using blank document.
On MAILINGS tab have used 'Select recipients', 'use existing list'. Presented with form 'Select data sources'.
Selected 'new source' then 'odbc dsn'.
Selected odbc link from the list. Next form shows correct database and location. Correct query selected from the list.
Clicked finish.
Presented with mailmerge information boxes 'record 1 too few fields'.
On checking the tab Mailings' again and clicking on 'edit recipient list' I get the same mailmerge information boxes as above and then the form 'Mailmerge Recipients'.
This shows that the datasource is the mydatasource file and the selectable fields are the fields within the mydatasource records.
What am I doing wrong? How can I get rid if this forced link to mydatasource folder and back to my own datasouce, the MS Access database?
I whole day wasted trying to find a way out.
NB previous mailmerge on Office2003 all work fine!