View Single Post
 
Old 02-26-2021, 01:15 AM
JacquesW JacquesW is offline Windows 10 Office 2013
Novice
 
Join Date: Jan 2012
Posts: 21
JacquesW is on a distinguished road
Smile How to generate a Lotus Notes email with VBA code and thereafter open de LN client?

How to generate a Lotus Notes email with VBA code and thereafter open de LN client?
I have searched on the net to find VBA code to generate an email in Lotus Notes.

I only found code that generates mail attaches the current sheet or workbook and sends the mail.

The problem is that all these codes end with "Call Maildoc.send(False)".
And that immediately sends the message.

What I want th code to do is:
Attach the code to a button within an excel workbook/-sheet.
When the user klicks on it the mail wil be generated.
Instead of directly sending the mail I want it to open in Lotus Notes.
Purpose is that the sender can change the body and can add an attachment if necessary.

I hope somebody can help me with this.

Thanks in advance.
Reply With Quote