outlook schedule task (macro) to run weekly.

[Stew J]

This is a question for the programming group in outlook. Below is a macro
that will run from outlook macro (not excel). I don't know how to have
outlook schedule the task (macro) to run weekly.


Sub openexcel()
'Dim wb As excel.workbook

FName = "C:\temp\book1.xls"
Set xlApp = Application.CreateObject("Excel.Application")
Set xlbook = xlApp.Workbooks.Open(FName)
xlbook.PrintOut

End Sub

 

[Michael Bauer [MVP - Outlook]]

This sample demonstrates how to use the task reminder for that. It works as
long as Outlook is running:

http://www.vboffice.net/sample.html?mnu=2&pub=6&smp=10&cmd=showitem&lang=en

--
Best regards
Michael Bauer - MVP Outlook

: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool:
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Sun, 1 Jun 2008 02:30:00 -0700 schrieb Stew J:

This is a question for the programming group in outlook. Below is a macro
that will run from outlook macro (not excel). I don't know how to have
outlook schedule the task (macro) to run weekly.


Sub openexcel()
'Dim wb As excel.workbook

FName = "C:\temp\book1.xls"
Set xlApp = Application.CreateObject("Excel.Application")
Set xlbook = xlApp.Workbooks.Open(FName)
xlbook.PrintOut

End Sub

[4 zitierte Zeilen ausgeblendet]