Emailer in MS Access VBA
Appearance
| Projects | |
| Project: | Emailer in MS Access VBA (I) |
| Description: | MS Access program using VBA to automate mailing personalized reports to >1000 people |
| Skillset(s) : | |
| Project Type(s) : | |
An organization uses LimeSurvey to request feedback about events attended. This stores data in a per-survey format. They wanted to automatically mail out attendance receipts to participants based on receiving such feedback.
I created an MS Access database that accesses this data, turns it into a per-participant format, populates a report and then emails it to each participant.
A draw back of this system is that it creates such a bolus of email from the account of the sender that some spam filters will flag it, but it works OK for internal emails.
Extract the relevant code and list it here.