lehi52
asked on
How do you click a button to fill in an email from access to lotus notes
I have this CRM database I am trying to create. I am real beginner so any help would be appreciated. I would like something in access where when we click a button in access it opens lotus notes, and puts in the person its going to, the subject, the body of the email and any attachments if needs be.
How do you do something like this? Like I mentioned I am a beginner. I am not a programmer so any help would be great.
1.accdb
How do you do something like this? Like I mentioned I am a beginner. I am not a programmer so any help would be great.
1.accdb
ASKER
Thank you.
ASKER
Do you know if what I asking for is possible? I would prefer to use what we have already.
Yes, it's possible, but some programming cannot be avoided. For the code, see the 2nd link I added above.
ASKER
Becuase I don't know code much. If I add a button to my form do I attach that code to the button. Then when I click the button will that automatically go the person that is showing on the form?
Oh no, the code is just part of what you have to add, there's more.
Earlier projects that touch the same idea:
- https://www.experts-exchange.com/questions/27941580/Excel-VBA-send-Mail-from-OPEN-Lotus-Notes-Without-input.html
- https://www.experts-exchange.com/questions/27944423/Lotus-Notes-mail-sent-from-excel-vba-won't-save-sent-mail.html
- https://www.experts-exchange.com/questions/28180422/Unable-to-send-mail-from-Lotus-notes-8-5-with-excel-vba.html
PS Unfortunately for you, this is not a "rent-a-coder" site, we're not going to develop your code for you. The idea is that we help you with your own code, kindly pushing you in the right direction while you're learning and developing.
Good luck!
Earlier projects that touch the same idea:
- https://www.experts-exchange.com/questions/27941580/Excel-VBA-send-Mail-from-OPEN-Lotus-Notes-Without-input.html
- https://www.experts-exchange.com/questions/27944423/Lotus-Notes-mail-sent-from-excel-vba-won't-save-sent-mail.html
- https://www.experts-exchange.com/questions/28180422/Unable-to-send-mail-from-Lotus-notes-8-5-with-excel-vba.html
PS Unfortunately for you, this is not a "rent-a-coder" site, we're not going to develop your code for you. The idea is that we help you with your own code, kindly pushing you in the right direction while you're learning and developing.
Good luck!
ASKER
That is not a problem. I just want to get the help to be able to do this. SO if you can guide me in the right direction that is fine. I've coded before, but it was in HTML. Ill take a look at what you posted. I appreciate you helping.
ASKER
I can see this is going to be way over my head to figure out.
ASKER
Even with the code you posted.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Please deactivate this question.
Ah, that's not what you intend to develop... Ok.
Here's one of the many examples of how to send a mail via Notes: http://www.fabalou.com/vbandvba/lotusnotesmail.asp