Need query to resignation approved employees

Hi,

I have a requirement to send emails to employees whose resignation is approved. So I want to use bursting to send emails to employees. Can anyone help me out with the query for this requirement.

Or is there any other way to send custom Email notifications with a static attachment to employees using alert composer. what conditions do i need to add for getting resignation employees.

thanks,

Dara nagasai