Over the last 7 years, Rob has been asked by the SageCRM Community hundreds if not thousands of questions on how do you do this inside of SageCRM? Rob has noticed a very distinctive pattern develop over these last 6 years as the respective members of the SageCRM Community have joined and advanced their knowledge of SageCRM. The questions have gone from basic to advanced/techie/nerdy as each member’s knowledge and implementation experience has grown. The intent of this blog is to help you as a member of the SageCRM Community to move your SageCRM knowledge to the next level - what ever that level might be.
Question from Partner:
We are trying to use the MAPI settings for SageCRM's Advanced Email Management. However, the values we are using for the specific MAPI settings do not appear to be working. The Exchange server is on the same box as the CRM Server. The IUSR account has administrator rights as does the user ‘tester’ on the domain. The IMAP4 service runs as a local service. The mailbox checking service worked fine when we were using POP3 as the access method. Switching to MAPI presents the problem attached whereby the service cannot find the message store.
Email manager log:
2009-07-30 16:54:12.312> Email Service "Tester" Started
2009-07-30 16:54:12.343> **************************RulesScript is...*********************
2009-07-30 16:54:12.343>
if (bCond)
{
AssignedUser = 1;
AssignedChannel = 0;
}
2009-07-30 16:54:12.359> **************************End of RulesScript.*******************
2009-07-30 16:54:12.359> **************************about to run job....**************************
2009-07-30 16:54:12.359> Mailbox: Tester
2009-07-30 16:54:12.359> About to connect to mail server.
2009-07-30 16:54:12.453> Mailbox: Tester
2009-07-30 16:54:12.453> MessageStore "Tester" not found
2009-07-30 16:54:12.453> Mailbox: Tester
2009-07-30 16:54:12.453> Connected to mail server.
2009-07-30 16:54:12.453> **************************finished job run.**************************
2009-07-30 16:54:12.453> Sleep Period = 180 seconds
2009-07-30 16:54:22.140> Mailbox: Tester
2009-07-30 16:54:22.140> Email Service "Tester" Stopped
Solution:
There are several items you can check to determine what the problem maybe:
1) The mailmanager process needs to run as a user that you can log in as (so you can create the MAPI profile specific to the NT profile)
2) You need outlook installed to create the MAPI profile
3) The MAPI profile is created in Control Panel | Mail (there are allegedly other ways but never got them to work)
4) The mailbox is usually called something like "Mailbox - Username"
Thanks to the Partner for the question: Stuart.
Special Thanks to the resource that provided the answer for this question: Martin.
About Rob
Rob Lawson, a Field Sales Engineer III for Sage Business Solutions division is considered to be one of the true experts on the SageCRM product.
Mr. Lawson has been with Sage for over 7 years and is a Sage Accpac Certified Consultant in SageCRM, Sage Accpac ERP, Sage Accpac ERP Project and Job Costing. He is also a Sage Accpac Certified Product Trainer, Sage Accpac Certified Sales Consultant, Sage SalesLogix Certified Engineer, and a Certified Pervasive Professional. He has a background in both Accounting and Information Systems and received a BBA in Accounting from Georgia State University.
Currently, Mr. Lawson provides pre-sales technical assistance to customers and partners for SageCRM, Sage Accpac ERP, and Sage AccpacOnline. He also works closely with the development teams of SageCRM and Sage Accpac ERP to help bring the front line experience of the pre-sales team from the customer and partner perspective into view. While in previous positions within Sage he has provided pre-sales assistance on SageCRM.com, SalesLogix, SalesLogix Web Client, and Sage Mobile.
Additionally, he regularly publishes articles for the SageCRM Community which can be found on the Accpac BLOG Community site and the SageCRM Development Partner Program (DPP) BLOG Community site. He also continues to teach the SageCRM Business Partner Community via public webinars, pre-recorded “videos on demand”, and classroom courses.
Prior to joining Sage, Mr. Lawson has worked as a project manager, staff accountant and consultant for public accounting firms for eight years. This included work in areas such as sales, business analysis, implementations, customization, report writing, web site development, software and hardware support, and database conversions.
In his free time Mr. Lawson enjoys playing golf, reading, and working on computers.
