Horizon Online Support

How do I use the record select query tab advanced section?

Enter a subject for the email generated.

The SQL query above selects your active internal contacts from Horizon. This is a great way to select multiple contacts without having to key in all email addresses individually. This also means that any new contacts you set up in Horizon are available in AutoMate without having to amend your AutoMate settings.

The above example will fetch internal contact from Horizon where they are set in the ‘Sales Rep or IT’ group.

As the query selects the name of the user, this can be used to fill in report parameters, allowing you to have one task setup in AutoMate that will deliver multiple reports.

If you used the ‘Online Password’ field to group you contacts, the following will select the members:

select email, name, salutation, secret from contact where trader_id = 0 and in_use = 1 and email is not null and secret like ‘CODE HERE%’;