PURCHASE ORDER LOG

We used purchase orders for logging purchased our operations team makes. the system works ok but needs some improvement, we have some Macros that run to collect all the information entered on a form into a row of a a table, after that is complete we need the log to save a PDF version of the PO, similar to an invoice and automatically email it to a client. We also need a PDF version os the email PDF saved to a folder for accoiunting to use to reconcile invoices. there are a few other nuances that we would like, such as vendor management and insurance car tracking - with should be simple.