[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 721
  • Last Modified:

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
0
lehi52
Asked:
lehi52
  • 7
  • 4
1 Solution
 
Sjef BosmanGroupware ConsultantCommented:
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
0
 
lehi52Author Commented:
Thank you.
0
 
lehi52Author Commented:
Do you know if what I asking for is possible?  I would prefer to use what we have already.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Sjef BosmanGroupware ConsultantCommented:
Yes, it's possible, but some programming cannot be avoided. For the code, see the 2nd link I added above.
0
 
lehi52Author Commented:
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?
0
 
Sjef BosmanGroupware ConsultantCommented:
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!
0
 
lehi52Author Commented:
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.
0
 
lehi52Author Commented:
I can see this is going to be way over my head to figure out.
0
 
lehi52Author Commented:
Even with the code you posted.
0
 
Sjef BosmanGroupware ConsultantCommented:
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!
0
 
lehi52Author Commented:
Please deactivate this question.
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 7
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now