Exporting Queries to Excel Automatically

G

grantschneider

I have a table filled with information on different salesperson.
Currently, to give them updates on their customers, I sort them in
excel, then copy each single salesperson's data from the mastersheet
into another excel files, save it and then email it to them.

Is there a way in access to query each one of the sales people's info,
sort by a field and then export each one of their data separately to
excel?

I hope this is clear.

Grant
 
Top