Recent content by sureshmopl

Hi, I could not make the record-set as you suggested mainly because I am not that good with codes. I made separate reports for each employees (using the SELECT command at Data->Record Source tab of report properties) and with the following code, exported all those reports as html in a folder...

Hi, Can anyone please tell me how to automatically e-mail my reports to the respective employees using Outlook? I have more than 100 separate reports which I wants to send based on the e-mail ids and employee code in my table. I am using Access 2000. Thanks in advance.

Thank you. Am not that good at VBA code but will try the methods you have suggested.

These queries are based on separate values from the same field. For example, its filtering the data based on employee code. So I need separate reports for separate employees based on these queries.

Hi all, I have more than 100 select queries in my db. I needs to run a report with same design, separately for each queries. How do I do it without running the report one by one? I can run these queries together and get the output in separate files with the following sample code ...

Thank you very much. The link is very informative.

Thank you Minty. I will try the method you have suggested and update.

Hi Thank you for the link. I have gone through it in detail. But its too advanced for me and it is basically answering the mass e-mailing aspect. What I needed is a simple solution for running multiple queries that give respective pdf or html files output at once. I know how to do it one by...

Yes it is. Just wants to filer the data based on the employee code. Rest will be same.

Hi Thank you very much for the response. Yes my purpose is to pull the data corresponding to the employee code and make an output file (pdf or html). It can be through query or module. Whichever makes it easy. My Table Design is as follows : Field name Data Type Employee code...

Hi I have a table of around 1000 records with different data of 250 employees with employee code. I needs to run a query which creates a PDF or HTML file for each employee separately with their respective details.I know the select query will solve the purpose for each employee code criteria but...