Access 97: Macro to Outlook 2000 Doesn't Work

Likely, it's because you can't "move upward". Most programs are downward compatible, but not upward. The reason Outlook 98 probably works is because it's really nothing more than an upgrade of Outlook 97. Outlook 2000 came with the Office 2000 suite. If I were you, I'd just open the DB in Access 2000 and convert it, if necessary, and have the macro in there. You should be able to import the new tables quicker than trying to find some other workaround. You can probably just add that to the macro, you know--import tables (linked even) from Access 97 DB, run report, send as rtf to OL2K.

?

unfortunately - I can't convert to access 2000 as i have 65 users using this database who are as yet unupgraded..(is that a word?) i need to stick with access 97... is it possible I am missing a dll file to enable the mapi?

Check here:

http://support.microsoft.com/support/kb/articles/Q283/1/73.ASP

http://support.microsoft.com/support/kb/articles/Q161/0/88.asp

However, when I said upgrade, that means you keep a COPY of the DB on your hard drive (or some OTHER location away from the 97 DB) in 2000 and you run your macros on that one. Unless, of course, others have to run them too, then you're SOL on that workaround.

Good luck!