Use Git to keep every version of your scripts and Excel macros, so you can always go back to one that worked.
Use a short VBA macro to create one PDF for each row in your sheet and prepare an Outlook email for each one.