This code is part of a macro i have, that works great. 2 questions, the one i think i know but want to make sure
If I make read receipt FALSE, this will not ask for read receipt RIGHT?
Is there a way that i can place in the subject line the actual file name?
If I make read receipt FALSE, this will not ask for read receipt RIGHT?
Is there a way that i can place in the subject line the actual file name?
Code:
With oMail
.To = "ME@cbilling.com"
.To = Range("B1").Value
.CC = "you@billing.com"
.CC = Range("B2").Value
.ReadReceiptRequested = True
.ReadReceiptRequested = Range("B3").Value
.Subject = "File for " & Format$(Date, "mmm dd, yyy")
.Subject = Range("B4").Value
.Body = "Here is the shpping log"
.Body = Range("B5").Value
.Sensitivity = 3 'olConfidential = 3