MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Function MailPurchAlert(Amount As Variant, note As notesdocument, Action As String) Dim workspace As New NotesUIWorkspace Dim session As New notessession Dim db As NotesDatabase Set db = session.CurrentDatabase Dim item As NotesItem GROUP = note.MAILTO Set item = note.GetFirstItem("MAILTO") FUND = note.Fund(0) SETTLEDATE = Cstr(note.Date(0)) Purchase = Cstr(note.Purchase(0)) Redemption= Cstr(note.Redemption(0)) Cancel = Cstr(note.Cancel_1(0)) PurchaseOld = Cstr(note.Purchase_1(0)) RedemptionOld= Cstr(note.Redemption_1(0)) CancelOld = Cstr(note.Cancel_1(0)) 'Msgbox "purchalert" If Isempty(GROUP) Then ' do nothing Else 'Forall a In note.MAILTO ' Set item = note.getfirstitem("MAILTO") Set SendTo = New NotesName(a) Set NotifyDoc = New NotesDocument(Db) NotifyDoc.Form = "Memo" NotifyDoc.SendTo = SendTo.Abbreviated NotifyDoc.Subject = "A CHANGE to a Large $ Trade Notification" Set Body = New NotesRichTextItem(NotifyDoc, "Body") Msg = "Please note that the " & FUND & " fund will have a large dollar " & Action & " trade in the amount of " Body.AppendText(Msg) Body.AddNewLine(1) Msg = Amount & " on Settlement Date of " & SETTLEDATE & ". This represents a change in what was reported to you." Body.AppendText (Msg) Body.AddNewLine(2) Body.AppendText "To view more information regarding this large dollar trade notification, please review the " Body.AddNewLine(1) Body.AppendText "Summary page of the Large $ Trade Notification database. " Body.AddNewLine(2) Body.AppendText "Click here to go to the document: " Body.AppendDocLink Note, "Large Dollar" Body.AddNewLine(2) Body.AppendText "For questions regarding this trade notice, please contact the individual that submitted this notice via the Large Dollar Trade Notification database." Body.AddNewLine(2) Body.AppendText " For questions about the database, please contact your Admin." End If For x=0 To Ubound(item.values) Call notifyDoc.Send(False,item.values(x)) Print "Mail Send to: "&Cstr(item.values(x)) Next 'NotifyDoc.Send False 'End Forall End Function
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.