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

lehi52

Asked: 2014-01-24

Advertise Here

1 Solution

LVL 46

Sjef BosmanGroupware ConsultantCommented: 2014-01-24

If I were in your shoes, I'd get a (free) CRM in Notes, e.g. http://www.openntf.org/main.nsf/project.xsp?r=project/VIC%20CRM%20for%20Notes
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

lehi52Author Commented: 2014-01-28

Thank you.

lehi52Author Commented: 2014-01-28

Do you know if what I asking for is possible? I would prefer to use what we have already.

LVL 46

Sjef BosmanGroupware ConsultantCommented: 2014-01-28

Yes, it's possible, but some programming cannot be avoided. For the code, see the 2nd link I added above.

lehi52Author Commented: 2014-01-29

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?

LVL 46

Sjef BosmanGroupware ConsultantCommented: 2014-01-29

Oh no, the code is just part of what you have to add, there's more.

Earlier projects that touch the same idea:
- http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27941580.html
- http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/Lotus_SmartSuite/Lotus_Notes/Q_27944423.html
- http://www.experts-exchange.com/Programming/Theory/Q_28180422.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!

lehi52Author Commented: 2014-01-29

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.

lehi52Author Commented: 2014-01-30

I can see this is going to be way over my head to figure out.

lehi52Author Commented: 2014-01-30

Even with the code you posted.

LVL 46

Sjef BosmanGroupware ConsultantCommented: 2014-01-30

That's what I guessed already... which is why I suggested to adopt a ready-made CRM. Maybe you should leave this point for a while, until you gained enough experience to do it yourself or ask a developer in your neighbourhood to do exactly what you want. I hope that'll be soon! Good luck!

lehi52Author Commented: 2014-02-05

Please deactivate this question.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Expand your skills with this month's free Premium course.

How do you click a button to fill in an email from access to lotus notes

Join & Write a Comment Already a member? Login.

Featured Post