Forum Discussion
VBA Email for Excel - insert cell information into subject line
I am using the VBA code set out in the following site: https://www.simplilearn.com/tutorials/excel-tutorial/send-email-in-excel I have not included any of the CC/BCC or attachment options. The emai...
Change the line
NewEmailItem.Subject = "Test Email Demo”to
NewEmailItem.Subject = "Message for " & Range("A" & ActiveCell.Row).Valueor something similar.
Thanks Hans
I appreciate this, as I have no experience in writing VBA at all, and normally use what I find on the web to help me.
I will test this out.
Cheers
Ang
I appreciate this, as I have no experience in writing VBA at all, and normally use what I find on the web to help me.
I will test this out.
Cheers
Ang