Emailer in MS Access VBA

Projects
{{#cargo_query: tables=Project		fields=CONCAT("File:",mainImage,"" )=	where=_pageName="Emailer in MS Access VBA"	format=list	default= }}
Project:	Emailer in MS Access VBA (I)
Description:	MS Access program using VBA to automate mailing personalized reports to >1000 people
Skillset(s) :	{{#cargo_query: tables=Project	fields=skillSet	where=_pageName = "Emailer in MS Access VBA"	format=list	default= No skillsets }}
Project Type(s) :	{{#cargo_query: tables=Project	fields=projectType	where=_pageName = "Emailer in MS Access VBA"	format=list	default= No project type }}

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

{{#cargo_store: _table = Project | shortDescription = MS Access program using VBA to automate mailing personalized reports to >1000 people | longDescription = 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. | geekery = | mainImage = Squirrelslair.png | skillSet = Programming; Visual Basic for Applications(VBA) | projectType = Office Automation | northForge = No }}

• Categories

• Default form

Actioned 2021-10-31

---

• Cargo

{{#cargo_store: _table = ToDo |what=computer |question= |actionDt={{subst:Now}} }}

Extract the relevant code and list it here.