There are two main aspects to this issue: (1) generating the pdf, and (2) emailing the file.
When it come to generating the pdf file, are you saving a report from Page Designer to PDF or are you printing the actual table view to PDF?
If you are using Page Designer, there is no way to automatically turn the resulting report into an attachment. You must manually print to pdf and manually upload the attachment. On the other hand, there are a variety of tools that will automatically generate a pdf file for a record and upload it as an attachment. All of these tools have their pluses and minuses, and the best tool depends on budget, document complexity, number of documents generated per month, ease in generating templates, etc.
If you are creating a pdf by saving a table view, you have fewer options. To my knowledge, no third party tool will create a pdf report from a table view (versus a record). If I were automating this, I would use a scripting automation action that retrieves the data from the view, generates HTML to resemble the desired look, and converts the html to a pdf file using a third party service, and then upload the pdf file to a target record.
Once the file is in an attachment field, you can email the file using Airtable automations. There are several different email actions, but one of the most popular is using Google email. When you configure the email action, indicate field that contains the attachment you want to send. Note that sometimes it takes several seconds for an attachment to become fully uploaded, so you may need to have a delay between the creating the pdf file and uploading it, and actually sending the email.
