I have a button on a form that runs a macro to send a report in rtf in a email. This used to work OK but what happens now is that it works once then nothing happens.
Not too sure what is causing the problem without seeing it for myself. Are you receiving any error messages?
Maybe worth trying to compact the database or try importing all database objects into a new blank database. Doesn't explain why it would work once then fail to work afterwards but may be worth a shot. Another idea may be to create the macro from scratch.
Thank you! Thank you! This also happened to me but only on computers with Windows 2000...not XP. The service pack is supposed to fix it, but also deleting some of the body text helps. Who woulda thought????