Can you set up some kind of Export function?
We do something similar, but I don't use SQL - (dbman flat file to be exact) - instead I use CGI/Perl however the concept is the same.
What we do is:
1. "export" the data to a text file called labels.txt in a comma delimited format using Perl (to open and write the file and email it to us as an attachment)
2. We have a Word mail-merge called set up that it looks for a data/text file called "labels.txt" as part of the merge. (the labels.txt file gets overwritten each time)
3. And then merge the labels and print them.
It's really less hassle than it sounds - go to website, click button, retrieve email, save attachment, double click on merge doc, print labels
The whole thing can be done in less than 2 minutes.
Hope this helps somewhat....
We do something similar, but I don't use SQL - (dbman flat file to be exact) - instead I use CGI/Perl however the concept is the same.
What we do is:
1. "export" the data to a text file called labels.txt in a comma delimited format using Perl (to open and write the file and email it to us as an attachment)
2. We have a Word mail-merge called set up that it looks for a data/text file called "labels.txt" as part of the merge. (the labels.txt file gets overwritten each time)
3. And then merge the labels and print them.
It's really less hassle than it sounds - go to website, click button, retrieve email, save attachment, double click on merge doc, print labels
The whole thing can be done in less than 2 minutes.
Hope this helps somewhat....