Myke Myers
mmmtbig at bellsouth.net
Wed Nov 29 15:23:11 CST 2006
I don't seem to be able to get rid of the apostrophes around the email address. Per Susan H.'s recommendation, I added brackets: itm.To = "<" & strEmailAddr & ">" Still shows up in Outlook with apostrophes and no brackets. Maybe this is some spam-fighting patch in Outlook implemented by Microsoft recently. It is causing big trouble for my client (and me). Myke -----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 3:24 PM To: accessd at databaseadvisors.com 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