Re: [exim] autoreply sql from date to date

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