How to export report to different files

[rathnam]

I have a table with employee records. Currently I have one report of this table which exports this to one big rtf file (thro macro).

I want to dynamically create a report for each employee record and save it to an rtf file with the employeeID as the file name (employeeID.rtf).

The user should just give the folder and everything else should be automatic.

Please help!!