I have read the conversations here with one and two tables. Unfortunately I have 3 tables and I cannot find a way to send an email
Table 1 Attend
Activity ID
FirstName
LastName
Status
Table 2 Incharge
ActivityID
EmailAddress
Table 3 Schedules
ActivityID
(other details)
I can only send to a definite email address (and not to a variable email address) a table like this below, and forward to the correct Incharge email address, but that's a manual task already.
ActivityID FirstName LastName Status
When I used 'Send Email' with 'Join' for tablevariable.ActivityID = Incharge.Emailaddress, the emails sent was equal to the number of records in the tablevariable. So I was obviously doing it wrong.
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
bookish
I have read the conversations here with one and two tables. Unfortunately I have 3 tables and I cannot find a way to send an email
Table 1 Attend
Activity ID
FirstName
LastName
Status
Table 2 Incharge
ActivityID
EmailAddress
Table 3 Schedules
ActivityID
(other details)
I can only send to a definite email address (and not to a variable email address) a table like this below, and forward to the correct Incharge email address, but that's a manual task already.
ActivityID FirstName LastName Status
When I used 'Send Email' with 'Join' for tablevariable.ActivityID = Incharge.Emailaddress, the emails sent was equal to the number of records in the tablevariable. So I was obviously doing it wrong.
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.