Hi all,
I hope I'm following the right protocol here -- first time posting. I'm in a bit of a pinch with a project. I'm getting immersed in Access and related programming languages (SQL, VBA, etc), and I think I have a VBA scenario on my hands.
I have several Access reports, each one with anywhere from 1 to 80 records. I'd like to ...
- Split each Report by individual record and save it as a name unique to the record. So in a report that has 60 records, the script would split a single report with 60 records into 60 PDF reports each with a unique record.
- I would like the file names to be unique to the record. In this case, the record is a person ... so a file format that follows a LastnameFirstnameMonthYear (SmithJohnFebruary 2017) format would be super.
- Once split, I would like these individual PDFs emailed to the individual from which the individual report is based with a standard message body.
So when it's done, the script has either gone through each report I have and split it up by individual record, emailing these records to individual users with an email body template. Or it could be a script that just applies to one report so I'd have to run it per report to do what I'm trying to do. I'm just hoping this entire process can be automated.
The table from which these reports are run includes the email addresses associated with each record/individual.
I hope this is enough of an explanation. I'm "learning by doing" and in this particular case I'm not sure the right way to do it ... if you need any additional detail, please let me know!
Thank you and cheers!
Brandon