Get Customer by Service ID on E-mail Outbound

[jff]

Hello everyone,

I pretty sure this has been asked before but I could not find anything related now.

I am using OTRS 4.

We are using services for our customers, some customer are related to more than one service.

We are also using E-mail Outbound, so what I would like is:

When the agent is going to open a ticket he has to select a service, this is working good already.

Now, the ticket is opened for service 123456, now I want to send an E-mail Outbound and would like to query the database to fetch all customers linked to the service the ticket was opened for:

Ticket is opened for service: 123456
When click E-mail Outbound I would like the TO field to bring all customers from the service_customer_user table where the id is the same for the ticket.

I thought this could be fairly simple but I am lost in OTRS, I'm not sure how can I achieve this.

Any help will be greatly appreaciated.