Jump to content
  • 0

Set Table Variable using 3 tables


bookish

Question

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.


BWH8Imh.png

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

Hello,

I might not be understanding your question, but if you want to join the tables that contain the Data for the email you can do so in the table variable. It would look like this, if you want to join by the "ActivityID":

 

image.png.1779997ae8b2f80f485a4c0acb263b87.png

Link to comment
Share on other sites

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...