Create an Excel Script (not vba) for Excel Online to import data from other files into an excel file and then send an email automatically.
Budget: $10 – $30 USD
The following tasks need to be automated in Excel online. You need to be familiar with 'Office Scripts' for Excel online (not vba for Excel Desktop).
1) Import data from 5 different files in to an Excel file. All the files are located in OneDrive
2) Send an email with selected sheets from the Excel file as attachment.
1) Import data from 5 different files in to an Excel file. All the files are located in OneDrive
2) Send an email with selected sheets from the Excel file as attachment.