More servicesWindows Live
HomeHotmailSpacesOneCare
 
MSN
Sign in
 
 
Spaces home  Workopia Microsoft CRM &...PhotosProfileFriendsMore Tools Explore the Spaces community

Frank Lee

View spaceSend a message
Occupation:
Location:
Microsoft Dynamics CRM Specialist and MVP for Small Medium Businesses (SMB)

Workopia Microsoft CRM & CRM Online Blog

Microsoft Dynamics CRM & CRM Online Blog for Small Medium Businesses - How To Articles, Project Stories, Observations, etc.
3/29/2008

How To: Installing Microsoft CRM for Outlook Client

This is one of the Microsoft Dynamics CRM 4.0 and CRM Online How To Articles that I've written.  My aim for these articles is to be very reader friendly (Microsoft CRM beginners and up) with step by step instructions and lots of screen shots.
 
The task of installing the Microsoft CRM for Outlook Client happens pretty often and it is also on-going, usually when a new Microsoft CRM user is added.  For a small business, this task can be easily managed and administered by your internal resources, even if they are not part of the IT department.
 
 
For Microsoft CRM Online:
How To: Installing the Microsoft Dynamics CRM Online for Outlook Client
 
For Microsoft CRM 4.0 On-Premise:
How To: Installing the On Premise Microsoft Dynamics CRM 4.0 for Outlook Client

 
Enjoy and please comment!
 
 
3/16/2008

Microsoft Dynamics CRM 4.0 Product Key Location

With the release of Microsoft Dynamics CRM 4.0, there has been a change to the location of the Product Key.  If you are ordering Microsoft CRM 4.0 via Volume Licensing, you will need to order the Media Kit (about $25 USD) from eOpen for Open, and from MVLS (VLSC) for all other, because the Microsoft CRM Product Key/License Key is embedded in the media (vs. printed on the back side of the media sleeve like in Microsoft CRM v3.0).
 
 
So, for Microsoft CRM 4.0 ordered via Volume Licensing - it is embedded in the CRM Server CD Media, under the following path: \Server\[amd64 or i386]\license.txt  (see picture)
 
080315_v4_ProductKeyLocation
 
 
Note: When installing the Microsoft CRM v4.0 Server from the Volume License media – the install will look for the license key file automatically - very cool, no more manually typing it in!
 
Note: For Microsoft CRM 4.0 media obtained through the Dynamics ERP product price list/Business Ready Licensing, the license key is NOT embedded in the media, and must be obtained from your Dynamics CRM Partner, who can obtain them in PartnerSource.
 
Note: There are other channels beside Volume Licensing and Business Ready Licensing - see this link for the document containing summary of Where Customers may obtain License Keys for Microsoft Dynamics CRM 4.0:
 
 
 
 
 
6/28/2007

Updates: Update Rollup 2 and 3 for Microsoft Dynamics CRM 3.0 (KB 927751)

Last update: 3/17/08
 
 
Here are the links to the latest public updates available for Microsoft Dynamics CRM 3.0 and the approch I'd recommend for applying these updates:
 
1. Upgrade all the Microsoft CRM 3.0 Outlook Clients to "V3C" if you haven't done so yet.  This is highly recommended.  All new Microsoft CRM Outlook Clients installation should be installed using "V3C".  Download the Microsoft Dynamics CRM 3.0 Client for Microsoft Office Outlook Compatibility Update "V3C" via the following link: http://www.microsoft.com/downloads/details.aspx?FamilyID=740e1b3b-11c3-4aef-b2e3-8309e0cf1bb0&DisplayLang=en
 
2. Update both the Microsoft CRM 3.0 Server and all the Outlook Clients with the Update Rollup 2 for Microsoft Dynamics CRM 3.0 (KB 927751).  Download the Update Rollup 2 via the following link:
 
As of 3/17/08 3. Update Rollup 3 for Microsoft Dynamics CRM 3.0 (KB 935364) is available, please apply Update Rollup 3 after Update Rollup 2 (Update Rollup 2 is a prerequisite for Update Rollup 3) to the Microsoft CRM 3.0 Server and all Outlook Clients.  You can download Update Rollup 3 via this link:
 
 
Notes: 
  
  • Update Rollup 2 and Update Rollup 3 for Microsoft Dynamics CRM 3.0 support both version of Microsoft CRM 3.0 Outlook Clients "V3" and "V3C".  However, I'd highly recommend upgrading all existing "V3" to "V3C".

 

 

As a good practice, always backup your Microsoft CRM environment prior to any updates, check out the following Microsoft CRM Backup link:
http://www.microsoft.com/dynamics/crm/using/deploy/backup.mspx

 
 
 
 
3/4/2007

Update: Daylight Saving Time (DST) Changes for Microsoft CRM 3.0

Beginning in 2007, daylight saving time (DST) will be extended in the United States. DST will start on March 11, 2007, which is three weeks earlier than usual, and it will end on November 4, 2007, which is one week later than usual. This results in a new DST period that is four weeks longer than in previous years.  This will affect Microsoft CRM 3.0 and update is available.
 
 
1. General Microsoft environment (Windows Operating System, Office, SQL Server, Exchange, etc.) is updated to support DST change, check out the following link:
http://support.microsoft.com/gp/cp_dst or work with your IT partner.
 
2. For Microsoft CRM 3.0, download the following two updates: Microsoft Dynamics CRM 3.0 Time Zone Data Updates (KB 925874) and Microsoft Dynamics CRM 3.0 Update Time Zones Wizard (KB 932984) from the following link:
 
  • Apply KB 925874, comes with two files - one for applying on the Microsoft CRM Server and one for the Microsoft CRM Outlook Client, instructions are in the KB article

 

  • Apply KB 932984, comes with one file - for applying on the Microsoft CRM Server, instructions are in the KB article - besure to run the "Microsoft.Crm.SE.TimeZoneSettings.exe"
 
Note: 
 

 

 

  • DST update is NOT available for Microsoft CRM v1.2, only available for v3.0.  Since v1.2 is no longer supported at this time.
 
2/11/2007

Business Cards: What To Do With Them - CardScan Microsoft CRM

It's that time of the year again folks - Convergence 2007 is just around the corner!  Convergence 2007 will take place in sunny San Diego, California, March 11-14.  I was at last year's Convergence 2006 in Dallas, Texas and it was one of the best Microsoft CRM events I'd attended.  Where else can you meet folks from different parts of the world, job roles, age groups, etc. that are passionate about Microsoft CRM in one place to network, exchange ideas/experiences and of course - business cards!!!
 

Join Me at Convergence Connect!

 
I love business cards, it is like a permission note to stay in touch with someone (by all means don't abuse this privilege, but always try to add value with each correspondence with the contact - the CRM way)! 
 
How many business cards did I gathered at last year's Convergence 2006 you'd asked?  I'd collected about 450+ business cards (excluding duplicate ones) so I'm expecting an abundant supply of business cards this time.. Woohoo...
 
So, how does an individual goes about dealing with "Business Cards" they'd received? 
 
I had spoken to a few folks about how they deal with business cards - the most common response is that they just toss them in the trash or the "big" brown box under their desk afterwards - very sad!  Of course, they did take the ones that are "important" and place those on their desk for entry/follow-up.  Why not enter them ALL into their Contact/CRM system?
 
Here are a few responses:
 
  • "They clutter up my Contact List"
  • "I will probably not see them ever again so why bother"
  • "Too much work to enter them and I don't have a good way to MANAGE them - just not worth it"
I mean, we all will and going to be exchanging physical printed business cards with one another and I don't see it ending anytime soon even with all the electronic versions around - vCard, Web 2.0 Contact Application, PDA, etc.  Oh well, I guess we just have to TYPE them in unless you have a college intern around!!!  Manually, it takes me about a minute to enter each business card and categorize it in Microsoft CRM, with very tired hands afterwards - PAINFUL!  There is a MUCH better way - CardScan for Microsoft CRM!!!

Microsoft CRM

Side note: Manual entry of business cards is a poor use of your college intern's time/brain cells.  They can help you find/prepare your next "Value added keep in touch email filled with relevant Technology/Business related articles"...

 
Here is how I go about with the business cards I'd received from events:
 
  • Mark the back of the business cards with a "*" and some notes for the ones that I would like to follow-up immediately after the event, the rest I will "keep in touch"
  • Scan ALL of the business cards I'd received via CardScan Microsoft CRM as CRM Leads
  • With CardScan Microsoft CRM, I can default the Lead Topic value to be "Convergence 2007 San Diego, California, March 11-14" and Lead Source value to "Trade Show" for all the scanned cards, for the ones that are "marked", I set the "Follow-up" flag to "True".
  • I'd setup a Microsoft CRM Workflow Rule that will "Auto-Create" a follow-up phone call and auto assign it to me when a CRM Lead is created with "Follow-up" value is "True"
  • All these contacts are now in my CRM Lead Management system and will be handled via our "Nurture" process

This is a pretty simple process, takes very little time, and it works very well for me.

Side note: Why "Nurture" them?  Because they just may help you connect with or influence your next opportunity! But you have to "keep in touch and add value!"

 
 
Here are the things that I love about my CardScan Microsoft CRM:
 
  • It just works - scan the business card and it matches/translates into the right fields (Name, Title, Phone, Email, etc.), simply amazing
  • Stores an electronic picture of the actual business card in case I need to manually correct any miss-match/translation - nothing is perfect
  • With one click of the "Transfer" button, the scanned business card records get imported into Microsoft CRM as Leads or Contacts (my choice)
  • Allows me to set the default values for various Microsoft CRM fields such as Lead Topic, Lead Source, custom field: Follow-up flag, etc.
  • Examines each record for duplicate in Microsoft CRM!
  • Super, super easy to setup and use plus very affordable even for a small business owner!
  • Very compact, about the size of two mobile phones, so I can take it wherever I go and scan my business cards AT the event location
 
Yup, you'd guessed it, I will bring my CardScan Microsoft CRM with me to Convergence 2007!  This way I can scan the business cards there and have more time for the family when I get back!
 
 
 
 
1/22/2007

Updates: Update Rollup 1 and Outlook Client "V3C"

Last update: 6/28/07
 
Update Rollup 2 is now available, use Update Rollup 2 going forward.
 
 
 
 
Last update: 4/7/2007
 
Here are the links to the latest public updates available for Microsoft Dynamics CRM 3.0 and the approch I'd recommend for applying these updates:
 
1. Update the Microsoft CRM 3.0 Server with the Update Rollup 1
Download the Update Rollup 1 via the following link:
 
 
Note: No need to apply the Update Rollup 1 for the Microsoft CRM Outlook Clients, but instead apply the following "V3C":
 
 
2. Upgrade all the Microsoft CRM 3.0 Outlook Clients to "V3C"
Download the Microsoft Dynamics CRM 3.0 clients for Microsoft Office Outlook Compatibility Update via the following link:
 
 
3. Update Daylight Saving Time (DST) on Microsoft CRM 3.0 Server and Microsoft CRM 3.0 Outlook Clients:
 
 
Notes:
 
  • "V3C" will detect your exiting Microsoft CRM Outlook client and will perform an upgrade.  It supports both Vista and Office 2007, plus backward compatible with Windows 2000/XP and Office XP/Office 2003!

 

  • All new Microsoft CRM Outlook clients installation should be installed with "V3C"

 

 
4. Review Hotfix below and apply only if needed. 
 
Popular Hotfix:
Issue: "Microsoft Office Outlook has encountered a problem and needs to close. We are sorry for the inconvenience."
Action: Request this Microsoft CRM Hotfix 931270 via CustomerSource, apply it only to systems that are experiencing this specific issue. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Microsoft Dynamics CRM service pack that contains this hotfix.
Note: This problem is also corrected in an update for the 2007 daylight saving time (DST) changes. As a good practice, always apply publicly available updates first (since it received more testing) that could resolve the issue(s) prior to requesting Hotfix.
 
 
 
 
7/3/2006

What's Next: Microsoft CRM 3.0 Mobile - Part 3

We had tested the Microsoft CRM Mobile running on PDA Phone PPC6700 and it performed well (Part 2).  Here is the current list of PDA and PDA Phones we have tested that works with Microsoft CRM Mobile 3.0 (list will update periodically):
 
 
PDA:
-Dell Axim x51v (April, 2006)
 
PDA Phones:
-Sprint PPC6700 (May, 2006)
-Verizon XV6700 (June, 2006)
-Cingular 8125 (June, 2006)
-T-Mobile MDA (June, 2006)
 
 
As of July, 2006, the fastest mobile broadband data protocol available in the U.S. is EV-DO from Sprint, Verizon, Alltel, etc.  The average EV-DO download speeds range from 300 Kbps to 500 Kbps with peak rates of 2.4 Mbps!  Upload speeds averaging 50 Kbps to 70 Kpbs.  Also, unlimited PDA Phone web/data access plan from Sprint Power Vision Access Pack is available at $15.00 per month!  Yup - you've guessed it, I went with the Sprint PPC6700 for myself.
 
 
Story time - here is an interesting Microsoft CRM Mobile experience during the past month:
 
 
I was visiting one of our Microsoft CRM clients planning for an upgrade to Microsoft CRM v3.0.  They needed to redeploy their production v1.2 over to a test environment to test the v3.0 upgrade.  Microsoft CRM v1.2 installation requires both the Organization Name and matching License Key.  And guess what, the Client didn't have it handy.
 
As a practice, we store our clients' License Key under their corresponding CRM Account's notes.  So...  I quickly pulled out my Sprint PPC6700 running our Microsoft CRM Mobile and subscribed to their Account to bring down the needed info.  Bingo, in less than a minute, their License Key appeared on my PDA! 
 
That is so efficient!  And the coolest part of it is that the Client after witnessing what just happened wants to evaluate Microsoft CRM Mobile 3.0 for their production use!
 
 
Microsoft CRM Mobile - Don't leave home without it! 
 
 
6/11/2006

What's Next: Microsoft CRM 3.0 Mobile - Part 2

We had tested the Microsoft CRM 3.0 Mobile running on the Dell Axim x51v PDA and it performed well (Part 1), now it is time for trying it on one of those hot PDA Phones running Windows Mobile 5 currently available in the US market as of June, 2006:
 
Here are three PDA Phones and their specifications that we've considered.
 
PPC6700 / XV6700
-2.88" 240x320 Pixel TFT Touch Screen
-Intel XScale PXA270 Processor at 416MHz
-64MB SDRAM and 128MB Flash ROM
-Windows Mobile 5.0 Pocket PC Phone
 
Motorola Q
-2.4" 320x240 Pixel TFT Touch Screen
-Intel XScale PXA272 Processor at 312MHz
-64MB SDRAM and 128MB Flash ROM
-Windows Mobile 5.0 Smartphone
 
Treo 700w
-2.5" 240x240 Pixel TFT Touch Screen
-Intel XScale PXA272 Processor at 312MHz
-32MB SDRAM and 128MB Flash ROM
-Windows Mobile 5.0 Pocket PC Phone
 
Why just these three?  There are a lot of PDA Phones on the market, here is a current list of Windows Mobile 5 phones.  I think these three represent the most popular and powerful PDA Phones running Windows Mobile 5.0 that are currently available - please comment to let me know if another model should be added on the above list. 
 
Also, these are the models that many of our Microsoft CRM customers and prospects repeatedly asked about.  Now, we all know that the mobile device market comes out with new models pretty fast, so these three bad boys may not even be on the list next year...
 
Something very interesting immediately came up - none of these phones meet the 3.5" screen size and 526MHz requirements listed for running Microsoft CRM 3.0 Mobile!!!  The good news on screen size is that it really doesn't matter as long as the screen resolution requirement is met which is 240x320.  Regarding the processor speed, well, I guess the only thing we can do is observe the performance...
 
Oops, looks like we need to eliminate the Treo 700w from our list!!!  Even if it is not the screen resolution, the minimum 64MB RAM requirement would have nailed the Treo.  Sorry Treo lovers, maybe wait on the next model for running Microsoft CRM 3.0 Mobile.
 
So we are down to the PPC6700/XV6700 or Motorola Q.  Overall, the PPC6700/XV6700 is a faster device (416MHz vs. 312MHz) and has a bigger screen (2.88" vs 2.4").  Here are other "subjective" points:
 

1. The PPC6700/XV6700 came out a few months earlier which means more "field tested" - has an updated ROM available, more feedbacks/workarounds from the user community. It is a good practice to install the latest ROM (if available) before installing Microsoft CRM Mobile.

 

2. The PPC6700/XV6700 keyboard is much easier on the fingers since the buttons are larger than the Motorola Q.  After typing on both devices, the bigger keypad on the PPC6700 via the sliding out keyboard from the side is a major plus!

 

Gosh, I'd almost missed the point that the Motorola Q is a Smartphone.  This is a problem since Microsoft CRM Mobile only works on Pocket PC or Pocket PC Phone Edition.  So, the Q gotta go...  Link to Pocket PC Phone vs. Smartphone.

 

I guess it is pretty easy at this point - only the PPC6700/XV6700 remains.  And the good news is that the Microsoft CRM 3.0 Mobile was successfully installed on the PPC6700 without any issue!  The installation process was the same as the Axim x51v.  The amazing thing is that the performance is quite good, it feels about the same as that of the Axim x51v!

 

More field usage observations to come...

 

Frank
http://www.workopia.com

5/30/2006

What's Next: Microsoft CRM 3.0 Mobile

We've finally got a chance to play with the just released Microsoft CRM 3.0 Mobile, the setup from the implementation guide was pretty straight forward (for us anyway) and our initial environment was up and running in a few hours.  We've decided to start with the Dell Axim x51v PDA.  The main reason we went with the Axim x51v vs. one of them hot PDA phones is that it will serve as a good baseline - the x51v fulfilled all the Microsoft CRM 3.0 Mobile requirements with extra room to spare... except for the phone part...  And it supports VGA screen resolution mode - 480x640 baby!!!  Check out the screen shots below, isn't VGA awesome - so much more space!!!
 
 
Here are some notes on putting this initial environment together:
 
1. Have a baseline Microsoft CRM 3.0 environment that is running properly, setup the environment with only Microsoft CRM 3.0 required components as much as possible to minimize trouble-shooting variables down the road.
 
2. Make sure that someone in your team knows about SSL setup if you are setting up your own Certificate Authority (CA) via Microsoft Certificate Services.
 
3. Use a good "remote control" PDA tool such as the Pocket Controller Professional from SOTI.  This saved us a lot of time!!!  I'm able to terminal service into our Microsoft CRM 3.0 test environment running Microsoft CRM 3.0 Mobile and also "remote control" the x51v while being far away from the lab - very cool!
 
 
More Microsoft CRM Mobile links:
 
 
 
 
 
 
Lastly, lot of folks asked me what is the big deal about Microsoft CRM Mobile...  And my response is that it will be the next practical "must have" technology for the majority of outside field representative roles in the Small Medium Businesses space!  Because they can "afford" to implement it now.  Welcome any comment if you agree/disagree?
 
 
 
 
 
 
 
4/3/2006

Convergence 2006: Meeting with Jeff Raikes

Wow, what a wonderful event - Convergence 2006 rocks!  I had a great time meeting with others around the globe that are super passionate about Microsoft CRM as I am - these folks range from Microsoft CRM engineers to Value Added Resellers (VAR).  There were a lot of "Love" for Microsoft CRM 3.0!!!
 
During Convergence, I'd felt like I was in an amusement park - so much to see and play, all the walking back and forth for 4 straight days were worth it, next time I should wear tennis shoes!
 
The Microsoft CRM General Session with Brad Wilson and David Thacher really showcased the future direction of Microsoft CRM.  The big announcement is the new Hosting/Subscription offering!  It is here... Salesforce.com better watch-out!  It just amazes me how these two Microsoft CRM General Managers have positioned Microsoft CRM 3.0 to be able to serve all three business market segments - Enterprise, Mid-Market and Small Businesses in such a short time frame!  My hat is off to you, Brad and David!
 
Now, it was not all play at Convergence, I did do some work - mind you...  I'd co-presented at two Microsoft CRM sessions, one was focused on Microsoft CRM 3.0 Small Business Edition with Sean McNellis and the other was on Microsoft CRM 3.0 Reports with Dana Martens!  Sean and Dana are super smart individuals who really know their stuff.  They and their teammates are also the ones that help bail-out partners and customers on Microsoft CRM technical issues!!!
 
Lastly, I was invited to meet Jeff Raikes, President of the Microsoft Business Division.  No surprise, we've talked about Microsoft CRM...  It was a huge honor to meet Jeff like this, I guessed I had a winning lottery ticket!  Jeff is a real down to Earth guy, during his Keynote on Sunday morning, Doug Burgum introduced him as "a farm boy that went to Stanford..."  It was very comfortable talking with Jeff, he really listens to you and offers helpful advice when asked.  Well, this is a Kodak moment for me, thank you Jeff!
 
So Jeff, could I get some special seating at the Seattle Mariners baseball games?
3/15/2006

Easier Install: Microsoft CRM 3.0 Less Dependency on Active Directory

Gosh, I've been installing Microsoft CRM since v1.0 (starting with v1.0 Beta in 2002) - All I can say is that 3.0 continues to amaze me on how much easier it is to install and comes with much improved proactive pre-install checks.
 
For example, here are some observations:
 
1. Active Directory can be in Mix Mode!!!
 
2. Microsoft CRM can be installed in any sub-domain within a Domain Forest (no special tweaks needed)
 
3. The stand alone Windows 2003 Domain Controller(s) does not have to at SP1
 
 
 
I'd recalled back in the days with v1.0 where if you'd missed a step/requirement setup - the whole thing would blow up without much warning...  I do not miss those days :-)
 
 
 
 
 
3/11/2006

Must Checkout: Microsoft Convergence 2006

I'd highly recommend anyone that is serious about Microsoft Dynamics CRM to attend this event.  Yours truly will be a speaker for some Microsoft CRM sessions - guess which ones??? 
 
Hope to see you all there so we can share good stories about our Microsoft CRM experiences.
 
Convergence 2006 website:
 
Convergence 2006 Blogger website:
 
 
 
 
3/5/2006

How To: Displaying the Knowledge Base object in Microsoft CRM Outlook Client

How To: Displaying the Knowledge Base object in Microsoft CRM Outlook Client

 
This is very helpful when you'd like to access the Knowledge Base from within the Microsoft CRM 3.0 Outlook Client.
 
Enjoy and please comment!


Frank
http://www.workopia.com
1/29/2006

How To: Displaying the Parent Account field from the Microsoft CRM v3.0 contact form in the Outlook 2003 Contacts view

This is one of the Microsoft CRM 3.0 Customization How To Articles that I've written. My aim is for these articles to be very reader friendly (MSCRM beginners and up) with step by step instructions and lots of screen shots.

How To: Displaying the Parent Account field from the Microsoft CRM v3.0 contact form in the Outlook 2003 Contacts view
This is very helpful when you'd like to quickly tell within normal Outlook View which contact is a Microsoft CRM contact.  Also good for sorting/cleaning up your regular Outlook contacts and Microsoft CRM Outlook contacts.
 
Enjoy and please comment!


Frank
http://www.workopia.com
1/28/2006

News: My New Microsoft CRM Blog Space

Alrighty, I will be using this blog space going forward to share my experiences on Microsoft CRM - one of my New Year resolutions!
 
 
For a link to my previous Microsoft CRM blog space:
 
Updated 3/17/2008