Email not working for some users

[dcnick]

When a button is clicked in a form that adds a new record, an email is sent to 3 users containing the record information. The email format is set up in VBA. This worked great before we converted to Office 2007. Now, it seems to work for everyone but me. The new record is saved, but the email is not sent.

I know the code is correct, because when another coworker clicks the button, it works (record is added and email is sent). I am thinking it's a security setting on my computer? We all work from the same front-end database.

Any ideas are appreciated.
Thanks

 

[Guus2005]

Have you tried debugging the bastard?

 

[dcnick]

I'm not sure if that's the right course of action, since it works perfectly for other users. I didn't know if there was some kind of security setting on my computer that is preventing the email from being sent, even though I select "allow" when the window appears warning me that I am about to send an email.

 

[GaryPanic]

if you are using outlook - turn your out of office on - reboot and then turn it off - see if that helps

 

[dcnick]

Did not work.

 

[Guus2005]

is there an error message involved? When you debug you can see if there is an "On Error resume next" statement which prevents Access from sending you an error message, because you didnt have some dll registered...

HTH

 

[dcnick]

No. There is no error in the code, and I'm assuming code isn't the problem since it works well for others. I'm assuming it is some security setting on my computer or in Outlook.

I've tried the suggestion of turning Out of Office on, rebooting, and turning it back off; but it did not work.