G
GREG
Running Access 97 on XP (I know, I know, it's a long story. IT just won't
budge YET !!!), a rather lengthy macro attempts to email a series of reports
to various departments. Almost every day, but rarely at the same point in
the macro, execution stop and an error is displayed indicating that Access
must close. After closing & re-opening Access, copying the macro & deleting
the portion above the point of failure and then running the remainder OR
creating the same report & emailing manually produces flawless results. The
same macro uses 'OutputTo' to save certain reports vs. emailing them, this
part of the macro never fails. Evevnt viewer refernces Event 1000,
msmapi.dll. Before migrating from WinNT 4 to XP the same macro ran without
problems. Tried inserting a small DoEvent module both before and after the
point of error, no help.
budge YET !!!), a rather lengthy macro attempts to email a series of reports
to various departments. Almost every day, but rarely at the same point in
the macro, execution stop and an error is displayed indicating that Access
must close. After closing & re-opening Access, copying the macro & deleting
the portion above the point of failure and then running the remainder OR
creating the same report & emailing manually produces flawless results. The
same macro uses 'OutputTo' to save certain reports vs. emailing them, this
part of the macro never fails. Evevnt viewer refernces Event 1000,
msmapi.dll. Before migrating from WinNT 4 to XP the same macro ran without
problems. Tried inserting a small DoEvent module both before and after the
point of error, no help.