There has got to be a better way to achieve this.. There is an open report and Sendobject in the MACRO action/commands that does almost everything that I need, however , I cannot get it to make the record selection that i have setup for the report criteria..
how can I get it to send a separate e-mail for each report selection criteria?
Let me try again. There is no provision in SendObject to restrict the report to a given set of records. If you don't want to use the method I posted above to restrict the report, another option is to open the report using the wherecondition argument of OpenReport, then send it. That of course means 3 lines of code per, instead of 1, using a much less efficient method. You still need to loop through the grouped values to do it once per value. That takes you out of the macro realm and into VBA.