>Good morning!
>
>I am hoping for input regarding the following question, as I have limited *reliable* resources to converse with regarding FoxPro (in house).
>
>Here is my situation:
>
>I have a large client that receives reports from my company in two forms -
>
>* tabulated data from research
>* a copy of the worksheet used [the remarks that correspond to the questions on the worksheet filled in]
>
>
>I want to be able to Email both sets of reports to the company -- by Region. Each Regional manager must receive only his/her reports and a copy sent to the home office as well.
>
>This data is coming out of FoxPro -- is there a way to code a filter so that it will automatically parse the data into reports and email it by Region to the manager?
>
>There is another issue with the worksheets -- right now there is a programmer taking the FoxPro data and creating a "form" in WORD -- then marrying up the data to the corresponding fields -- THEN batching it and Emailing to the home office.
>This is very time consuming to say the least and WORD is restricted by size requirements on some of the fields, in any case my question here is this -- is there another piece of software that I can procure that would allow me to create a copy of the worksheet and have the fields populated by the FoxPro data? Then when we email it, the client could open the file, take a look at each worksheet with the corresponding data properly filled in and print it out for their records if they wanted/needed. Another plus would be to take that same file that is being Emailed and make it viewable via the Internet.
>
>Is there software that does this kind of thing already? Or do I need a programmer to study the data and write some sort of filtering program for the email part?
>
>I hope this is making sense, you all have helped me out before when I was being completely *mislead* regarding my FoxPro issues and solutions.
>
>I thank you for your time with consideration to the above questions.
>
>Amanda Barrett

Firstly, you can email any file from VFP application (there is code sample in Files section). Also, you can create many kinds of files (data subset, report output, etc) directly inside VFP app (and email them automatically). In regard to Internet: there are many ways to publish data there, one of them (probably simplest) is to use IIS grabbing Fox ODBS-source.