need code to insert cell value

S

Steve

I would like some help to insert a cell value into the
code attached below. I need the value from Sheet1 cell
C24 after the word Allshort. I need it in parenthesis.

ActiveWorkbook.SendMail Recipients:=MyArr, _
Subject:="PET AllShort and Missort Report" &
format$(Date, " mm-dd-yyyy")

Thanks, Steve
 
T

test

Try this:

ActiveWorkbook.SendMail Recipients:=MyArr, _
Subject:="PET AllShort (" & ActiveWorkbook.Sheets(1).Range("C24") & ") and
Missort Report" & _
format$(Date, " mm-dd-yyyy")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to add today's date in subject line VBA 2
Save/ Send as webpage ? 1
Sendmail with a named cell value as recipient 2
sendmail to variable 2
Using a cell value as the subject line 1
Sending mail to different mail address based on cell value 3
assign the formatted cell value (date) to another cell? 3
Need to get cell address next to current address 2

Top