daily pastebin goal
16%
SHARE
TWEET

Untitled

a guest Jul 11th, 2018 59 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. .Subject = Title
  2. .to = Range("B2").Value  ' <-- Put email of the recipient here"
  3. .CC = "" ' <-- Put email of 'copy to' recipient here
  4. .Body = "Hi," & vbLf & vbLf _
  5.       & "Yr 7 701 EOT test attached in PDF format." & vbLf & vbLf _
  6.       & "Regards," & vbLf _
  7.       & "KDS ICT Dept" & vbLf & vbLf
  8. .Attachments.Add PdfFile
  9.  
  10. Application.Visible = True
  11. .Display
  12.    
  13. For Each cell In Range("A2:A250")
  14. If cell = Range("Results!B2").Value Then
  15. cell.Offset(0, 4).Activate
  16. ActiveCell.Value = Range("Results!B27").Value
  17. End If
  18. Next
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top