I am trying to build a trigger and I am hitting a road block.
When a record is inserted into the table... use the value for "#inserted.email" and look in another table called "CM_Contacts" and see if there is a record with that email address.
If there is a record send email to person A
If not then send email to person B
As the code stands now I am only getting the NOT found part even after I put a email address in from the CM_Contats table.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Pingzinggolf
I am trying to build a trigger and I am hitting a road block.
When a record is inserted into the table... use the value for "#inserted.email" and look in another table called "CM_Contacts" and see if there is a record with that email address.
If there is a record send email to person A
If not then send email to person B
As the code stands now I am only getting the NOT found part even after I put a email address in from the CM_Contats table.
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.