VBA code for opening an email in Lotus Notes and copying/pasting the To:, Subject: Email Body: which is stored in a sheet.

[CarlStephens]

Hello All,

I am pretty new to coding, and I was wondering whether there is a VBA code that will will open an email (in Lotus Notes that will already be open) and copy an email address and subject line stored in the spreadsheet, and paste the information in the respective email fields, along with the body of the email, which is in the spreadsheet too. An example of the spreadsheet is below:

Thank you for your time, and I shall look forward to hearing from you soon.

 

[John_w]

Thank you John. I am forever indebted to you. I am getting a syntax error below red line....do you know what the cause of this is?

View attachment 23430

Sorry, I deleted an ampersand on that line. It should be:

                   .InsertText vbLf & "File attached: " & Mid(Attachments(i, 1), InStrRev(Attachments(i, 1), "\") + 1)

 

[CarlStephens]

Thanks again John, you have helped immensely. Really you have!