We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
4 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
@mailsend sending multiple emails in scheduled agent
Posted on 2007-12-06
Hi,
I am trying to use @mailsend in a scheduled agent.
I am working accept for one problem...
The @mailsend is sending an email for each document. I only want it to send 1 email!
Basically I am using @elements and if the view contains more than 100 documents based on certain criteria a single email should be sent.
Currently if 48 documents match this criteria, 48 emails are sent.
How can I ensure that only 1 email is sent.
Thanks!
I am trying to use @mailsend in a scheduled agent.
I am working accept for one problem...
The @mailsend is sending an email for each document. I only want it to send 1 email!
Basically I am using @elements and if the view contains more than 100 documents based on certain criteria a single email should be sent.
Currently if 48 documents match this criteria, 48 emails are sent.
How can I ensure that only 1 email is sent.
Thanks!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
2
2
9 Comments
Hi Bill,
very kind of you. Are you sure we can't do something clever with the formula below?
body := "this database needs attention etc."
@If(@Elements(@DbColumn(""
@MailSend("some.address@so
@Return(""))
Thanks!
very kind of you. Are you sure we can't do something clever with the formula below?
body := "this database needs attention etc."
@If(@Elements(@DbColumn(""
@MailSend("some.address@so
@Return(""))
Thanks!
Hi madheeswar,
this would make sense, but you can't have a scheduled agent with a target of "none" or can you?
this would make sense, but you can't have a scheduled agent with a target of "none" or can you?
Sorry..it was my mistake.
For Scheduled agents you cannot have none.
Since it's my fault, use this code....Tested and it is working. Make it a Scheduled agent and run on all documents. Provide your email in tmpname..
For Scheduled agents you cannot have none.
Since it's my fault, use this code....Tested and it is working. Make it a Scheduled agent and run on all documents. Provide your email in tmpname..
Sub Initialize
Dim ss As New NotesSession
Dim db As NotesDatabase
'Dim view As notesview
'Dim dc As NotesDocumentCollection
'Dim doc As NotesDocument
Dim maildoc As NotesDocument
Set db=ss.CurrentDatabase
tmptotal = Evaluate(|@Elements(@DbColumn("";"";"List";1))|)
If Isempty(tmptotal) Or tmptotal(0) < 100 Or tmptotal(0)="" Then Exit Sub
'Send email:
Set maildoc = New NotesDocument( db )
maildoc.Form = "Memo"
maildoc.Subject = "Reminder: Please Review New Application"
Set Body=New NotesRichTextItem(maildoc,"Body")
message="Please Review the New Application"
Call Body.AppendText(message)
Call Body.AddNewLine(2)
tmpname = "Your Mail addess"
Call maildoc.Send( True, tmpname )
End Sub
Featured Post
Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster. I've had to exercise t…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Suggested Courses
Course of the Month4 days, 8 hours left to enroll
689 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.