Look up the contract PDF and capture its link

Each Contracts row links to its signed PDF in SharePoint via a stored URL. Theo needs to pull that document out so the notification email can include a working link to it.

The cheaper, safer pattern is to link rather than attach. A link respects SharePoint's permissions, shows the recipient the current version, and doesn't bloat the email. An attachment is a snapshot from when the email was sent and bypasses every access control.