I have an access report based on a query that contains around 160 records. This number varies over time. I would like to be able to split this into 36 equal(ish) parts which will be emailed to various people once a week (each person should receive a unique set of records).
Obviously 160 can't be divided by 36 equally, so for this example some people would receive 4 records and some would receive 5.
I'd like to send the emails using a Macro and the SendObject Action.