I’d like to generate an email reminder to specific users on a bi-weekly basis reminding them to submit their timesheets. I’ve attempted an agent but haven’t had much luck establishing a schedule.
Has anyone had any luck with this?
Thanks in advance for your help!
Christine Russell
Subject: email reminder
Run the agent weekly, but start the agent with a “what week is this” check. A simple LotusScript version might look like this:
Sub Initialize
Dim BaseDate As Variant
BaseDate = DateNumber(2008, 1, 1)
If ((Today - BaseDate) Mod 14 = 0) Then
Exit Sub
End If
The base date would be a known “good sending” day.
Subject: RE: email reminder
I’ll give that a try - should the target be set to All documents in the database?
Thanks again Stan!
Subject: RE: email reminder
“All documents” sounds about right.
Subject: RE: email reminder
Stan - please excuse my lack of Lotuscript knowledge - I’m receiving an unterminated SUB block error How to I end this??
Sub Initialize
Dim BaseDate As Variant
BaseDate = DateNumber(2008, 1, 1)
If ((Today - BaseDate) Mod 14 = 0) Then
Exit Sub
End If
Subject: RE: email reminder
That depends on exactly what you need the agent to do. The error is happening because there is no “End Sub” statement, but simply adding that line won’t help a whole lot. I know that you want to send some users a reminder to submit their timesheets, but that’s the extent of what I know. Can you tell me where you are getting the names from, and what the message should say?
Subject: RE: email reminder
What I’d like my agent to do is send an email every other the week to employees reminding them submit their timesheets. I’ve created an electronic timesheet database employees use to submit their timesheets that uses a custom built workflow for an approval process. This is where I placed my agent in the shared code area.
I’ve created a group in our public addressbook of the users it needs to notify.
Seems like it should be simple, but not for me!
Thanks again for your help!
Subject: RE: email reminder
P.S.
I was originally using a simple action - but my choices when to send were limited to daily, weekly, monthly
Subject: RE: email reminder
I guess I should have been more specific. I would need to know (at the very least) one date on which a reminder needs to be sent and where in the database the user names to send to are stored. The text of the mailing would be a nice-to-have as well. If you have been using a simple action, you were probably hard-coding the names, but that would mean having to change the code whenever there’s a shift in personnel.
Subject: RE: email reminder
Sorry Stan - a date that I would need the email reminder sent out on would be on a Monday - so 4/21, then again on 5/5, every other Monday. When I was using a simple action I was able to access my Public addressbook where I created a group that contained all my my timesheet users. I suppose I could create a role directly in the database and assign the group to that role if need be.Again - thanks for you patience & help - Christine