Ms access email through Lotus Notes

[Fixem2]

I am trying to use the following code to send an email to Lotus Notes
from A2K.
(Retrieved from Tony's excellent Access Email FAQ.)
http://www.fabalou.com/VBandVBA/lotusnotesmail.asp

I am trying to activate the VBA through a button on a form and I am
getting no response. I believe it is due to haveing the Public Sub
within the form, but when I convert to Private Sub I get the same,
lack of response. The error that I get for each test is :

"Member already exists in an object model from which this object
module derives."

Any help would be much appreciated.

Thanks,
Scott

[Herbert Chan]

What do you mean by "no response"? No newly sent mail in the Sent folder in
Lotus Notes client?

"Fixem2" <fi****@yahoo.com> ¦b¶l¥ó
news:d4*************************@posting.google.co m ¤¤¼¶¼g...

I am trying to use the following code to send an email to Lotus Notes
from A2K.
(Retrieved from Tony's excellent Access Email FAQ.)
http://www.fabalou.com/VBandVBA/lotusnotesmail.asp

I am trying to activate the VBA through a button on a form and I am
getting no response. I believe it is due to haveing the Public Sub
within the form, but when I convert to Private Sub I get the same,
lack of response. The error that I get for each test is :

"Member already exists in an object model from which this object
module derives."

Any help would be much appreciated.

Thanks,
Scott

[Scott LeMasters]

No Reponse means I don't get any error messages or any activity. Almost
like nothing is there.

Scott
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Herbert Chan]

Have you tried running the code manually by pressing F5? have you tested the
send Lotus Notes module before placing it as the click event for the button?

"Scott LeMasters" <fi****@yahoo.com> ¦b¶l¥ó
news:40*********************@news.frii.net ¤¤¼¶¼g...

No Reponse means I don't get any error messages or any activity. Almost
like nothing is there.

Scott
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Fixem2]

No I haven't done that yet. I am not really sure how to test the code
before inserting it into the VBA behind the form. Do I need to creat
a module and then test independently? I am new at this level of code
work in VBA, so my learning curve is a bit steep right now.

Thanks for all the help,
Scott
"Herbert Chan" <he*****@chan.com> wrote in message news:<40**********@rain.i-cable.com>...

Have you tried running the code manually by pressing F5? have you tested the
send Lotus Notes module before placing it as the click event for the button?

"Scott LeMasters" <fi****@yahoo.com> ¦b¶l¥ó
news:40*********************@news.frii.net ¤¤¼¶¼g...

No Reponse means I don't get any error messages or any activity. Almost
like nothing is there.

Scott
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Herbert Chan]

I think you'd better create a new module and test the Lotus Notes code there
first to make sure you know how to use it. Afterwards, if you place it as an
event for a button and it doesn't work, you know it's nothing to do with the
lotus notes code and this makes it easier for isolating the problems.
"Fixem2" <fi****@yahoo.com> ¦b¶l¥ó
news:d4**************************@posting.google.c om ¤¤¼¶¼g...

No I haven't done that yet. I am not really sure how to test the code
before inserting it into the VBA behind the form. Do I need to creat
a module and then test independently? I am new at this level of code
work in VBA, so my learning curve is a bit steep right now.

Thanks for all the help,
Scott
"Herbert Chan" <he*****@chan.com> wrote in message

news:<40**********@rain.i-cable.com>...

Have you tried running the code manually by pressing F5? have you tested the send Lotus Notes module before placing it as the click event for the button?
"Scott LeMasters" <fi****@yahoo.com> |b?l¢Do
news:40*********************@news.frii.net ?????g...

No Reponse means I don't get any error messages or any activity. Almost like nothing is there.

Scott
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!