We are planning to upgrade all our users to Outlook 2010 and Exchange 2010 soon but have run into a few headaches with the Outlook migration. We have an Excel spreadsheet that is basically an expense report that automatically gets emailed to the appropriate people when they click a button in the spreadsheet. It uses some macro (I'm not a programmer) to achieve this. It works well with Outlook 2003 that we have now, but our test group of users cannot use it - they receive the error below.
Can anyone help figure this out. Its driving me nuts!!
I've tried sending it with Outlook open and with it closed.
UPDATE: SOLVED
The problem was our citrix farm setup...Since MS doesnt allow side-by side installs of outlook versions like they do with all other office applications, we had to install outlook 2010 on a "testing" xen app server. Since these users were test outlook 2010 users their profiles only had permissions to use outlook 2010 and outlook 2010 as their default email client. The problem presented itself when they would open the spreadhseet in excel 2003 on the production xenapp farm - where outlook 2010 wasn't installed. so it was trying to send mail through their default email client (outlook 2010) which didn't exist on that server. And since their accounts were only configured to use outlook 2010, excel didn't know what to do.
The solution for us was to create a new Excel published app in citrix that was installed on the same server as our outlook 2010 installation, limit the farm to that one testing server, and publish that app to our test users, while removing their old excel app. This way, the are only running Outlook and Excel on the test server.