How to send mail from excel on a specified time

[StormVoogd]

hia

i want to save a excel worksheet and then send it as an attachment at a specified time....

i've got an tekstbox to show me the system time and at bv.
17.30 he has to save the excelsheet and send the sheet as an attachment by mail to one adres...

anyone any idear of how to do that...

Grtzzz...
chris govaarts

 

[leassaf]

See if this helps:

'This procedure must be run to set the start time of the next procedure that actually sends the entire workbook.

Sub SendMailOnSpecificTime()
Application.OnTime earliesttime:=TimeValue("23:06:00&quot, procedure:="NameOfProcedure"
End Sub


Sub NameOfProcedure()
With Application
.StatusBar = "Sending mail..."
.Dialogs(xlDialogSendMail).Show
.StatusBar = False
End With
End Sub