how do i get lotus to send email automatically

5 pts.
Tags:
Lotus Mail
Lotus Mail Scheduling
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???

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SlikTool
    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,840 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following