Peter, I have solved the problem of setting up mail merge documents by exporting MergeTable as an Excel spreadsheet. When in doubt - cheat!
I am now facing a new problem - how to point Jet OLEDB:System Database at the PC that acts as server for other PCs.
Murray
[quote=Peter Jamieson;394769]Hi Murray,
as it stands, you need to terminate the connection string:
Connection:="Provider=Microsoft.Jet.OLEDB.4.0;Pass word=""pixie7826"";User
ID=Murray
M-R;
Data Source=C:\Documents and Settings\All Users\Documents\Age Concern
Databases\clients2002.mdb;
Mode=Read;Jet OLEDB:System database=C:\Documents and Settings\All
Users\Documents\Age Concern Databases\Secured.mdw;"
It's possible that you may need to quotes various things such as the
User ID and paths (two sets of double quotes at either end, like the
Password) but I don't think so.
The quotes in your SELECT probably need to be backquotes, like this:
SQLStatement:="SELECT * FROM `mergetable`"
rather than straight quotes, like this
SQLStatement="SELECT * FROM 'MergeTable'"
I tend to use [ ] instead to make this clearer:
SQLStatement:="SELECT * FROM [mergetable]"
You don't need SQLStatement1 or subtype, but neither of them should
cause any problems as they stand.
Peter Jamieson
http://tips.pjmsn.me.uk