| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a cell value as the subject line
How do I use the cell value from cell a8 as the subject line in the following
code? More specifically the words "QA Snapshot" and "the value of cell (a8)" Private Sub Send1_Click() Dim strdate As String ActiveSheet.Copy strdate = Format(Date, "mm-dd-yy") ActiveSheet.Name = "QA Snapshot" ActiveWorkbook.SaveAs "QA Snapshot" & " " & strdate & ".xls" ActiveWorkbook.SendMail "", _ "QA Snapshot" ActiveWorkbook.ChangeFileAccess xlReadOnly Kill ActiveWorkbook.FullName ActiveWorkbook.Close False End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using a cell value as the subject line
ActiveWorkbook.SendMail "", _
"QA Snapshot" & Range("A8") -- Vasant "Qaspec" wrote in message ... How do I use the cell value from cell a8 as the subject line in the following code? More specifically the words "QA Snapshot" and "the value of cell (a8)" Private Sub Send1_Click() Dim strdate As String ActiveSheet.Copy strdate = Format(Date, "mm-dd-yy") ActiveSheet.Name = "QA Snapshot" ActiveWorkbook.SaveAs "QA Snapshot" & " " & strdate & ".xls" ActiveWorkbook.SendMail "", _ "QA Snapshot" ActiveWorkbook.ChangeFileAccess xlReadOnly Kill ActiveWorkbook.FullName ActiveWorkbook.Close False End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| email hyperlink - cell value in subject line | Excel Discussion (Misc queries) | |||
| hyperlink with cell info in subject line | Excel Discussion (Misc queries) | |||
| Export data in cell as the subject line in an email | Excel Worksheet Functions | |||
| How do I include cell data in subject line of email address/hyperl | Excel Worksheet Functions | |||
| Subject line in E-mail | Excel Programming | |||
Linear Mode
