Code to add today's date in subject line VBA
I found a nice bit of code for sending an email to a list
from within Excel. I am hoping that somebody can provide me with a bit more code to insert today's date in the subject line below.. so it would read "PET Allshort and Missort Report TODAY'S DATE" Thanks, Steve - Sub E_Mail() 'sends the activeworkbook to the e-mail address in a range named "list" in Sheet 'a sheet named E-Mail Dim MyArr As Variant MyArr = Sheets("Sheet1").Range("list") 'Will send with the subject send email.xls 'ActiveWorkbook.SendMail MyArr ActiveWorkbook.SendMail Recipients:=MyArr, _ Subject:="PET AllShort and Missort Report" 'Resets "look in" to my documents 'ChDir "C:\My Documents" End Sub |
All times are GMT +1. The time now is 01:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com