Send Mail & Lotus Notes

[michaeldh]

Mr Excel,

I know how to send mail using Outlook directly from an Excel spreadsheet (not hard to do). However, I cannot get it to work when using Lotus Notes.

Is there a way to ActiveWorkbook.Sendmail with Lotus Notes.

Thanks.

Michael.

 

[XL-Dennis]

Michael,

I´ve been working with several project involving Lotus Notes and the "lifesaver" for me was:

http://www.fabalou.com/VBandVBA/vbandvbastuff.htm

Kind regards,
Dennis

 

[NateO]

Howdy, Dennis has provided a good link. A few other thoughts with this code, you'll want the active workbook to be saved and you'll want to set the attachment as:

<pre>
Attachment = ActiveWorkbook.FullName</pre>

Also, if you want the message to be saved in your sent folder you'll want to change:

<pre>
MailDoc.SAVEMESSAGEONSEND = SaveIt

to

MailDoc.SAVEMESSAGEONSEND = True</pre>

 

[KristineK]

Re: Send Mail & Lotus Notes

Hi there,

I came across this thread as I basically have the same exact question as the original poster. Unfortunately, the link leads to a page which no longer exists. Is there anyone out there who has a solution to the question?