My scenario is that i have created a sales order and also warehouse shipment is created. Now for some reason user has revised the order.
I want an email to be send to warehouse team that will show the field which is been revised and also the new and old values.
Shoot a report to the Warehouse Employee over Email every time u make Warehouse Shipment and that will be the best solution for your case.
Just make it Flag based so that it only shoot the email if the flag is manually enabled by the user who actually did the changes and e wants a notification email to be sent.
Can you explain in briefly.
i only want to send email with the order is revised.
You must be having couple of fields so on the basis of that you need to track however you want either with a flag or something else. You may pull the entries from change log entries as well but it may affect somehow performance.