Subject heading in CDO message

Hi All

I have a macro which sends an email using CDO. I want to change the hard coded subject and replace it with text from a cell in the active worksheet. Also is it possible to receive a delivery receipt??

Thanks for your help!!!

With iMsg
Set .Configuration = iConf
.To = "[email protected]"
.CC = ""
.BCC = ""
.From = """Site Engineer"" <[email protected]>"
.Subject = "Site Fault Codes"
.TextBody = "Monthly Fault Codes Attached"
.AddAttachment TempFilePath & TempFileName & FileExtStr
.Send
End With

I am not familiar with CDO? What is it?

However, there I dont see any reason why you couldn't set a varialbe equal to the value of a particular cell or ActiveX control such as a textbox or combo box.

Have you tried setting the subject equal to value of a variable? If this works you could also set the To/CC/BCC fields equal to addresses specified in your sheet or even pass in the filepath and name of the attachment (and validate that it exists before calling the send functionality)...

Please Login or Register  to view this content.