I have a very basic MS-Access database. It is basically comprised of Donors and Donations. I have been able to generate reports of the donations a donor has made between X date and Y date but I need help generating individual annual reports for each donor.
There is one caveat. Donors have an attribute called 'ReportPreference' which is set to either Mail or Email. If ReportPreference is set to Mail, then the report needs to be printed. If ReportPreference is set to Email, then the report needs to be emailed (with the To: field set to the Donor's email address). I have done been able to do this for the reports described in the first paragraph but I have no idea how to write the VBA required to Loop through to generate the annual reports for every donor AND include this logic as well.
Additionally, if the VBA could set the email to send via gmail instead of Outlook, that would be -amazing- but not 100% required.
22 pekerja bebas membida secara purata $69 untuk pekerjaan ini
Yes, the report will be composed on Outlook for each donor. Other will be printed on the printer on bulk. I hope you are using MS-Access 2010 or higher. Thank you.