Access 2K and Outlook Express

[TommyF]

I am trying to send email in Access 2K and am having some problems which I hope somebody can solve for me.

I have been able to send email using the sendobject command but found it only worked once and then I would have to shut Access down and open it again before it would work again, on reading through some articles in tek-tips I have found it is a bug with Access 2K.

Is there any other way to send mail using Access 2K via Outlook Express? I have found a way to send it via Outlook 2K, but I really need to send it via Outlook Express.

If this is not possiable has anybody got any other ideas.

 

[danvlas]

I have been using Access 2K for some time now. And of course I encountered this bug, but only in one case: when emailing to multiple recipients. If the email addresses were separated by comma, Access only sent one email message and had to be restarted to send other email and so on. After I changed the separator to semicolon, it worked just fine. I also changed the list separator in Control Panel-Regional Settings to semicolon. It's worth a try...If it doesn't work, you should think of upgrading to XP or downgrading to 97. My personal opinion is that Access 2K does not reset the mapi32.dll properly if certain conditions are met. What's really annoying is that no Access or OE run-time error occurs...

HTH


Daniel Vlas
Systems Consultant
danvlas@yahoo.com