petermeachem
Programmer
I've written some code for the sales people allowing them to send emails/letters from Access. It might not be the best way of doing it, but what I have is.
The broker form has various filters so that the sales people can select the set of brokers they want to mail to. They select the template they want to use and the form then creates a table (in their mdb which is on their pc) and shells to the template. I've added an odbc connection to the mdb and a data source pointing to the local table, MyLocalIntroducers.
On my pc, I get a message box saying Word will use SELECT * FROM MyLocalIntroducers. This is all fine, I click OK, write my letter/email and merge it. Excellent.
On any other pc, the user has to select the datasource after the SELECT * message box is shown. I'd rather they didn't have to do this. The ODBC's and the datasource are set up in exactly the same way on all pc's. I can't see why everyone else should have to select a datasource.
Has anyone any idea?
The broker form has various filters so that the sales people can select the set of brokers they want to mail to. They select the template they want to use and the form then creates a table (in their mdb which is on their pc) and shells to the template. I've added an odbc connection to the mdb and a data source pointing to the local table, MyLocalIntroducers.
On my pc, I get a message box saying Word will use SELECT * FROM MyLocalIntroducers. This is all fine, I click OK, write my letter/email and merge it. Excellent.
On any other pc, the user has to select the datasource after the SELECT * message box is shown. I'd rather they didn't have to do this. The ODBC's and the datasource are set up in exactly the same way on all pc's. I can't see why everyone else should have to select a datasource.
Has anyone any idea?
