Auto Schedule Send Mail in pre-defined intervals via VBA

  • Thread starter Thread starter Michael Avidan
  • Start date Start date
M

Michael Avidan

Hi all,
I wonder, is there a ready&working VBA code that I can use in order to send the same message at pre-defined intervals
(daily/weeklymonthly) the intervals will be declared from inside the code.
I will appreciate any code that works as I do not have enough knowledge in "Outlook" VBA (I'm using "Outlook 2003")
Thanks, Micky
 
This works most of the time:
http://www.vboffice.net/sample.html?mnu=2&lang=en&smp=10&cmd=showitem&pub=6

Just keep in mind that Outlook must run all the time - and you cannot rely
100% on that it is doing that.

--
Best regards
Michael Bauer - MVP Outlook
Synchronize Color Categories & Ensure that Every Item Gets Categorized:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Sun, 2 Dec 2007 20:50:45 +0300 schrieb Michael Avidan:
Hi all,
I wonder, is there a ready&working VBA code that I can use in order to
Click to expand...
send the same message at pre-defined intervals
(daily/weeklymonthly) the intervals will be declared from inside the code.
I will appreciate any code that works as I do not have enough knowledge in
Click to expand...
"Outlook" VBA (I'm using "Outlook 2003")
 
Thanks a lot.

I will check the Code.

I wrote somethig similar but in Excel VBA and it works 100% (Excel must be
running all the time in the background.
It has a timevalue counter running) therefor I did not understand why your
code is not 100% proof.

Can you please define the points why it cannot be relied on a 100% !?

Michael
 
Hi,
I checked the code and it works wonderful.
I changed the time interval into: DateAdd("n", 5,....) only for checking
purpose and every 5 minutes a new mail was sent out.
If I may suggest - I hope you'll find it appropriate - to add a short
explanation as where to put the code (in ThisOutlookSession) because it is
not obvious to the average user.
Thanks again,
Michael
 
Mr, Bauer,


Please take a moment and explain your hesitation or doubt, in your previous
reply,

by pointing out that even if Outlook runs all the time I can't rely 100% on
that it is doing that.
If there is something else (beside Outlook running and an accurate Internal
Clock) please share the secret with me/us.
I'm not going to use it for sending critical messages but I still wonder
what is there behind this statement, of yours, as you have much more
experience than I do.
Thanks, Michael
 
Michael, it's not necessary to ask multiple times; as soon as I have the
time I'm back - usually once a day.

The point is that you cannot rely on that the code is running all the day;
your computer might crash or VBA might get disabled by Outlook if there are
serious, unhandled errors.

If it's not for critical messages everything should be fine. I'm (mis)using
Outlook for automatic processes myself - and it works almost 24/7.

--
Best regards
Michael Bauer - MVP Outlook
Synchronize Outlook Categories:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>

Am Tue, 4 Dec 2007 00:50:12 +0300 schrieb Michael Avidan:
 
Back
Top