Automate email with attachment - Excel
Budget: £20 – £250 GBP
I have a spreadsheet that contains data, I want a macro to filter out data based on a due date within the next 7 days and email that list of transactions to a set group of people.
Key data for the report sent by email
Column D - Company filter to only be "100"
Column O - Due date to be within the next 7 days of today
Column P - Paid to be "0"
Column R - Approval to be pending
Key data for the report sent by email
Column D - Company filter to only be "100"
Column O - Due date to be within the next 7 days of today
Column P - Paid to be "0"
Column R - Approval to be pending