- an email like template with input fields (to, cc, bcc, from, body, etc).
- a table where the user can specify the column headers and add a list of values. The headers are considered keys. The keys can then be referenced in mustache quotes anywhere in the template.
I also added attachment functionality since it was for a very specific use-case.
The tool would then create 1 email per entry in the user table, filling in all wildcards. As you can imagine, it doesn't use SES or Sendgrid .. it uses Outlook for the sending :) Good times! the business loved it, but coding in VBA is a bit of a PITA.
- an email like template with input fields (to, cc, bcc, from, body, etc).
- a table where the user can specify the column headers and add a list of values. The headers are considered keys. The keys can then be referenced in mustache quotes anywhere in the template.
I also added attachment functionality since it was for a very specific use-case.
The tool would then create 1 email per entry in the user table, filling in all wildcards. As you can imagine, it doesn't use SES or Sendgrid .. it uses Outlook for the sending :) Good times! the business loved it, but coding in VBA is a bit of a PITA.