Hello and welcome to the Community @Neil_Fernandes!
Unfortunately, do not currently support integrating Page Designer’s reports directly with the “Send email” automation action at this time.
However, one workaround you could do here is to create an attachment field on your table and make a PDF of each record’s Page Designer formatted document and then attach that PDF to that record. Then in your “Send email” action you can input the record’s PDF(which contains the Page Designer report) as an attachment.
Let me know if I can help provide any more information, and if this helped answer your question please mark it as the solution :white_check_mark: .