DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  

Office System - David Overton's Blog

  • Partner Training - Introduction to Microsoft Partner Program & Windows and Office Genuine Advantage

    This course will help the partner look at this year’s Microsoft Partner Program and how it’s more focused than ever on embracing more of your success, making it easier to differentiate your business and simplifying how you do business with Microsoft. We will also be looking at how Piracy interferes with this great opportunity for new sales and services with Windows Vista and Office 2007. https://training.partner.microsoft.com/plc/register.aspx?publisher=3&courseid=1876 Ttfn David
  • System Builders - Partner training on the OPK for Windows Vista and Office 2007

    This course looks into the new OEM Pre-installation Kit (OPK) for Windows Vista and 2007 Office. It explains to system builders OPK's functions and benefits; how it is deployed; what are some of its terms and requirements; as well as the tools and resources offered. https://training.partner.microsoft.com/plc/register.aspx?publisher=3&courseid=1875 ttfn David
  • If you have upgraded your SBS WSSv2 Companyweb site to WSS v3, there is hope to fix it

    Technorati tags: WSS , Companyweb , Windows SharePoint Services , SBS 2003 R2 , sbs 2003 I have seen two entries on this today that need flagging. The 1st is the re-iteration by Susan Bradley that everything works baring e-mail in a WSS v3 site - providing you are not upgrading a WSSv2 site on SBS. Side-by-side installs work with this exception. It is still vital that you read this document before you do the upgrade. However, I have had several people mail me asking how to recover. I asked the same question inside Microsoft and was told that a potential solution has been documented in a blog - http://blogs.technet.com/edwalt/archive/2006/11/29/removing-wss-3-0-companyweb-upgrade-restoring-wss-2-0-on-sbs-2003.aspx . This is almost certainly great news for those who ruin their site. There is a word of warning - you need a backup of your WSS v3 companyweb database. ttfn David
  • Building Office Live applications - this is where you need to start

    I had a partner ask me about Office Live today, so these are the places you need to start: 1) Client SDK - Windows Live ID Client 1.0 SDK in Alpha 2) Web Based Info - http://forums.microsoft.com/msdn/showpost.aspx?postid=924592&siteid=1 and http://msdn2.microsoft.com/en-us/office/aa905514.aspx 3) Windows SharePoint v3 APIs - Working with Windows SharePoint Services 3.0 Web Services (what is supported from WSSv3 and what is blocked) 4) Some important sections: How to: Integrate Access 2007 and Excel 2007 with Office Live How to: Integrate Office Live with other Office 2007 applications Chris's unofficial Office Live developer blog That is it for now - the client SDK is key - you can build rich client applications and then share data via the OfficeLive web. nice. ttfn David Technorati tags: Office Live , Live , Saas , Software as a service , software with service
  • Infopath training

    There are then a number of labs online - http://msdn2.microsoft.com/en-us/library/bb251751.aspx covering Lab 1: Publishing an InfoPath 2007 Form Template to a Server Running InfoPath Forms Services Lab 2: Deploying and Managing InfoPath 2007 Forms Lab 3: Integrating InfoPath 2007 with the Data Connection Library Lab 4: Enabling Digital Signatures in InfoPath 2007 Form Templates Lab 5: Importing Word Forms into InfoPath 2007 Lab 6: Using InfoPath 2007 E-mail Forms Lab 7: Restricting Permissions to InfoPath 2007 Forms and Form Templates Lab 8: Using the InfoPath 2007 Object Model and Visual Studio Tools for Applications Lab 9: Designing InfoPath 2007 Forms for Mobile Web Browsers Lab 10: Creating and Inserting InfoPath 2007 Template Parts Lab 11: Integrating InfoPath 2007 Forms in Web Sites Using Visual Studio Lab 12: Using SharePoint Server Workflows with InfoPath 2007 To use these labs you need a number of downloads found at InfoPath 2007 Sample: Training Labs . ttfn David Technorati tags: Infopath , Training...
  • How to speed up displaying other peoples calendar in Outlook 2007

    If you have Exchange in use then Outlook 2007 may well have the caching of people's calendars turned on. This means that when you open a calendar you have to wait for the cache to populate, which can slow things down a bit sometimes. This is how to turn it back to how it was with Outlook 2003. 1. Go to the Tools Menu and select Account Settings 2. Select your Exchange Account and press the change button 3. Press the more settings button 4. Select the 2nd tab (Advanced) 5. Un-tick the "Download shared folders" option. Note that this will stop cached Sharepoint folders from downloading into Outlook too. 6. Press OK until all options are saved. ttfn David Technorati tags: Outlook 2007 , calendar , Office 2007 performance
  • Do you want to be able to see PDFs previewed in Outlook 2007 and the preview pane in Vista Explorer? What about C#, VB, SQL and javascript code?

    This has been banded about a lot inside Microsoft, but it is just too good to ignore. Enjoy!! Foxit PDF Preview Handler in my daily work i spend a majority of my 'computing' time in outlook. communicating with peers, team members, customers, etc. is mostly done via communication (sad, i know). a lot of that time it involves sending information attachments back and forth, using office documents, etc. i've said a lot about how much i love the preview functionality within vista and office 2007. i even wrote a code preview handler for .cs, .vb, .sql, .js files. one of the samples in the msdn article was for pdf files...of which i receive a lot. i don't use adobe reader because i think it is overkill for reading pdf's personally. the sample, however, relies on having adobe reader installed...which i didn't like. i started working with the foxit activex sdk , because i love their reader product. after some communication with the team at foxit, we started collaborating. as a result of that collaboration, foxit software...
  • Microsoft Rolling Out ODF Document Converter and participating in Standards processes

    This is not new news, but when I was at the Technet event yesterday it did come up. Someone asked about the what and why of Open XML and Open Document format. Luckily Darren Strange was on hand to answer the question (which he has done before). ODF is a great standard, but does not allow for amny of the things that our customers want, such as charts (to name just one). It is not unusual to have more than one standard way to do things (such as ASCII and EBDIC for character sets), so while ECMA has ratified OpenXML we are now working with a 2 nd standards body (ISO) to also get OpenXML ratified there too. For more information about the ODF converter, have a look at http://sourceforge.net/projects/odftranslator/ for the code and this article for news - Microsoft Rolling Out ODF Document Converter . Ttfn David
  • Do you want to trial Exchange Server 2007, perhaps talk to the server? If so, look at the Microsoft Exchange Server 2007 Hosted Trial

    I saw this over at Henrik's blog and throught it might be of interest to the SBSC community. I like this. While I discovered that demoing something like this using a free VoIP service was a bad idea, using OK quality phones delivers an amazing experience. Obviously we will not see Exchange 2007 embedded in SBS until Cougar ships, it can still be provided as a hosted service, on a 2nd machine or for a partner internally using the Action Pack copy that should ship next month (fingers crossed). For more information, pop over to Henrik's blog on the subject, including the link to the trial. Microsoft Exchange Server 2007 Hosted Trial Like it was the case right after Exchange 2003 RTM, you can also sign up for an Exchange 2007 tempoary account… “Welcome to the Microsoft Exchange Server 2007 Hosted Trial web site. You can create a temporary account to experience the features of Exchange Server 2007 which will stay active for 5 days. Your account will be pre-populated with sample messages, calendar appointments and a...
  • Channel Expo Show presentations - Windows Vista, Office 2007 and Windows Server (SBS, Naked, Home Server and Longhorn) sales slides

    If you visited the Channel Expo show this year then you probably saw one or two Microsoft presentations on desktop and server solutions. James Akrigg and Matt McSpirit provided the desktop entertainment while I covered off what servers we have out there and what is coming in the near future. We promised the slides and here they are: Desktop (Windows Vista and Office 2007)- Office 2007 PowerPoint Desktop (Windows Vista and Office 2007)- PDF Server (SBS, Windows Server 2003 R2, Longhorn and Home Server) - Office 2007 PowerPoint Server (SBS, Windows Server 2003 R2, Longhorn and Home Server) - PDF James has an amazing blog (Out of Office) at http://blogs.technet.com/outofoffice Matt touches many aspects of desktop technology including that for small business at http://blogs.technet.com/mattmcspirit Have a look at the blogs and enjoy the presentations. ttfn David Technorati tags: Channel Expo , Vista , Office 2007 , SBS 2003 , Nakes Servers , Home Server , Longhorn
  • Job aids (things to help you do your job) with Microsoft Office 2007

    2007 Microsoft Office System Be productive while using the new versions of Microsoft Office desktop applications. · Microsoft Office Fluent User Interface Get Started · Microsoft Office Charts and SmartArt Get Started · Microsoft Office Styles Get Started · Microsoft Office Tasks Get Started · Microsoft Office Tasks Learn More Everyday Work Discover best practices for working with e-mail, organizing your time, and more. · Windows Vista and Microsoft Office Work Smarter Checklist · InfoPath 2007 Forms Get Started E-mail · E-Mail Basics Get Started · Outlook 2007 E-Mail Signatures Get Started · Outlook 2007 E-Mail Rules Get Started · Outlook 2007 Out of Office Assistant · Delegating Outlook 2007 Access Learn More · Outlook 2007 and SharePoint Server 2007 Integration Overview · Outlook 2007 and SharePoint Server 2007 Integration Get Started · RSS (Really Simple Syndication) Overview · Subscribing to Web Content with RSS Time and Task Management · Microsoft Office Tasks Get Started · Microsoft Office Tasks Learn More...
  • bCentral (UK) competition - Win 5 laptops – all with the ‘Wow’ factor of Windows Vista Business and Microsoft Office Small Business 2007 – plus a wide screen TV

    I saw that this is closing in a few days - the site has a find a partner link to find SBSC partners by post code and obviously the competition: Microsoft Small Business Centre - Microsoft Office 2007 small business Edition and Microsoft Windows Vista, the software for your Small Business PC We’re offering a special prize of 5 laptops – all with the ‘Wow’ factor of Windows Vista Business and Microsoft Office Small Business 2007 – plus a wide screen TV! To win, tell us how the ‘Wow’ factor can help your business. See Windows Vista Business and Office 2007 in action at your local PC store. PC World, Comet, Staples, John Lewis and Micro Anvika are all running regular demos. For details of demos at your local store, download our schedule . Find a Partner to help you add the ‘Wow; factor to your IT and upgrade to Windows Vista Business and Microsoft Office Small Business 2007. ttfn David Technorati tags: Win Vista and Office , bCentral
  • Which 2007 Office Application Are You?

    I did this " Which 2007 Office Application Are You? " and apparently I am Excel You are Excel 2007! People trust you to find the right answer. They call you "the wizard" and are in awe of your PivotTable. When you say you love functions, it's understood that you're referring to spreadsheets, not social events. You import and export with ease, always maintaining balance. Thanks to your mastery of numbers, people are constantly asking you for help with their own budgets. With the new Microsoft Office Excel 2007, you'll see how those people can get their own answers - better and faster. They will be amazed that they, too, can create a new chart with only five clicks. You may not have been known as a trendsetter, but your ability to use conditional formatting to "see" new trends was well worth any wait. You can analyze the impressive productivity and efficiency gains in Excel 2007 and prove that the benefits justify the costs. Your favorite new feature in Office 2007 is likely...
  • May security updates for Server DNS and Office 2003/2007 and IE7. Also Quicktime needs an update

    I did a quick scan and it seems that this month Office is the main target of updates, along with one critical one for Windows Server (for DNS RPC attack) and one for IE7. Worth a quick download and install :-) I also got this in the mail today: Apple QuickTime 7.x must be upgraded to 7.1.5 or higher. On the security updates: Microsoft is releasing the following new security bulletins for newly discovered vulnerabilities: Bulletin Number Maximum Severity Affected Products Impact MS07-023 Critical Microsoft Excel (all currently supported versions) Remote Code Execution MS07-024 Critical Microsoft Word 2000, 2002, 2003, 2004 (Mac) Remote Code Execution MS07-025 Critical Microsoft Office (all currently supported versions) Remote Code Execution MS07-026 Critical Microsoft Exchange (all current versions) Remote Code Execution MS07-027 Critical Internet Explorer - all current versions on all currently supported versions of Microsoft Windows Remote Code Execution MS07-028 Critical CAPICOM, BizTalk Server Remote Code Execution...
  • If you want to get UK dialect words into the Microsoft dictionary then send the words asap (by 31st May)

    I have only just seen this in my inbox, but it looks worth doing!! Do you have a ‘benny’ if you can’t find ‘owt’ in your familiar local lingo when you are writing documents and letters? To celebrate the launch of the 2007 Office system and the richness of the British language, Microsoft has partnered with the British Library to develop a series of online dictionaries made up of local dialects...and we want you to contribute! How many people talk about ‘hoying’ a ball or even taking a ‘crib’ when they have a cup of tea? With an ever increasing mobile population, Microsoft and the British library and keen to preserve local identities and heritage. Jonathan Robinson, curator of English accents and dialects at The British Library says: “Britain has a rich heritage of different accents and dialects and, contrary to popular opinion, there is still a great deal of lexical diversity across the UK - where else would you find the words ‘cob’, ‘batch’, ‘bun’, ‘barm cake’, ‘stotty cake’, ‘scuffler’ and ‘bread cake’, all meaning...
  • Chris Parkes: Microsoft Office Word 2007 and OpenOffice.org 2.2.0 Mail Merge Comparison

    I know I need to wear my flame proof shorts for posting this, however, Chris has done an amazing post comparing the pain, process and time of doing a mail merge in Office 2007 and Open Office. He found that something that he could do without trouble in Word was not easy to understand and ONCE ALL SETUP, still took five times longer to then just process itself. When time is money, this pays for itself in Office 2007 (or 2003 or XP :-) ) All in all, the whole process took just under fifty minutes , five times longer than it did using Microsoft Office Word 2007 although this was considerably longer on my first few attempts as I struggled to locate the functionality in OOo and how to put the whole thing together. The conclusion... The time taken to complete essential tasks therefore is extremely important. If organisational end users were to be so unproductive then staffing overheads would considerably increase. Whereas Microsoft Word 2007 handled the process with the minimum of fuss and flexibility, using OOo actually...
  • Microsoft Office Communications Server 2007 Public Beta

    I just came across this. Should you want to play with our VoIP solution that also integrates into Exchange 2007 then this is for you. Microsoft Office Communications Server 2007 Public Beta Microsoft Office Communications Server 2007 provides users with streamlined real-time communications on an extensible VoIP foundation that provides the operational control your organization requires. Featured Resources Now available: Microsoft Office Communications Server 2007 public beta Download Microsoft Office Communications Server 2007 Public Beta with Office Communicator 2007. Download the documentation for Office Communications Server 2007 beta Featured Webcasts Join us for an overview of Microsoft unified communications solutions and to learn more about Microsoft Office Communications Server 2007. Microsoft Unified Communications Overview Microsoft Office Communications Server 2007 Overview Scenarios for Using Office Communicator 2007 Source: Microsoft Office Communications Server 2007 Public Beta ttfn David Technorati...
  • Clint Covington: Software design, Microsoft Office Access : Cool As Ice uses Office Live and Access 2007 with custom ribbon

    I saw this and thought you might like to see how one ISV has joined Office Live and an Access application. Web access and rich client applications. Nice!! Here is some information about the Access 2007 application that I’ve developed for Cool As Ice, which is a leading Norfolk-based supplier of air conditioning and refrigeration here in the UK. Cool As Ice wanted a bespoke customer contact system that they could use to hold data securely yet allow their workforce to use that data on their laptops, including adding and altering data, i.e. not just a read-only copy. Access 2007’s integration with Sharepoint meant it could provide the basis for a good solution. The application holds its data in a workspace that is part of my company’s Office Live site. The choice of Office Live to provide the SharePoint part of the solution means that their data is secure and that Cool As Ice do not need to get involved in organising that part of the solution, concentrating instead on the things they do best. Backups of data are...
  • Do you want to ask Microsoft the hard questions on Vista and Office before you sell them to your customers - well now you can in June - Live!!

    Your Office and Vista questions answered We are offering UK partners the opportunity to talk directly to one of Microsoft Europe's leading technology specialists in a series of online Q&A sessions. These sessions will seek to answer the nitty gritty questions you need to answer to transition your customers over to Windows Vista and Microsoft Office 2007. Book your place now. Register for 4 June Register for 5 June Register for 6 June Register for 7 June Register for 8 June ttfn David Technorati Tags: Microsoft , Vista , Office , Partners
  • Getting data out of or into Office 2007 documents just got easier with the Open XML gets an SDK

    If you are still undecided in the Open XML debate, or decided but want tools to make it easier then hop over to James blog and have a look at Views on Windows Vista : Open XML gets an SDK : Yesterday Microsoft announced a SDK (Software Development Kit) for SDK which allows developers to create code which works well with the Open XML thanks to the libraries, samples and documentation provided by the SDK. You can download the SDK here . If you now think that having this as a standard is a good idea, please go to here to add your vote. ttfn David Technorati tags: open XML , Office 2007 , Office System
  • Technet Answers on licensing Office 2007 for Terminal Server and Disaster Recovery licensing

    I was reading the latest Technet newsletter and saw this and thought I would pass on these two items: 2. How do I license Microsoft Office so my users can access it over Terminal Service? Microsoft has produced a Word document (126Kb) that discusses the options available to customers who would like to configure access to Office in this way. 3. How does Microsoft license its products for use in a disaster recovery situation? View the guide to "Cold" Server Back-Up for Disaster Recovery" . ttfn David Technorati Tags: Licensing , DR , Disaster Recovery , Office 2007 , Terminal Services
  • Search Appliance from Scan for use inside your business based on Microsoft SharePoint technologies

    Lets be honest, when it comes to searching a desktop's files, Vista is the best. When it comes to searching the internet, some other vendors do a pretty good job. Now, to help you search all the files in your business you can search the whole lot through a server appliance. Now that might not be that exciting, but it is important that you use something that is designed to search business files and not the internet as the search engine here. Microsoft UK and SCAN Develop MOSS Search Appliance Microsoft in the UK have broken new ground, partnering with SCAN technolgies to develop a Search Appliance based on MOSS. The appliance will be offered across the MOSS SKU range and hardware specification can be tailored to meet customer requirements http://sharepoint.microsoft.com/blogs/fromthefield/Lists/Posts/Post.aspx?ID=12 ttfn David Technorati Tags: MOSS Appliance , Search , SharePoint
  • Worldwide Partner Conference - WPC in Denver - what I know so far - Office Live and Windows Live as a platform for partners to build on

    Office Live is already a great success, but today Microsoft announced even more to make it a business for partners to make success for them and their customers. We've released information about partners, solutions and using Windows Live, sample sites and more information on how to make it a business success. Have a look at Microsoft Office Live Launches Partner Program, Helps Partners Reach Small Businesses for more information. Add to this the extra opportunities that Windows Live also brings and the new tools to build on there too ( http://partner.live.com/windowslive/ ) and you really start to get something amazing. The press release Microsoft Office Live Launches Partner Program, Helps Partners Reach Small Businesses includes a reference from Solution Canvas: Solution Canvas is a Glasgow, Scotland-based Microsoft Gold Certified Partner that uses the Microsoft Office Live platform to host justia, a powerful practice management system for small legal firms. justia offers a cost-effective solution that provides...
  • How to add a trade-in line item (i.e. give cash back to discount a deal) to BCM 2007

    Someone asked me how to do this and I discovered that you can't have a negative discount percentage, negative quantity or negative price. So this makes it impossible to do... well, no, but it is not quite as easy as we would like. To make it work you need to create a Product and Service csv file to import to make it work. Here are the step by step instructions on installing it and using it. Installing the trade-in items Go to the BCM menu and select the Product and Services menu item Press the import button at the bottom of the dialog to get the screen shown on the left Create a csv file on your desktop called tradein.csv (start / run "notepad %homepath%\tradein.csv") Copy and paste the text below into the text file and save Trade In (10000), Trade in, -10000 Trade In (1000), Trade in, -1000 Trade In (100), Trade in, -100 Trade In (10), Trade in, -10 Trade In (1), Trade in, -1 browse the csv file on your desktop and press import Job done Using the trade-in items in an opportunity Now we have these...
  • How to use Office Outlook 2007 with any internet connection and how to access Outlook Web Access from any web browser - all in a Video presented with Silverlight

    The Video I have delivered a number of Vista and Office demos over my time, so I decided to record a number of them for others to borrow, use, learn from or anything else they choose. This video covers the following subjects in enough detail for people to hopefully understand what they need to know on how to use Outlook via a web browser and via an internet connection: Outlook Web Access with recent browser (IE5 or above) Outlook Web Access basic or lite edition for low speed internet connections Configure Outlook to use RPC over HTTP To see the video played using Silverlight (just try it) click here *. I am hoping that in the near future that the WMV file will be available at new bCentral - the UK Small Business Center on MS.com. At the moment it is not available there, but a copy can be found here * it will take a few moments to open if you have Silverlight installed and require you to download Silverlight if you don't, but it is a 1MB download How I made it I simply ran through part of my normal demo talking...

(c)David Overton 2006-23