Hello all,
Hoping someone can give me a little help on this. I have a table in DB called EmAddr. This holds all the recipients email addresses and the group they belong to (108, 404, 872 etc). The 2nd table (named Term) is where data will be added. This has fields such as employee name, employee #, supervisor name, term date, group, term reason. I want to send these fields in an html email after the data has been added to certain people on the EmAddr table. Basically when new data is added in Term choosing group 108, I want the fields sent to the people in EmAddr table who belongs to group 108.
Any help will be appreciated. Thanks