We have a main excel spreadsheet with a lot of data which we want to condense down into a simple monthly order that is automatically populated into MS outlook ready to send to our clients. This will be done through the use of Macros ideally as these reports will be run every month. Each macro's task is listed below:
Macro 1 - This macro will condense all the data from the main spreadsheet into the small order table ready for input into MS Outlook.
Marco 2 - This will push the order table into outlook and needs to be selective so we can pick and chose which customers to send this to.
Attached is a workflow example of what is required.