how do i get lotus to send email automatically
5 pts.
0
Q:
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???
ASKED: Jun 23 2009  8:20 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
110 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.



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 )



If you still have questions, post the code that you are using to add the report.


Hope this helps
Last Answered: Jun 24 2009  3:05 PM GMT by Wcdulanyjr   110 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

SlikTool   1220 pts.  |   Jun 24 2009  5:25PM GMT

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

 
0