VBA sends mail autofill Subject

[helpexcel]

Hi,

I have code that will automatically send and email of the spreadsheet that is open. The subject is populated using .Subject = "ABC File"
Is there a way to add in the contents of cell A11 to the subject line? I thought it would as simple as .Subject = "ABC File" & Range("A11") but that doesn't work. I tried a couple of other variations to no avail, so any help is appreciated.

Thanks.

 

[redspanna]

try...

.Subject = "ABC File" & Range("A11").value

 

[helpexcel]

Thanks, but it didn't work.

 

[redspanna]

Thanks, but it didn't work.

odd as works for me...
silly question (maybe) but, there is definitely a value in cell A11 ??

 

[faizankhan]

Hi,

I have code that will automatically send and email of the spreadsheet that is open. The subject is populated using .Subject = "ABC File"
Is there a way to add in the contents of cell A11 to the subject line? I thought it would as simple as .Subject = "ABC File" & Range("A11") but that doesn't work. I tried a couple of other variations to no avail, so any help is appreciated.

Thanks.

Try
.Subject = "ABC File" & worksheets("abc").Cells(11,1)
change the sheet name

 

[helpexcel]

@redspanna user error, it is working now. I did let it run through the full cycle before testing, so it was pulling blanks.

@faizankhan Thanks!!!

 

[redspanna]

you're welcome - glad you got it working