Outlook Macros or VBAs and Google Sheet - Automation Assistance Required
Budget: £20 – £250 GBP
We use Google Sheets and Microsoft Outlook as our main applications. I am looking for someone to automate a script so that it does the following.
1. Collects the data from Google Sheet across the row of the selected cell from column D to X.
2. Opens up new email in Outlook and inserts a pre-saved Quick Part "known as SUP1" and pastes the data from Google Sheet into this Quick Part table.
3. Additional preferable extras would be that the automation populates who the email is being sent to based on the data in Column N (using some sort of Vlookup function) and also populates the Subject of the email which is a string of 3 pieces of data from Column F, J and X.
Screenshots below show what we are looking to have with data filled in where highlight is shown.
If there are more robust / simpler solutions available I'm also happy to look at these options?
1. Collects the data from Google Sheet across the row of the selected cell from column D to X.
2. Opens up new email in Outlook and inserts a pre-saved Quick Part "known as SUP1" and pastes the data from Google Sheet into this Quick Part table.
3. Additional preferable extras would be that the automation populates who the email is being sent to based on the data in Column N (using some sort of Vlookup function) and also populates the Subject of the email which is a string of 3 pieces of data from Column F, J and X.
Screenshots below show what we are looking to have with data filled in where highlight is shown.
If there are more robust / simpler solutions available I'm also happy to look at these options?
Related categories:
Visual Basic
Visual Basic for Apps
Microsoft Outlook
Google Sheets
Google Spreadsheets