Email Macro Failed

[JakeC11]

Hey all, I recently installed a packaged database I've been working on, onto 4 computers in our offices. On two of the computers the email report macro that I've set up works fine, on the other two it fails and shuts the database down. The package includes Access Runtime rather than requiring a full version of Access. Any ideas why this might be happening? I used the access button wizard to create the button/macro.

 

[HiTechCoach]

Hey all, I recently installed a packaged database I've been working on, onto 4 computers in our offices. On two of the computers the email report macro that I've set up works fine, on the other two it fails and shuts the database down. The package includes Access Runtime rather than requiring a full version of Access. Any ideas why this might be happening? I used the access button wizard to create the button/macro.

Is the exact same version of Outlook installed ont he two PCs that are having an issue?

Note:
When using the runtime, you mast have very good error handling code.

 

[JakeC11]

Yeah they are, I've updated all the computers to Outlook 2007 thinking that might fix the problem, but no dice. The only other link I can see is that the two that are working have full versions of access on them as well as the runtime.

 

[Dennisk]

are you using a reference to the outlook object library, or using the DoCmd.SendObject method. If the former remember you need the correct Outlook Library referenced in Access. So you could have one DB running on a PC with Outlook 2000 and one with Outlook 2003. This will require a reference to the correct version on each PC.

 

[JakeC11]

I'm pretty sure I'm using the DoCmd.SendObject method, but I'll double check. I used Access's built in button wizard to create it.