Sadly there's no workaround for using Page Designer for this.  There's an action to create a Google Doc via your Airtable data but that's fairly limited, and there are various third party tools that you can use to generate documents from your Airtable data.  Depending on which tool you end up using, your workflow could be to have it generated and sent immediately, or perhaps to have it generated, placed back in Airtable and then sent.

You can check out DocsAutomator for this, and I believe On2Air also has a documents thing that might work?

Hi!

There are two ways to solve this problem using Plumsail Documents - an application for automatically generating documents from templates:

1. First, as described above, you can use one of the connectors and the application to generate a PDF or other formats of document. The connector can be Make or Zapier, for example.
Zapier or Make will extract the data from Airtable and then populate it into a document template in Plumsail Documents to generate documents.

All that remains to be done is to configure the launch time of scenario/zap and configure the Delivery in Plumsail Documents to specify addresses.

2. The method is much simpler, you can use the Plumsail Documents extension for Airtable. Directly extract data from the Airtable table and generate a PDF document according to the template used. You can read about this integration in Plumsail Documents Documentation 

After adding the Plumsail Documents extension button and delivery method in Plumsail Documents. You just need to click a button to start generating and sending the document.