Email a workbook/worksheet on schedule?

Z

Zigball

Does anyone know how I could get a workbook/worksheet to automatical
email on a schedule?
Example: I want the workbook to be emailed on 9-30-2007, 10-31-2007
etc... every year do you know how this can be done?

Example Code:

Sheets(Array("Sheet1", "Sheet2")).Copy
'ActiveWindow.SelectedSheets.Copy
Set wb = ActiveWorkbook
With wb
.SaveAs "C:\Documents and Settings\"
.SendMail "email address here", _
"comment here"
.ChangeFileAccess xlReadOnly
'Kill .FullName
.Close False
End With

this the code I have.
 
H

HotRod

I'm working on the same issue except it needs to be emailed at 8am each day.
In this case I think I'd use the MS scheduler to launch a macro that emails
the workbook. Have a look here

Previous copy and paste
"I would be inclined to do this via VBA... Take a look at Ron's site to see
how to Email...

http://www.rondebruin.nl/sendmail.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top