Advertisement
Guest User

Untitled

a guest
Aug 24th, 2015
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. Dim StrEmail as String
  2. Select Case Me.cmbOwner2
  3. Case Is = "AV"
  4. If StrEmail Is Null Then
  5. StrEmail = "dan.moses@yahoo.com"
  6. Else
  7. StrEmail = StrEmail & "," & "dan.moses@yahoo.com"
  8. Case Is = "ENG"
  9. If StrEmail Is Null Then
  10. StrEmail = "brianna.cates@yahoo.com"
  11. Else
  12. StrEmail = StrEmail & "," & "brianna.cates@yahoo.com"
  13. End If
  14. End Select
  15.  
  16. DoCmd.SendObject acSendForm, "frmETIC", acFormatPDF, "StrEmail", "", "", "Recovery Report", "Attached is the submitted Recovery Report"
  17. DoCmd.Close acForm, "frmETIC", acSaveNo
  18. DoCmd.OpenForm "frmETIC", acNormal, , , acFormEdit, acWindowNormal
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement