Generating an automated email with an Excel spreadsheet report summary.

Hi guys,

I'm trying to create a code in VBA that automatically generates an email in Outlook. There is a catch.

Within that email I need it to automatically generate diagnsotics summaries from each individual excel spreadsheet.
We use a program called Acumen Fuse for running health checks on our commercial projects. We track a projects performance from month to month schedule updating, or if a project is in a tender phase, we can run a health check to see if the project's schedule is up to standard.

The steps are.

1. Receive a project file.
2. Import it into Acumen Fuse.
3. Run various diagnotics checks and generate an excel report from the program.
4. Populate an email and give a summary for each individual diagnostics. E.g - Schedule Quality or Project Float (This i time consuming & I want to eliminate this as much as possible)
5. Attach the spreadsheets and send off to regional managers.


Could anyone please advise or help with creating this?

Attached are some examples of what i'm trying to accomplish.

I would greatly appreciate it.