Email Information in Lotus Notes

Hello Excel Gurus out there ...

I am creating a spreadsheet for work and I need it to do something that I just simply don't know how to do. It is possible, I think, as I've seen some similar macros.

WHAT I HAVE
I have is a workbook with several tabs. Each sheet is essentially a list where users can use a tick box to indicate whether or not they have completed particular items. Each item is worth a certain number of points and, at the bottom of each sheet, I have a field which adds up the total number of points for all checked items.

Finally, there is a summary page where the user enters their name and selects their manager from a list. This page also contains the number of points from each tab and then adds them to form a total.

All cells with important information have defined names.

WHAT I NEED
I need to have a button on the summary sheet which will email all the information to the users manager, cc'ing the user and bcc'ing another third party mailbox via Lotus Notes.


I thought of several ways to achieve this, but I don't know which is best, and I don't know where to start, including:

• macro to save a version of the file and attach that on an email; and
• macro to write an email using information in the named ranges.

Can anyone help?