We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

MS CRM 4.0 Mail Merge Failing

PACCAST-DEV
PACCAST-DEV asked
on
Medium Priority
538 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.
Comment
Watch Question

Feridun KadirPrincipal Consultant
CERTIFIED EXPERT

Commented:
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.

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

Commented:
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?
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.