We need to send a report to each member (our customers) listing their purchases and the rebate we owe them on those purchases. In other words, I need to prepare a separate printed report for each Member. Since we have hundreds of members I need to automate the printing of this report using VBA or some other method an Expert recommends. Hopefully, one command will print a report for each member sequentially. So, at each change in MemberID, I need to start a new page. See Pivot Data tab for field organization.
Thanks for your help!