Problem with SendObject method in MS Access 2010

I deploy several MS Access applications along with Access runtime 2010.  I use the SendObject method extensively throughout these applications for attaching Access reports to emails.  For the most part it works extremely well but I have a couple of users that get a "Choose Profile" prompt when trying to email a report.  They only have one outlook profile which is named Outlook and is set as the default profile.  If Outlook is entered as the profile on the Choose Profile prompt I get the message "The MAPI Spooler could not be started.  Close and restart all mail-enabled applications.
They are both running Windows XP and MS Office 2010.   I do not have this problem on other computers which are also running Windows XP and MS Office 2010.
Any ideas on how to fix this
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
Sounds like issues with the installation of Outlook, or perhaps with their Windows profile.

Can they perform a repair/reinstall of Office? That would eliminate issues with that.

Also be sure their Windows and Office installs are fully up to date.

If this only happens to some users but not others, then you might have a corrupt profile. On a different machine on the same network, have a trouble user log on and run the application. If the issue follows that user, then you may need to recreate that profile.

Also be sure to Compact your database before sending it out.
dsoderstromAuthor Commented:
I ran a repair on Office but still get the same prompt and error message.
I am out of the office where the problem is occurring until Thursday but will try and have the user run the application on a different computer when I am back there.
Will let you know the results.
dsoderstromAuthor Commented:
I ended up moving the user to a new computer with Windows 7 and the problem went away.  Apparently the problem was with the Windows profile as you suggested.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.