Hello all,

I have a very small but annoying obstacle, that I would really appreciate some ideas.

Lets say we have the following Modules

Accounts

Contacts

Assets

Assets are connected to Accounts via Lookup - meaning that one Account can have many Assets
Contacts are connected to Accounts via Lookup by default - meaning that one Account can have many Contacts.

So here is the question - How can I filter all Contacts from Accounts that have an Asset starting with name X

Use case - Asset X is End Of Life and I want to send an email to all contacts in the accounts that have that Asset. Let's say 10 Accounts have this Asset and each Account has 3 Contacts - so I want to send it to 30 contacts.

I am failing to find a way how I can fiter Contact based on Assets but going through Accounts.

I am not sure I explained clearly.