creating email message vs Outlook 2000 (sp1) (Access 97 )

I'm using the following code to embed a word document into the body of an email, then send the email to the intended party (names have been changed accordingly). The problem is that the new service pack for Outlook 2000, in its attempt to circumvent "bad" attachments, is not happy with what we're trying to do, and this ends up in the ultimate loop 'o doom as the user tries to click the "yes" button when the explanatory "are you sure you want to send this attachment because some attachments can contain viruses" window pops up over and over and over again, until the user ctrl/alt/dels the whole process, which ends up eventually corrupting the database.

Re: creating email message vs Outlook 2000 (sp1) (Access 97 )

Just a caution on Redemption. It works just fine with Access 97, but you must have the CDO library installed on the machine or Redemption breaks. Outlook doesn't necessary install CDO by default, so you may have to do a reinstall on a given machine to get the functionality you need, depending on the OS you're using.

Re: creating email message vs Outlook 2000 (sp1) (Access 97 )

Thanks, Charlotte - I'll let the sysadm know. As far as I can tell, I have the correct version on my machine, but then again, being the developer, it never happens here... <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

Re: creating email message vs Outlook 2000 (sp1) (Access 97 )

The problem is more likely on machines running NT, Win2k or WinXP, which don't automatically installl CDO.dll. Later versions of Outlook only install CDO.dll if you do a custom install and drill into the Outlook options to specifically select it.