Hi all Guru, I have created a button which emails the addresses as shown
below, what i would prefer if i could have it so that it emails what ever
email address is in cell B10, instead of having set email addresses.

Please Help.

On Error Resume Next
With OutMail
.To = ; "
.CC = ""
.BCC = ""
.Subject = "Sub Contract Submission please check"
.Body = "file:///M:\Procurement\Sub%20Contract%20Submissions\"
.send
'.send

End With