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.
26 freelancers are bidding on average $364 for this job
Have worked on several similar [url removed, login to view] in VBA and Scripting Relevant Skills and Experience VBA,VBS,Windows,C#.NET Proposed Milestones $343 AUD - VBA
I'll do it via Ms Access GUI with Excel automation Relevant Skills and Experience vba, ado, sql, excel object model Proposed Milestones $777 AUD - default