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

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?

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

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

Still trying to find way to do this … any suggestions?? Thanks

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.

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)