Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
Should this be on Stack Overflow? (Relates to VBA programming) – Breakthrough Aug 18 '11 at 16:24
@Breakthrough Quite possibly. I was hoping to avoid programming, but if that's pure wishful thinking then naturally Stack Overflow would be more appropriate. – Richard Aug 19 '11 at 15:29
Well technically, that's what a macro is (just a VBA function). If you're comfortable getting your feet wet in VBA, record a macro accomplishing as much as you can for the task (i.e. selecting four records to send to a single person), and then going from there. If you'd like, you can provide us with some of the code for this and we can go from there... Although that would be a lot more suited to SO. – Breakthrough Aug 19 '11 at 15:35

You must log in to answer this question.

Browse other questions tagged .