View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mj mj is offline
external usenet poster
 
Posts: 78
Default VB code to generate an e-mail with an EXCEL attachment, but not se

I have the code to send directly an e-mail with the attached EXCEL document
(see below). However, I want to create the e-mail and allow the sender to
add additional info in the e-mail before sending it. Is there code for this?

Private Sub CmdSubmit_Click()
WhereTo = Range("K2")
SubjectText = "Example for " & Range("C3") & " - " & Range("C4")
ActiveWorkbook.SendMail Recipients:=WhereTo, Subject:=SubjectText

End Sub