Automated follow up emails after X days from purchase date

[xxxxxxxxxxxxxxxxxxxx]

Is it possible to send automated follow-up emails after a purchase has been done and paid?

 

I'm working on a shop that sells customized products that need to be produced after the order has been palced, and it usually takes 14 to 18 days. I'd like to send an automated email after 10 days, telling something like "we're working on your order and we're almost done".

 

Is it possible? How can I do it?

I saw a few modules to send follow up emails but just for abandoned carts... and that's not my case.

 

Thanks

Stefano

[xxxxxxxxxxxxxxxxxxxx]

Nobody ever needed this? 

[g_escande81]

_{Ligne 289}

    WHERE DATE_SUB(CURDATE(),INTERVAL X DAY) = DATE_FORMAT(c.date_add,\'%Y-%m-%d\') AND o.id_order IS NULL