5 pts.
 how do i get lotus to send email automatically
have scheduler task to open access program (works ok!), then access does a check to find overdue items then create a report to email (works ok!!) BUT when access opens lotus it attaches the report then sits there waiting for the user to click on send email?? I want the email to send with out the user clicking on send does en of the guys no how to do this?? some coding mayb for access???

Software/Hardware used:
ASKED: June 23, 2009  8:20 PM
UPDATED: June 24, 2009  5:25 PM

Answer Wiki:
Your question is not clear as to how you are automating this process. Are you using VBA to create the report in MS Access? How about to launch Lotus Notes and attach the report? Assuming that you are using VBA, then should have no trouble using the Send method in LotusScript. Here is an example from the Lotus Notes Developer Help. <pre> Dim session As New NotesSession Dim db As NotesDatabase Dim doc As NotesDocument Set db = session.CurrentDatabase Set doc = New NotesDocument( db ) doc.Form = "Memo" doc.SendTo = "Elissa Minty" doc.Subject = "Here's the document you wanted" Call doc.Send( False ) </pre> If you still have questions, post the code that you are using to add the report. Hope this helps
Last Wiki Answer Submitted:  June 24, 2009  3:05 pm  by  Wcdulanyjr   120 pts.
All Answer Wiki Contributors:  Wcdulanyjr   120 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Sounds like someone has “kluged” together a mixture of methods to create an email in the background and then open in the UI. They may even be using a COMPOSE function to open the message and targeting the fields to populate. Why even use the client? Just send a CDO thru your SMTP server. Is there a reason it is being passed to Notes?

Mike Kinder

 1,830 pts.