Forum Discussion

Ange-M_1973's avatar
Ange-M_1973
Copper Contributor
Jan 15, 2023

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...
excel
Macros and VBA
HansVogelaar's avatar
HansVogelaar
MVP
Jan 15, 2023

Ange-M_1973 

Change the line

NewEmailItem.Subject = "Test Email Demo”

to

NewEmailItem.Subject = "Message for " & Range("A" & ActiveCell.Row).Value

or something similar.

Ange-M_1973's avatar
Ange-M_1973
Copper Contributor
Jan 15, 2023
Hi Hans
thanks for your help, but I am still having trouble with this, as the adjustments did not work.

Cheers

Ang
    • Ange-M_1973's avatar
      Ange-M_1973
      Copper Contributor
      Jan 15, 2023
      The subject line says "Message for" and does not relate to the subject line.
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        Jan 15, 2023

        Ange-M_1973 

        I thought you wanted to take the name from column A in the row of the active cell.

        Your result make me think that that cell was empty.

Resources