[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 205
  • Last Modified:

attaching a file in an email notification

Hi all,

Not sure if this can be done, but it will be great if someone can clarify this for me.

I know that I can send a notification with a link to a specific view in db, but it is possible to also create that view in a spreadsheet report and send that in the same email.
I am trying to give users the 2 options, either to select the link to go back to view or to click on the embedded object in this case excel spreadsheet to render the report in excel without going back to db with the view link.

Thank you in advance.
Varvoura
0
varvoura
Asked:
varvoura
  • 2
2 Solutions
 
SysExpertCommented:
I do not thnk that you will be able to embesd this in Excel as a normal link.

A browser link or a Notes URL link may work
I hope this helps !
0
 
SysExpertCommented:
Here are some sample Notes URLs

    * notes://servername/databaseName?OpenDatabase or notes://servername/__dbReplicaID?OpenDatabase for a database
    * notes://servername/databaseName/viewName?OpenView or notes://servername/__dbReplicaID/viewUNID?OpenView for a view
    * notes://servername/databaseName/formName?OpenForm or notes://servername/__dbReplicaID/formUNID?OpenForm for a form
    * notes://servername/databaseName/0/documentUNID?OpenDocument or notes://servername/__dbReplicaID/0/documentUNID?OpenDocument for a document

notes://Servname/85256B6B0072D42D/0/1AF5AA62EF689C21852570CA005D8F16              No Seperators for Hex Numbers.

I hope this helps !
0
 
pgloorCommented:
This can be done with LotusScript. Your script will look something like this:

      Dim session As New NotesSession
      Dim db As NotesDatabase
      Dim doc As NotesDocument
      
      Dim rtitem As NotesRichTextItem
      Dim object As NotesEmbeddedObject
      Set db = session.CurrentDatabase
      Set doc = New NotesDocument( db )
      
      Set rtitem = New NotesRichTextItem( doc, "Body" )
      doc.Form = "Memo"
      doc.SendTo = "Peter Gloor"
      doc.Subject = "Your report"
      Call rtItem.AppendText("See your report in Notes ")
      Call rtItem.AppendDocLink(doc,"","") ' points to the stored copy of this document in this examle
      Call rtItem.AddNewline(1)
      Call rtItem.AppendText("...or open the attached excel file...")      
      Call rtItem.AddNewline(1)
      Set object = rtitem.EmbedObject( EMBED_ATTACHMENT, "", "c:\sample.xls")
      Call doc.Save( True, True )
      Call doc.Send( False )

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now