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 22: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.


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