Looking for suggestions - sending emails

Discussion created by jjfcpa on Nov 6, 2014
Latest reply on Nov 6, 2014 by jjfcpa

I have a very simple solution that contains the following 3 tables:






I want to send some emails to selected students and I have that part pretty much handled.


The question I have is do I need to create a relationship between the SMTPs table, EMAILS table, and the STUDENTS table.?


The SMTPs table contains a separate record for each SMTP server that I can use to send out the emails.


The EMIALS table contains one record for each email that I may want to send out. There's only 3 fields ID, subject, and body.


The body has the text that will be in the body of the email with some codes that I put in that I will replace with fields from the students table, such as, <<NAME>> will be replaced with their actual name.


Appreciate any suggestions.