View Single Post
  #5  
Old May 2nd 07, 01:38 AM posted to microsoft.public.access.formscoding,microsoft.public.outlook
Rob Parker
external usenet poster
 
Posts: 8
Default Emailing from Access application - inconsistent behaviour with SendObject

Thanks Scott,

Although the kb article refers to Office 2000 and I've got an Office 2003
environment, the code there may provide a suitable solution. I'll give it a
try, and post back results. As for using an alternative email, that's not
an alternative - this application is used solely within an organisation with
a tightly controlled environment.

Rob


"Scott McDaniel" wrote in message
...
On Tue, 1 May 2007 23:55:10 +1000, "Rob Parker"
wrote:

Sendobject failing when called in a loop is a know issue:

http://support.microsoft.com/default...b;en-us;260819

The resolution in that article is to obtain the latest Office 2000 service
pack, however (IMO) if your application
relies heavily on email then you'll be better off handling it outside of
Outlook. I've used the Internet Mail Library
from here for years:

www.codestone.co.uk

It works very well, handles attachments easily, and you can call it as
many times as you like without issue. There are
so freeware email suggestions here;

http://www.granite.ab.ca/access/email.htm


Scott McDaniel

www.infotrakker.com



Ads