N
Neil Holden
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 = "(e-mail address removed); (e-mail address removed)"
.CC = ""
.BCC = ""
.Subject = "Sub Contract Submission please check"
.Body = "file:///M:\Procurement\Sub%20Contract%20Submissions\"
.send
'.send
End With
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 = "(e-mail address removed); (e-mail address removed)"
.CC = ""
.BCC = ""
.Subject = "Sub Contract Submission please check"
.Body = "file:///M:\Procurement\Sub%20Contract%20Submissions\"
.send
'.send
End With