Solved

Problem with SendObject method in MS Access 2010

Posted on 2014-01-30
3
490 Views
Last Modified: 2014-02-21
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
0
Comment
Question by:dsoderstrom
  • 2
3 Comments
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
ID: 39822024
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.
0
 

Author Comment

by:dsoderstrom
ID: 39832697
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.
0
 

Author Closing Comment

by:dsoderstrom
ID: 39876989
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.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Are you unable to connect or configure Hotmail email account in Microsoft Outlook 2010, 2007? Or Outlook.com emails are not downloading to Outlook? Lets’ see the problem and resolve Outlook Connector error syncing folder hierarchy (0x8004102A).
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question