View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James T James T is offline
external usenet poster
 
Posts: 14
Default SendMail and User Input & OutLook Express

I am using the following to send the current worksheet to clients, and it is
great - using Outlook Express:

Sub mail2()
ActiveWorkbook.SendMail (Range("a1")), (Range("a2"))
End Sub

However just wondering if there is a way to have the email come up and allow
me to enter in data before it is actually sent.

Regards