I have a report, that has to be emailed to all of the salesmen on the report, but I want seperate report for each salesperson.
I have created a report, exported it to snap files & it works fine. However I don't want to manually filter & export one at a time as there are over 50 to do on a monthly basis.
ie the final output will be:
salesman1.snp
salesman2.snp
etc.
Any advise would be helpful. I would prefer not to use vba, as I am OK in Access, but don't know vba at all. (I know time to learn...)
Thanks
Bruce
I have created a report, exported it to snap files & it works fine. However I don't want to manually filter & export one at a time as there are over 50 to do on a monthly basis.
ie the final output will be:
salesman1.snp
salesman2.snp
etc.
Any advise would be helpful. I would prefer not to use vba, as I am OK in Access, but don't know vba at all. (I know time to learn...)
Thanks
Bruce