Problem with sending Emails from Access 2010

[Husni]

Hello everybody,


A client of mine has a problem with sending Emails
after he upgraded from Office 2007 to Office 2010.
His code is very simple:

Dim stDocName As String

stDocName = "rptMailProjectleider"

DoCmd.SendObject acReport, stDocName, acFormatRTF

This code worked well in Office 2007.
After upgrading to Office 2010 an error message shows up.:
The message cannot be sent from Microsoft Access.

I work with Office 2010 myself and on my computer
this code works well.
So I cannot explain why this code does not work
on my client’s computer.

Is it because of security settings in Outlook 2010?
Does anybody have a clue?
All ideas and suggestions are welcome.


Yours sincerely,


Husni

 

[Trevor G]

Check the security settings on the machine that wont work, it maybe that the VBA has been disabled. File Then Access Options then Trust Center and then Trust Center Settings then the Macro Settings

 

[The_Doc_Man]

There is also this little-appreciated fact. The "References" that you have in your database code are stored in the registry, which is a per-user object. Verify that the user's registry contains a reference to the Outlook object library. I could easily imagine that your 'puter has the Outlook reference checked and your user's 'puter doesn't.