Code:
With OutMail
.to = "name@name.co.uk"
.CC = ""
.BCC = ""
.Subject = [COLOR=#ff0000]"Callback For" & Range("F1").Value[/COLOR]
.Body = "Hi there"
.Attachments.Add Destwb.FullName
However, the email comes up with no subject. I've also tried;
Code:
[COLOR=#ff0000]"Callback For" & Range("F1").Select[/COLOR]
Code:
[COLOR=#ff0000]"Callback For" & Range("F1")[/COLOR]
I can't see what I'm missing. Any help would be greatly appreciated