How to send excel file automatically through outlook on specific time daily.

Dear All,
please teach me that How to send excel file automatically through outlook email on specific time daily. Excel file should send as attachment on email id ([email protected]).
please share if someone can write VBA code for same.\\\\ thanks in advance.

You would need too run a windows scheduler to open a excel file and in this excel file write a macro to send email.

you can use below resource to see how to email using excel file

http://www.rondebruin.nl/win/s1/outlook/amail6.htm


Regards
GetWorkDone

'Stay in the outbox untill this date and time
.DeferredDeliveryTime = "1/6/2007 10:40:00 AM"

'Wait four hours
.DeferredDeliveryTime = DateAdd("h", 4, Now)

Originally Posted by GetWorkDone

You would need too run a windows scheduler to open a excel file and in this excel file write a macro to send email.

you can use below resource to see how to email using excel file

http://www.rondebruin.nl/win/s1/outlook/amail6.htm


Regards
GetWorkDone

THANK YOU VERY MUCH FOR HELP,
is it posible that mail send automatically on a specific time daily?

Add this to the code:

'Stay in the outbox untill this date and time
.DeferredDeliveryTime = "1/6/2007 10:40:00 AM"
'Wait four hours
.DeferredDeliveryTime = DateAdd("h", 4, Now)

Originally Posted by ashok155

THANK YOU VERY MUCH FOR HELP,
is it posible that mail send automatically on a specific time daily?

Based on link provided earlier you create a procedure in VBA to send email. Once done follow below steps to automate it.

1. Set procedure to run as soon as excel is opened (Use below code in "This Workbook Module" in VBA) Replace SendEmail with your Procedure. This will run your procedure and then close your excel.
Private Sub Workbook_Open()
Call SendEmail
Application.Quit
End Sub
2. Once you have automated auto run of Procedure using windows scheduler set a task to open the file. This will set up auto email at desired time.

Originally Posted by GetWorkDone

Based on link provided earlier you create a procedure in VBA to send email. Once done follow below steps to automate it.

1. Set procedure to run as soon as excel is opened (Use below code in "This Workbook Module" in VBA) Replace SendEmail with your Procedure. This will run your procedure and then close your excel.
Private Sub Workbook_Open()
Call SendEmail
Application.Quit
End Sub
2. Once you have automated auto run of Procedure using windows scheduler set a task to open the file. This will set up auto email at desired time.

that you for reply again but but not under stand how to replace with sendmail and no much more knowledge about windows task

Were you able to create procedure to send email?