We have a third party application with a SQL Server (2008 R2) back-end that allows the user to select person records and use this selection to as a data source for a MS Word mail merge. This process worked fine until we upgraded the desktop OS from windows XP Pro to Windows 7. Now, the mail merge works sometimes. Other times, the user will get the error
Object reference not set to an instance of an object.
This error does not happen if the application is "Run as Administrator". However, allowing everyone to run this application as an administrator is not a viable solution. We have spoken with the developers of the application and they are not experiencing this problem despite a similar set up.
Another point of note. The templates for the mail merge are stored on a network share. However, the results are the same if the templates are located on the user's local machine.
Any suggestions as to why we may be getting the above error would be greatly appreciated.