Guest User

Untitled

a guest
Aug 17th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.45 KB | None | 0 0
  1. Outlook Redemption accessing delegated accounts with MS Outlook connected to gmail (google apps)
  2. Private Function SendEmail(ByVal sEntity As String, ByVal sMsg As String, _
  3. ByVal sRef As String) As Boolean
  4. Try
  5. Dim strMsg As String = ""
  6. Dim session As Redemption.RDOSession
  7. session = New Redemption.RDOSession
  8. session.Logon("Outlook")
  9.  
  10. Dim addrList As Redemption.RDOAddressList
  11. Dim AE As Redemption.RDOAddressEntry
  12. Dim Drafts As Redemption.RDOFolder
  13. Dim account As Redemption.RDOAccount
  14. If My.Settings.Local = 1 Then
  15. AE = session.AddressBook.GAL.AddressEntries("user1")
  16. Drafts = session.GetSharedDefaultFolder("user1", Redemption.rdoDefaultFolders.olFolderDrafts)
  17. account = session.Accounts("user1")
  18. Else
  19. AE = session.AddressBook.GAL.AddressEntries("user2")
  20. Drafts = session.GetSharedDefaultFolder("user2", Redemption.rdoDefaultFolders.olFolderDrafts)
  21. account = session.Accounts("user2")
  22. End If
  23.  
  24. Dim mailItem As Redemption.RDOMail
  25. mailItem = Drafts.Items.Add
  26. mailItem.Account = account
  27.  
  28. Dim dt As DataTable
  29. dt = New DataTable
  30. dt = DAC.ExecuteDataTable("GetEmailRecipForConfo_sp", _
  31. DAC.Parameter("EntityID", sEntity))
  32. For Each dr As DataRow In dt.Rows
  33. mailItem.Recipients.Add(dr("Email").ToString)
  34. Next
  35.  
  36. mailItem.Recipients.ResolveAll()
  37. If Not mailItem.Recipients.ResolveAll Then
  38. mailItem.Display()
  39. End If
  40.  
  41. Dim tmp As Object = mailItem.GetInspector
  42.  
  43. mailItem.BodyFormat = OlBodyFormat.olFormatPlain
  44.  
  45. mailItem.Subject = "(" & sRef & ") " & sEntity & " FX CONFIRMATIONS " & _
  46. Format(Now, "HH:mm:ss")
  47. mailItem.Body = sMsg
  48. mailItem.SentOnBehalfOfName = "user1@domain.co.nz"
  49.  
  50. If My.Settings.Local = 1 Then
  51. mail.SaveSentMessageFolder = session.GetSharedDefaultFolder("user1", Redemption.rdoDefaultFolders.olFolderSentMail)
  52. Else
  53. mail.SaveSentMessageFolder = session.GetSharedDefaultFolder("user2", Redemption.rdoDefaultFolders.olFolderSentMail)
  54. End If
  55. mailItem.Sender = AE
  56. mailItem.SentOnBehalfOf = AE
  57. mailItem.Save()
  58. mailItem.Send()
  59.  
  60. session.Logoff()
  61. Return True
  62. Catch ex As SystemException
  63. 'Log error.....
  64. Return False
  65. End Try
  66. End Function
Add Comment
Please, Sign In to add comment