VBA to send email via Lotus Notes + attachment

Hello,

Any idea if I can send a Lotus Notes email WITH attachment via Excel VBA code?

I know that I can send a normal mail via Lotus Notes, but absolutely no idea if it can be done with an attachment.

The process with the current macro:

1. The macro creates a new worksheet.
2. The macro copypastes information from the main worksheet into the new blank one.
3. The macro creates a new workbook out of that newly created worksheet and deletes the newly created worksheet from the mother file.
4. The macro saves the new workbook.

I would like the macro to send the file as attachment automatically to specific email address in point 4.


Help much appreciated since I'm on a thin ice here with the code..