Prev: Excell copy action pauses for 15 second for the smallest action
Next: How to stop: Microsoft XLS is locked for editing in 2003 Excel
From: Neil Holden on 28 Jan 2010 11:20
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 = "neil.holden(a)test.com; david.cope(a)test.com"
.CC = ""
.BCC = ""
.Subject = "Sub Contract Submission please check"
.Body = "file:///M:\Procurement\Sub%20Contract%20Submissions\"
.send
'.send

End With
 | 
Pages: 1
Prev: Excell copy action pauses for 15 second for the smallest action
Next: How to stop: Microsoft XLS is locked for editing in 2003 Excel