Lotus Notes create script to send calendar in email

55 pts.
Tags:
Lotus calendar
Lotus email
Lotus Notes 5.x
Lotus Notes 6.x
LotusScript
is this possible?

Answer Wiki

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

I think it could be, but would need to know more specifically what you are trying to do. For example, is this a Notes email to another Notes user? Is it a full calendar with a calendar entry and such? There are many ways to do it conceptually – more specifics are necessary.

Mike Kinder
mkinder@acadiasolutions.com

Discuss This Question: 7  Replies

 
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
  • YmdkC
    email would be lotus user to another lotus user calendar has entries would like email to be automatically sent daily without interaction from originator ((( kinda like a rule ))) Thanks for your help Ymdkc ymdk@aol.com
    55 pointsBadges:
    report
  • YmdkC
    formula/script to send calendar in pdf format in email to several people daily Lotus 6.54 need 1.. calendar pdf format (or another format that would be readable in email via blackberry) 2. sent to several people in email at least once a day 3. same people each time 4. managers would like to receive in email daily to view when away from office using blackberry 5. they have several calendars that they need access to daily & unable to send more than one calendar to blackberry. Thanks is it possible?
    55 pointsBadges:
    report
  • SlikTool
    Not to be overly analytical, but I have one more question - in 3 parts. The format of said calendar, is it suppose to look like a calendar (like the monthly view or weekly view where you see the entry and a summary in a structured format)? Or do you mean you want calendar entries from more than one calendar to appear in the BB calendar of multiple users(a blending of calendar entries in the one BB calendar)? Or, I just realized one other possibility - do you just want a summary of calendar entries for a single day from each of the extra calendars sent in an email to be looked over? The latter one can easily be done, the 2nd one would likely create havoc and a mess (but sometimes customers ask for the strangest things), and it could be done. The first option would likely be difficult, but perhaps could be done as you suggest, in an attachment format that supports the kind of structure you would be looking for. I would love to help on a consulting basis if you need it, just let me know which one you are trying to do and if you need more assistance in a general way, or direction, or whatever. Mike Kinder
    1,840 pointsBadges:
    report
  • YmdkC
    The format of said calendar, is it suppose to look like a calendar (like the monthly view or weekly view where you see the entry and a summary in a structured format)? This would work Or do you mean you want calendar entries from more than one calendar to appear in the BB calendar of multiple users(a blending of calendar entries in the one BB calendar)? No ... thankfully Or, I just realized one other possibility - do you just want a summary of calendar entries for a single day from each of the extra calendars sent in an email to be looked over? this would work also Basically, I think the managers would be happy if they could view in an email what is going on for each calendar. (( while they are out of office )) SOO>.. if there is a way to send a summary for a single day/week that would work for themThanks Ymdkc
    55 pointsBadges:
    report
  • YmdkC
    Still trying to find way to do this ... any suggestions?? Thanks
    55 pointsBadges:
    report
  • Brooklynegg
    I don't know your time horizon for the work or the full requirements, but Notes 8.5 is coming out pretty soon and has the coolest calendar federation feature. A user can choose from a number of calendar sources and see calendar items from a group calendar and have them color coded so they know they are not actually part of their own calendar's appointments. The source calendars could be Notes, Google, etc. The calendars can be selected and deselected easily in a side pane. What you are trying to do probably would be best done as an html formatted email. You could probably find example code for that. I've never done it.
    3,845 pointsBadges:
    report
  • SlikTool
    Hi, your original question was - can this be done. The answer is yes. I can write the code for you but it will take a fair amount of time. I am not trying to be unhelpful here, but I am a consultant - time is literally money. The best I can offer is this. Use a an agent (in the database that houses the calendars that are forwarding information to the other mailboxes), that uses Lotus Script. Have that agent connect to the Calendar view, collect the documents for the day in question (likely the current day as you should have it run after midnight every day). For the collection (NotesViewEntryCollection) process each document by grabbing the startdatetime, enddatetime, and subject fields. These values can easily be added to a new documents BODY (a NotesRichTextItem field) and thus be sent out of an email. Dim session As New NotesSession Dim db As NotesDatabase Dim n As Long Dim view As NotesView Dim nvec As NotesViewEntryCollection Dim ventry As NotesViewEntry Dim mailDoc As NotesDocument Dim rtitem As NotesRichTextItem Dim dt As New NotesDateTime("11/21/2008") Set db = session.currentdatabase Set view = db.getview( "CalSummary" ) 'use Calendar summary as it is easier Redim sendToList (0 To 1) As String sendToList(0) = "RECIPIENT NAME/ORG" sendToList(1) = "RECIPIENT NAME/ORG" Set nvec = view.getallentriesbykey( dt.dateonly, True ) Set mailDoc = db.createdocument() 'creates a document to use for mailing mailDoc.Form = "Memo" If nvec.count = 0 Then mailDoc.Subject = "No Activities Scheduled for ENTER CALENDAR NAME HERE today. <eom>" Else With mailDoc .Subject = "Activity list for ENTER CALENDAR NAME HERE for " & dt.DateOnly Set rtItem = New NotesRichTextItem( mailDoc, "Body" ) For n = 1 To nvec.count Set ventry = nvec.GetNthEntry(n) If n = 1 Then Call rtItem.AppendText( ventry.ColumnValues(3) & " - " & ventry.columnvalues(5) & " " & ventry.columnvalues(7) ) Else Call rtitem.AddNewline(2) Call rtItem.AppendText( ventry.ColumnValues(3) & " - " & ventry.columnvalues(5) & " " & ventry.columnvalues(7) ) End If Next End With End If Call mailDoc.send(False, sendToList)
    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