Hello friends,

Have a question about outlook 2007. I need to run a macro every days, this
macro send a mail with information of a SQL. Have the macro created and run
succesfull but how i can to do for run every days automatically ?

is possible schedulle this macro ?

Thanks in advnace and sorry by my english,

Christian Wis.

This might help you:
http://www.vboffice.net/sample.html?...0&cmd=showitem

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
http://www.vboffice.net/product.html?lang=en


Am Fri, 14 May 2010 11:24:01 -0700 schrieb Christian W:

Hello friends,

Have a question about outlook 2007. I need to run a macro every days, this
macro send a mail with information of a SQL. Have the macro created and
run
succesfull but how i can to do for run every days automatically ?

is possible schedulle this macro ?

Thanks in advnace and sorry by my english,

Christian Wis.

Michael,

Excelent!!!!!!!!!


Thanks a lots

"Michael Bauer [MVP - Outlook]" wrote:



This might help you:
http://www.vboffice.net/sample.html?...0&cmd=showitem

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
http://www.vboffice.net/product.html?lang=en


Am Fri, 14 May 2010 11:24:01 -0700 schrieb Christian W:

Hello friends,

Have a question about outlook 2007. I need to run a macro every days, this
macro send a mail with information of a SQL. Have the macro created and
run
succesfull but how i can to do for run every days automatically ?

is possible schedulle this macro ?

Thanks in advnace and sorry by my english,

Christian Wis.
.

Michael,

This code work, but have a problem, when remainder is executed a error
message is showed by outlook "Microsoft Outlook has encountered a problem and
needs to close, sorry for the inconveniences"

How i can to solve ?

Thanks in advance.
Christian W



"Michael Bauer [MVP - Outlook]" wrote:



This might help you:
http://www.vboffice.net/sample.html?...0&cmd=showitem

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
http://www.vboffice.net/product.html?lang=en


Am Fri, 14 May 2010 11:24:01 -0700 schrieb Christian W:

Hello friends,

Have a question about outlook 2007. I need to run a macro every days, this
macro send a mail with information of a SQL. Have the macro created and
run
succesfull but how i can to do for run every days automatically ?

is possible schedulle this macro ?

Thanks in advnace and sorry by my english,

Christian Wis.
.

Michael,

and now have a problem with outlook, your code works, but outlook cancel
with a message error "Microsoft Outlook has encountered a problem and needs
to close, sorry for the inconveniences caused"

any idea ?

Thansk in advance,
Christian

"Michael Bauer [MVP - Outlook]" wrote:



This might help you:
http://www.vboffice.net/sample.html?...0&cmd=showitem

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
http://www.vboffice.net/product.html?lang=en


Am Fri, 14 May 2010 11:24:01 -0700 schrieb Christian W:

Hello friends,

Have a question about outlook 2007. I need to run a macro every days, this
macro send a mail with information of a SQL. Have the macro created and
run
succesfull but how i can to do for run every days automatically ?

is possible schedulle this macro ?

Thanks in advnace and sorry by my english,

Christian Wis.
.

What happens if you walk through the code step by step? For that set a
breakpoint on the first line, and use f8 after the code execution has
stopped at that line.

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
http://www.vboffice.net/product.html?lang=en


Am Mon, 17 May 2010 11:25:01 -0700 schrieb Christian W:

Michael,

and now have a problem with outlook, your code works, but outlook cancel
with a message error "Microsoft Outlook has encountered a problem and
needs
to close, sorry for the inconveniences caused"

any idea ?

Thansk in advance,
Christian

"Michael Bauer [MVP - Outlook]" wrote:



This might help you:
http://www.vboffice.net/sample.html?...0&cmd=showitem

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
http://www.vboffice.net/product.html?lang=en


Am Fri, 14 May 2010 11:24:01 -0700 schrieb Christian W:

Hello friends,

Have a question about outlook 2007. I need to run a macro every days,
this
macro send a mail with information of a SQL. Have the macro created and
run
succesfull but how i can to do for run every days automatically ?

is possible schedulle this macro ?

Thanks in advnace and sorry by my english,

Christian Wis.
.

Hello Christian!
Try to use that as basic code
It have to be created in ThisOutlookSession

Private Sub Application_ItemSend(ByVal Item As Object, Cancel As
Boolean)
Dim td As Date
Dim mi As MailItem
Set mi = Item.Copy
tdelay = DateAdd("d", 1, Now())
mi.DeferredDeliveryTime = tdelay
mi.Send
End Sub

That code create copy of your mail item to send and set its delivery
time in a day after.
You have to analyse some specific information in your message to
duplicate only items you need.
However, it clones copy of your item in Outbox

Reagrds, Andrey

Forgot!
It tested on Outlook 2003, not 2007
But it used not specific VB model, I hope
Andrey