Yea, thank you for your response.
i have attempted that as well

Can I please expatiate more on this?
I am not technical, and I got confused about what to put in the content field.

Thank you. I am trying this out right away

Thank you for your response
I don't think this is available on Version 14 anymore because I have tried it as well

The functionality does work, I tested on V15. It creates a new status on the PO (To Approve) for orders above the value that you set.

The Approve RFQ button is visible to the manager. It is likely the test user you might have used has admin access so the PO did not go into To Approve status.
https://www.odoo.com/forum/help-1/what-happened-to-the-approval-tab-in-odoo-purchasing-app-207677

Also, to set automated action, you can check this post
https://www.odoo.com/forum/help-1/how-to-send-automatically-email-when-rfq-is-put-in-to-approve-state-171927

Alternate process could also be to create an Activity "Approve PO" which can be set by the person creating the RFQ assigned to manager or have an automated action to assign the activity. Since you might also need to track if the approver 'has approved' subsequent to reading the email

I just retried it. It moves to approval, but the email wasnt sent automatically to the approval.
The email was stuck in odoo

If email is stuck, then, you may have to check your outgoing mail server configuration. Try sending the stuck mail manually, you will get to know if mail server is configured correctly or not

Do check the below post as well, it is likely you can achieve the notifications being sent without the need for an automated action
https://www.odoo.com/forum/help-1/how-can-i-send-an-email-notification-when-a-document-changes-stage-208646