jjfcpa

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:

 

SMTPs

EMAILS

STUDENTS

 

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.

Outcomes