Illegal error after running macro

[Roach]

Hello all,

Would anyone know why I get an illegal error message after I run a macro? What the macro does is e-mail 2 different reports to different sets of people. After the message is sent I get the illegal message and Access closes out.

Any ideas will be greatly appreciated. Thank you.

Peace,
Roach

 

[Vav]

Similar Problem....

This doesn't help you much but I am experiencing a problem similar to yours.

I have my email code set up within a Loop, which is going through recordsets.

After two loops of the code, and after two emails have been sent out my computer has a Kernel32.dll error and Access closes.

Frustration galore!!!! Not sure if you have expereinced this problem yet, but perhaps you have a small bit of advise to help me out.

 

[yellow]

The 'Illegal Error Message' is what? Does it not give you any more information? If you are talking about an IPF or a GPF it is probably worth looking up the error message on Microsofts' website as this is extremely unlikely to be a problem with your macro but a problem with your MS Office.