This Repository contains two excel files with VBA macros, and a PHP file.
Send Email Sync Sheets Excel file contains two VBA macros. One connects to a Google Sheets doc, gets the data and prints it to the cells. The second macro sends an email to the addresses using a specified Docx file as the email body.
The "Email" excel file contains three macros. One scapes emails from Outlook. The other macro creates a Table in an SQL database, the third macro inserts the data to the SQL table the second macro created Index.php communicates with the SQL server and shows the data on the web