Running a macro at specified times or at intervals is not supported out of
the box. You would need to use a timer to fire at intervals to kick-start
the process. Since VBA code doesn't provide a timer control you would need
to have either VB6 installed and use its timer control or use a Win32 API
timer control. You can find VB6 code for a Win32 API timer at
www.vbaccelerator.com and modify that as needed to work in your VBA code.

You can save attachments from specific items to the file system, there's
code to remove attachments from selected items at
http://www.slovaktech.com/code_sampl...ripAttachments that could be
used as a starter for your code.

How you call a stored procedure in SQL Server depends on how you're
connecting to the SQL server and is out of scope for this newsgroup. You
will need to specify how you're connecting, for example using ADO or
whatever.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm


"Webtechie" wrote in message
news
Hello,

I have programmed using VBA for Excel, Word and Access before. However,
never Outlook.

1) But I need to check folders for mail from out clients.
2) If I find mail from out clients, I need to save off the attachment in
a
certain folder
3) Then I want to kickoff a SQL Server stored procedure

Now having said that, can anyone at least point me in the right direction?

Can you set up a macro to run at intervals throughout the day?
Can you save off the attachments?
And of course, how to execute a SQL Server stored procedure?

Thanks for any and all help in my getting started with this.

Tony