Page values for "Emailer in MS Access VBA"

From Squirrel's Lair

"_pageData" values

1 row is stored for this page
FieldField typeValue
_creationDateDatetime2021-10-09 4:02:24 AM
_modificationDateDatetime2021-11-01 3:48:41 AM
_categoriesList of String, delimiter: |Project
_pageIDInteger487
_pageNamePageEmailer in MS Access VBA
_pageTitleString

Emailer in MS Access VBA

_pageNamespaceInteger0

"Project" values

1 row is stored for this page
FieldField typeValue
shortDescriptionWikitext string

MS Access program using VBA to automate mailing personalized reports to >1000 people

longDescriptionWikitext

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.

geekeryWikitext
mainImageFile
Squirrelslair.png
skillSetList of Page, delimiter: ;Programming Visual Basic for Applications(VBA)
projectTypeList of Page, delimiter: ;Office Automation
northForgeBooleanNo
randomChangeForceBoolean

"ToDo" values

1 row is stored for this page
FieldField typeValue
whatTextall
questionWikitext

Extract the relevant code and list it here.

actionDtDate