Group:  Microsoft Outlook ยป microsoft.public.outlook.program_vba
Thread: How to automate send message based on certain criteria.

How to automate send message based on certain criteria.
Jackeroo75 12/27/2008 10:59:00 PM
Hi foiks-

I was wondering how do I automate Outlook to send 2 specific dates such as
Jan 25, 2009 & Feb 14, 2009, etc. Basically, I want to have OUTLOOK
automatically send to my coworkers 15 days before these dates to tell them
their Timesheet are due. I was thinking, the easiest way would be manually
entered the two dates on the calendar and have outlook search for them???
Re: How to automate send message based on certain criteria.
"Michael Bauer [MVP - Outlook]" <mb[ at ]mvps.org> 12/29/2008 10:16:46 AM


This sample demonstrates how to use the reminder of a task item for that. It
works quite reliable as long as Outlook runs:
http://www.vboffice.net/sample.html?mnu=2&pub=6&lang=en&smp=10&cmd=showitem

--
Best regards
Michael Bauer - MVP Outlook

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


Am Sat, 27 Dec 2008 14:59:00 -0800 schrieb Jackeroo75:

[Quoted Text]
> Hi foiks-
>
> I was wondering how do I automate Outlook to send 2 specific dates such as
> Jan 25, 2009 & Feb 14, 2009, etc. Basically, I want to have OUTLOOK
> automatically send to my coworkers 15 days before these dates to tell them
> their Timesheet are due. I was thinking, the easiest way would be
manually
> entered the two dates on the calendar and have outlook search for them???

Home | Search | Terms | Imprint
Newsgroups Reader