Solved

MS CRM 4.0 Mail Merge Failing

Posted on 2009-07-09
4
482 Views
Last Modified: 2013-11-24
The Admin for CRM setup 3 different  templates for mail merges.  All 3 templates work for 3 different users on different computers.   One user (4th user) cannot do the mail merge for opportunities and quotes  He is prompted "do you want to download this type of document" (WORD template).  If you select open it then says it will run an SQL command and then it says it cannot find the data source(the document will eventually open but nothing is filled in).   The user has the same permissions has the other users.  The odd thing is if the user than it does not work for goes to anther computer and logs in it will fail and then if a user who it previously worked for logs back in to that computer it fails for them as well (same errors).  If I go to the server and run the scheduled tasks MSCRM_CONFIG.HARDELETE AND MSCRM_CONFIG.SITEWIDECLEANUP then the user that it previously worked for can do the mail merge on that same computer and all is well but the user that it nevers works for still cannot do the mail merge from any computer.  Is the problem in CRM?   Can we delete the user and re-create (his would mean orphaned records however so I doubt CRM woul allow that).  IS there a corrupted user profile or is it at the domain level?  Any help is appreciated.
0
Comment
Question by:PACCAST-DEV
4 Comments
 
LVL 29

Expert Comment

by:Feridun Kadir
ID: 24821261
Two comments:

1. When your user gets the SQL command window, try saying no or cancel. I have a vague recollection of a similar issue and doing this meant the
2. CRM users can not be deleted, only disabled. You could try deleting his Windows user profile - it might resolve the problem.
0
 
LVL 15

Expert Comment

by:WilyGuy
ID: 24963454
Any difference in the User's role or business unit from the other 3 users?  What about License?  (Are they all FULL Users?)
0
 

Expert Comment

by:Larzdk
ID: 25494162
Hi,

I don't have a sollution for you, but I just wanted to tell you that you're not alone in having this problem. We see it too.

Did you ever find a sollution?
0
 

Accepted Solution

by:
PACCAST-DEV earned 0 total points
ID: 25518031
We basically formatted the hard drive and our PC Tech installed everything just as if it was a new PC and now everything works fine.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Exact MAX for Windows - ERP 3 417
How to add options to a field in Microsoft dynamics CRM 2 192
Looking for an ERP tradeshow/convention 2 122
Symantec Enterprise Vault to 365 2 120
When CRM stops functioning propperly or mysteriously disappears then this is something you should always check. This can be useful when looking at an end users machine or your own machine if you are the end user. It may be fairly obvious to some but…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

679 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