Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Today's date as vertical line on a chart | Charts and Charting in Excel | |||
Populate the subject line. | Excel Worksheet Functions | |||
How to add line at today's date in chart | Excel Programming | |||
Subject line in E-mail | Excel Programming | |||
Code to Email with UNC in subject line | Excel Programming |