Jump to content

Emailer in MS Access VBA: Difference between revisions

From Squirrel's Lair
Ttenbergen (talk | contribs)
Created page with "I built a tool in MS Access that provides e-mail-merge functionality. {{TD computer|}} Extract the relevant code and list it here. Category:Office Automation Categor..."
 
Ttenbergen (talk | contribs)
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
I built a tool in MS Access that provides e-mail-merge functionality.  
{{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.  


{{TD computer|}} Extract the relevant code and list it here.  
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.  


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

Latest revision as of 19: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