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..