Emailer in MS Access VBA

From Squirrel's Lair
Projects
Project: Emailer in MS Access VBA (I)
Description: MS Access program using VBA to automate mailing personalized reports to >1000 people
Skillset(s) :

Programming Visual Basic for Applications(VBA)

Project Type(s) :

Office Automation

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.



  • Cargo


  • Categories


  • Default form


Extract the relevant code and list it here. 
  • Actioned 2021-10-31


  • Cargo