Use Python and pywin32 to find emails in your Outlook Inbox and save their attachments to a folder automatically.
Use a short VBA macro to create one PDF for each row in your sheet and prepare an Outlook email for each one.