Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.