Outlook Express - Excel VBA
Posted on 2012-03-17
I have my code written to email a workbook to me, but I am confused on how to add additonal information to create a body message using a c.range.value. How do you set code to add body content.
It would be similiar to "Data was keyed by " & week1.Range("A1").value
Private Sub EMAILKNIERIM()
On Error GoTo NOSEND
Subject:="Daily Data #" & week1.Range("I1").Value
MsgBox ("NOT SENT SUCCESSFULLY - SEND MANUALLY AS AN ATTACHMENT")
My endusers are using OE 6.00 & Excel 2003.