Auto-create Lotus Notes email from Excel worksheet

Hi,

1. I've a workbook containing a Master sheet showing the daily bank receipt details for various construction projects (with project codes).
2. When the cursor stays on a line of receipt transaction, and clicking the button on top will trigger the below process
i) copy the receipt info from Master sheet to another ForEmail sheet on which the email will be based on.
ii) create an Outlook email notifying colleaques basing on ForEmail sheet (as a draft for checking or editing before sending out)

The below codes works fine but now I wish to change from Outlook to Lotus Notes, and I've no idea how to modify the codes.

Please Login or Register  to view this content.

Would like if someone could help.

Many thanks in advance.

Edward

Hi TMS,

Thanks for your prompt reply.
The existing codes that work well with Outlook had been obtained from the internet, but took me almost several months to modify bit by bit to make them completely suit my needs as I'm just accounting people without training in programming at all.

Before I post my problem, I've already searched the internet for related issues with Lotus Notes.

I've added some codes like below :

Please Login or Register  to view this content.

I just don't know why the above codes never work but got my computer frozen up each time I tested them.

Grateful if further assistance could be provided in modifying the codes.

Thanks again.

Edward