View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Send button in Excel

when you say form, do you mean using a worksheet to simulate a paper form?
or are you talking about a Userform that you create in the VBE?

for a worksheet

activesheet.copy
Activeworkbook.Sendmail ", Subject:="Report for
" & format(date,"mm/dd/yyyy")
Activeworkbook.Close Savechanges:=False



--
Regards,
Tom Ogilvy

"George" wrote in message
...
I want to make a form with in it a button to send that form to a

pre-choossen
mail address

Can someone help me?

Regards
George