Forum Discussion
Ange-M_1973
Jan 15, 2023Copper Contributor
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...
HansVogelaar
Jan 15, 2023MVP
Change the line
NewEmailItem.Subject = "Test Email Demo”
to
NewEmailItem.Subject = "Message for " & Range("A" & ActiveCell.Row).Value
or something similar.
Ange-M_1973
Jan 15, 2023Copper Contributor
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