Emailer in MS Access VBA: Difference between revisions

From Squirrel's Lair
No edit summary
No edit summary
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
{{Project}}
{{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 built a tool in MS Access that provides e-mail-merge functionality.  
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.  


{{TD computer|}} Extract the relevant code and list it here.  
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.
 
|skillSet=Programming; Visual Basic for Applications(VBA)
[[Category:Office Automation]]
|projectType=Office Automation
[[Category:VBA]]
|northForge=No
[[Category:Portfolio]]
}}
{{To Do | Extract the relevant code and list it here. }}

Latest revision as of 20:48, 2021 October 31

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