By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,571 Members | 994 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,571 IT Pros & Developers. It's quick & easy.

Ms access email through Lotus Notes

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
5 Replies


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

"Fixem2" <fi****@yahoo.com> 在郵件
news:d4*************************@posting.google.co m 中撰寫...
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

Nov 12 '05 #2

P: n/a

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!
Nov 12 '05 #3

P: n/a
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> 在郵件
news:40*********************@news.frii.net 中撰寫...

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!

Nov 12 '05 #4

P: n/a
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> 在郵件
news:40*********************@news.frii.net 中撰寫...

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!

Nov 12 '05 #5

P: n/a
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> 在郵件
news:d4**************************@posting.google.c om 中撰寫...
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¥o
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!

Nov 12 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.