Hi,
I have a contacts database sitting in SQL server that i would like to mail merge to send letters out etc. I use a combination of an Access front-end with an SQL databse that keeps the tables and records. The access and sql tables are linked by an ODBC data source connection.
The whole process works fine until I try and mail merge in MS word. When trying to retrieve data from the sql tables through the mail merge wizard i am prompted to use the same odbc data source connection to find the data, at which point word goes away and comes back with nothing.
If anyone has any ideas or has succesfully used this process I would be interested to know how??
Thanks
I have a contacts database sitting in SQL server that i would like to mail merge to send letters out etc. I use a combination of an Access front-end with an SQL databse that keeps the tables and records. The access and sql tables are linked by an ODBC data source connection.
The whole process works fine until I try and mail merge in MS word. When trying to retrieve data from the sql tables through the mail merge wizard i am prompted to use the same odbc data source connection to find the data, at which point word goes away and comes back with nothing.
If anyone has any ideas or has succesfully used this process I would be interested to know how??
Thanks