Solved

attaching a file in an email notification

Posted on 2006-06-12
3
198 Views
Last Modified: 2013-12-18
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
Comment
Question by:varvoura
  • 2
3 Comments
 
LVL 63

Expert Comment

by:SysExpert
ID: 16885973
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
 
LVL 63

Assisted Solution

by:SysExpert
SysExpert earned 250 total points
ID: 16885991
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
 
LVL 5

Accepted Solution

by:
pgloor earned 250 total points
ID: 16886353
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now