StaRKeY
starkey at wanadoo.nl
Thu Apr 27 16:47:46 CDT 2006
Hi John, It's not clear to me what the environment settings in your case are like but you could ofcourse write your own piece of code in an MDB to schedule and send the mail using Outlook MAPI and have an Access instance 24/7 running. If coding like this is not an option and the macro already exists, I assume the macro does the complete job and all you need is the scheduling part, then why not use the Outlook object model in an Access mdb and again keep it running 24/7 and have vba code execute the macro using the objectmodel. Ofcourse if you have SQL server around Karen's way is better in my opinion since running Acces 24/7 would not be my first choice though windows also has a scheduler which you could probably use(!). In this case not only could you work with an ActiveX but also it would be possible to write some code to execute an Access mdb (including an autoexec ofcourse) which triggers the macro or a simple VB application, in both cases making use of the Outlook object model. I have to be honest though, I haven't checked the Object model for this answer as we speak so there is a possiblity that using the object model is out of the question regarding an Outlook macro but I assume it can be done this way. Hope it keeps your fantasy going;) Regards, Eric Starkenburg -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dian Sent: Wednesday, April 26, 2006 3:19 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Scheduling a macro to run John, don't give it up just yet...I did this for a company a few years ago...know the info is here somewhere, just haven't found it yet...will do it as fast as I can... -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John Colby Sent: Sunday, April 23, 2006 6:28 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Scheduling a macro to run Does anyone know how to schedule an Outlook macro to run every day (to send a canned email)? John W. Colby www.ColbyConsulting.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com --- avast! Antivirus: Uitgaande bericht is niet besmet. Virus Gegevensbestand (VPS): 0617-2, 26-04-2006 Getest op: 27-04-2006 23:47:47 uur avast! auteursrecht (c) 1988-2006 ALWIL Software. http://www.avast.com