20 July 2008

CRM 4.0 E-mail access type bulk setting tool


(Update: You can use CRM 4.0 Workflow to do it as well, it's up to you to choose which one you feel comfortable.)
Microsoft Dynamics CRM 4.0 doesn't provide a tool for CRM User's email access type bulk setting. So I write this application to helping CRM Administrators for this purpose. It takes me 2 hours work so don't expect too much, however it does work. ;-)


Usage:
1. Launch the application, type in the following information:
CRM Server(the CRM discover server address): e.g http://localhost:5555
Organisation(the Organisation's name, not Friendly name): e.g AdventureWorksCycle
SQL Server: e.g localhost
Database: e.g Adventure_Works_Cycle_MSCRM
CRM User: e.g CRMAdmin
CRM User's Password

2. Click the 'Load' button, it will list all enabled CRM users whom belonging to this organisation with their email settings.

3. Select users your want to modify, then select Incoming E-mail and Outgoing E-mail setting from the picklist. If you don't want to change both of those, then just select blank in the picklist.

4. Click the 'Update' button, it will update user settings you selected.

Download it here: http://code.msdn.microsoft.com/crm


Enjoy it!

Cheers,
Jim Wang
http://jianwang.blogspot.com
http://mscrm.cnblogs.com

10 comments:

Anonymous said...

It does provide you a tool, workflow.

Jim Wang said...

Yeap, you are right. :)

Anonymous said...

Great Job !!!

Is it possible to expand this for some other fields ( Timzone etc. ) ?

Thanks for reply

Anonymous said...

Hi Jim,
Are you using the EmailDeliveryMethod class of the SDK to do this or do you do direct SQL Updates? Is the source code of your project available?
Kind regards
Benjamin

Sarfaraj Sayyad said...

I think tou are doing DB changes in “SystemUserBase” table.

Is there any other way or Web Service to do this, I thing modify the dB is not proper way to do.

Please let us know if any Web Service available for this issue.

Regards
Sarfaraj Sayyad.

Anonymous said...

酒店經紀PRETTY GIRL 台北酒店經紀人 ,禮服店 酒店兼差PRETTY GIRL酒店公關 酒店小姐 彩色爆米花酒店兼職,酒店工作 彩色爆米花酒店經紀, 酒店上班,酒店工作 PRETTY GIRL酒店喝酒酒店上班 彩色爆米花台北酒店酒店小姐 PRETTY GIRL酒店上班酒店打工PRETTY GIRL酒店打工酒店經紀 彩色爆米花

Malcolm said...

I am able to load the application and see all the Users settings but when I try and save a change I get an error message saying,

'The File '/mscrmservices/mscrmservices/2007/crmservice.asmx' does not exist'.

Can you advise further?

dancilhoney said...

email campaign software is being used by most of the top internet marketers and I am also using that.
What I meant is there are some other alternatives that also works.

Unknown said...

Keep up the fantastic piece of work, I read few blog posts on this web site and I believe that your site is real interesting and has lots of great information. ERP Software in Mumbai || System Software || CRM Software in Mumbai || MLM Software

Unknown said...

I really appreciate spending some time to talk about that, I believe firmly regarding this and so really enjoy understanding more about this kind of subject.This is also a very good post which I really enjoyed reading. It is not everyday that I have the possibility to see something like this. CRM Software || MLM Software in Mumbai || ERP Software || System Software in Mumbai