Table Reference in Email

[Lemuel_Del_Rosa]

Hi, I need your help regarding referencing tables in Email Templates.

Currently, I have these tables:

My email template looks like these:

But the output is:

My plan is to show the table from the Accounts table to the template, but the reference from my Email To table is from the Main table.

Is this possible? You may suggest alternatives to this problem.

Thank you very much!

[Suvrutt_Gurjar · Accepted solution]

The below is NOT tested. You may wish to try the below

Please create a VC called [All Accounts] with an expression such as [CV No.].[Related Accounts] in the Accounts table.

Please use this column in the second table in the report table under the heading "account Code’

So your second template table could be something like

Please note the <<Start: … >> and << End >> statements that need to be included in a multi record template.

[Lemuel_Del_Rosa]

Suvrutt_Gurjar:

[CV No.].[Related Accounts]

Worked like a charm! Thank you so much!