PDA

View Full Version : Lotus Notes - VBA



ChrisAch
06-08-2016, 09:20 AM
Sub pre plan email()
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
' Change the mail address and subject in the macro before you run it.
With OutMail
.To = "To:Name"
.CC = "NameA;NameB"
.BCC = ""
.Subject = "Subject header"
.body = "Good morning," & vbCr & vbCr


Dim sMsgBody As String
sMsgBody = sMsgBody & "Please kindly...." & vbCr & vbCr
sMsgBody = sMsgBody & "......" & vbCr & vbCr
sMsgBody = sMsgBody & "Kind Regards"
.body = sMsgBody

.Display
End With

End Sub


Hi All

I used to use the above code and adapt to generate an email etc.

However in my new role they use 'cough' lotus notes 'cough'

I cannot for the life of me, work out how to use the above and adapt to lotus notes, I have tried to overwrite object with lotus notes, but did not work.

Does anyone have any ideas?


Also, linked ...

If I wanted to call up one of my stationary lotus notes emails, but NOT send, can anyone point me in the right direction?

Thank you

Kenneth Hobs
06-09-2016, 08:52 AM
http://www.vbaexpress.com/forum/showthread.php?35917-Solved-Using-Excel-To-Send-Emails-Through-Lotus-Notes

Others:


http://www.rondebruin.nl/win/s1/notes/notes.htm


http://www.excelforum.com/excel-programming-vba-macros/949790-email-html-hotspot-from-lotus-notes-initialize-help-needed.html





http://www.mrexcel.com/forum/excel-questions/518746-send-range-rich-text-body-through-lotus-notes.html


http://www.mrexcel.com/forum/excel-questions/518746-send-range-rich-text-body-through-lotus-notes.html


http://www.ozgrid.com/forum/showthread.php?t=67089


http://www.alcs.ch/html-lotus-notes-email-including-html-signature-from-excel-with-vba.html#more-375


http://www.xtremevbtalk.com/showthread.php?t=320485


http://www-10.lotus.com/ldd/nd85forum.nsf/dba3ca7e515d55ff85256a0700727b35/95884ad3153d26e585257b790072eeb2?OpenDocument





Code for Domino:


http://www.redbooks.ibm.com/redbooks/pdfs/sg245670.pdf#page=23&zoom=auto,6,626