Doug Murphy
dw-murphy at cox.net
Wed Nov 29 15:52:54 CST 2006
It may be a windows event conflict. I am not sure if the timer is an Access thing or Access running a windows api. I do know that if Outlook happens to be sending or receiving when I try and send an email from Access an error is generated. This may be way out in left field but something to consider. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte Sent: Wednesday, November 29, 2006 1:23 PM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Email Automation to Outlook problem I'll have to give this a try...but if it had any updates...they would have to have been automatic...its an old box running 2K Server...and I haven't run any updates in quite sometime. The weird part for me...is I can run the code from a button...but not a timer event??? Thanks, Mark A. Matte >From: "William Hindman" <wdhindman at dejpolsystems.com> >Reply-To: Access Developers discussion and problem >solving<accessd at databaseadvisors.com> >To: "Access Developers discussion and problem >solving"<accessd at databaseadvisors.com> >Subject: Re: [AccessD] Email Automation to Outlook problem >Date: Wed, 29 Nov 2006 16:12:25 -0500 > >...have you tried a restore point before it started failing ...imnsho >Microsoft has returned to issuing updates without thoroughly vetting >them ...it seems everytime MS does an update these days, my phone >starts ringing :( > >William Hindman >----- Original Message ----- >From: "Mark A Matte" <markamatte at hotmail.com> >To: <accessd at databaseadvisors.com> >Sent: Wednesday, November 29, 2006 3:24 PM >Subject: Re: [AccessD] Email Automation to Outlook problem > > > >I am actually having a related issue right now. I have a db that > >imports data every 30 minutes...does an analysis...and emails > >results using outlook. > > It worked fine for a year...and now outlook crashes almost > >everytime >with > > "An unknown Error". If I execute the exact same code from a button > > instead of a timer, it runs fine...I'm lost at this time. I need a > > way to send >an > > email without using outlook...I guess? > > > > Thanks, > > > > Mark A. Matte > > > >>From: "Gustav Brock" <Gustav at cactus.dk> > >>Reply-To: Access Developers discussion and problem > >>solving<accessd at databaseadvisors.com> > >>To: <accessd at databaseadvisors.com> > >>Subject: Re: [AccessD] Email Automation to Outlook problem > >>Date: Wed, 29 Nov 2006 18:09:03 +0100 > >> > >>Hi Susan and Chris > >> > >>Oh, that's another story - I don't use Outlook - so I cannot help. > >>Could it be an automatic Windows Updating issue? > >> > >>/gustav > >> > >> >>> ssharkins at setel.com 29-11-2006 17:40:32 >>> > >>Gustav, > >> > >> This is something that Outlook seems to do on its own -- at least > >>on my system. An address that's worked for years will suddenly not > >>send. In the header, I can see the apostrophes. I delete the > >>address, re-enter it, >and > >>9 > >>times out of 10, it goes. No clue... > >> > >> In my case, there's no code involved -- this is all Outlook. > >> > >>Susan H. > >> > >>The obvious solution is to adjust your code to stop wrapping the > >>address in apostrophes. > >>If, for some reason, that can't be done, change these to brackets like: > >> > >> <johndoe at aol.com> > >> > >>-- > >>AccessD mailing list > >>AccessD at databaseadvisors.com > >>http://databaseadvisors.com/mailman/listinfo/accessd > >>Website: http://www.databaseadvisors.com > > > > _________________________________________________________________ > > Talk now to your Hotmail contacts with Windows Live Messenger. > > >http://clk.atdmt.com/MSN/go/msnnkwme0020000001msn/direct/01/?href=http: >//get.live.com/messenger/overview > > > > -- > > 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 _________________________________________________________________ View Athletes Collections with Live Search http://sportmaps.live.com/index.html?source=hmemailtaglinenov06&FORM=MGAC01