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:
Software/Hardware used:
ASKED:
June 23, 2009 8:20 PM
UPDATED:
June 24, 2009 5:25 PM
RELATED QUESTIONS
- Can I import my Outlook Express address book into OWA?
- Link to file in IFS - file not found error.
- How to access my boss personal address book when I am using vs6.5 and she is using vs8.5
- Should Lotus Notes Client be running or Open in background to send emails programatically using .NET through Lotus Notes Client?
- Opening Lotus Notes .NSF files
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
To see all answers submitted to the Answer Wiki: View Answer History.
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