Send mail automatically from access through Lotus Notes

[Nocturne]

Hi, Ineed very simple thing, but I could not find it anywhere on the net. I am using huge MS Access database and I want to creat a simple button, which would send email after clicking on it. There is only one address, no attachments. When I press this button, it should automatically send mail to this address. (I mean, that it should not only create an email in Lotus Notes, but send it right away. There should be no additional effort to push the button "send"). So, to sum up, I push the button in access, and email goes to address right away. Could someone pls help me? Thx.

[June7]

Google: Access VBA Lotus Notes

Review http://www.fabalou.com/VBandVBA/lotusnotesmail.asp

[Nocturne]

Hi, Ineed very simple thing, but I could not find it anywhere on the net. I am using huge MS Access database and I want to creat a simple button, which would send email after clicking on it. There is only one address, no attachments. When I press this button, it should automatically send mail to this address. (I mean, that it should not only create an email in Lotus Notes, but send it right away. There should be no additional effort to push the button "send"). So, to sum up, I push the button in access, and email goes to address right away. Could someone pls help me? Thx.

I know this link, but that code is to difficult for me. It uses mail address database, but I only one address to be sent. I need much simplier code.

[June7]

Strip out what you don't need. This is a simplistic example http://forums.aspfree.com/microsoft-...ro-447084.html

Doubt you will anything that exactly fits your situation. Have to adapt.