Hello,

I have used vexim, and edit this for my needs.

VIRTUAL_VACATION_DELIVERY_SUBJECT = SELECT vacationsubject FROM veximusers, veximdomains WHERE localpart='${quote_pgsql:$local_part}' AND domain='${quote_pgsql:$domain}' AND veximusers.domain_id=veximdomains.domain_id

VIRTUAL_VACATION_DELIVERY_TEXT = SELECT vacation FROM veximusers, veximdomains WHERE localpart='${quote_pgsql:$local_part}' AND domain='${quote_pgsql:$domain}' AND veximusers.domain_id=veximdomains.domain_id

router ACL:

virtual_vacation:
  driver    = accept
  no_verify
  no_expn
  unseen
  transport = virtual_vacation_delivery

transport ACL:

virtual_vacation_delivery:
  driver   = autoreply
  from     = "${local_part}@${domain}"
headers = MIME-Version: 1.0\nContent-Type: text/plain; charset=UTF-8\nContent-Transfer-Encoding: 8bit
  to       = ${sender_address}
  subject  = ${lookup pgsql{VIRTUAL_VACATION_DELIVERY_SUBJECT}}
  text     = ${lookup pgsql{VIRTUAL_VACATION_DELIVERY_TEXT}}


It's just an example, that works for me.
The query's depend on your database.

Today I use Sieve mostly. The disadvantage of this solution is that every mail per recipient will be auto replay in vacation time.

Within sieve you can say: Answer only once per week and sender.

On 24.01.23 12:38, Sławomir Dworaczek via Exim-users wrote:
hi
Do you have any idea how to set the auto-response parameter to work from date 
to date in exim using SQL query
Regards

--
## List details at https://lists.exim.org/mailman/listinfo/exim-users
## Exim details at http://www.exim.org/
## Please use the Wiki with this list - http://wiki.exim.org/

Reply via email to