Need a unique gift idea?
A Pastebin account makes a great Christmas gift
SHARE
TWEET

Untitled

a guest Jul 11th, 2018 62 Never
Upgrade to PRO!
ENDING IN00days00hours00mins00secs
 
  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