David Overton's Blog and Discussion Site
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. I specialise in Windows Intune and SBS 2008.
This blog is purely the personal opinions of David Overton. If you can't find the information you were looking for e-mail me at admin@davidoverton.com.

To find out more about my Windows Intune BOOK - Microsoft Windows Intune 2.0: Quickstart Administration click here

To find out more about my SBS 2008 BOOK - Small Business Server 2008, Installation, Migration and Configuration click here

Browse by Tags

David Overton's Blog

Buy my books

Windows Intune:Quickstart Administration


This is the RAW book (Read as Written).
Click here for more information
Buy or pre-order today

SBS 2008 - Installation, Migration and Configuration

Small Business Server 2008 – Installation, Migration, and Configuration

Buy today in book or e-book form

Request a Review Copy

Twitter

Syndication

  • Need to buy a copy of Windows 7 or Office 2007 for someone in education - get an educational discount

    HI, I've been asked this many times, so I thought I would blog on it.  Microsoft offers great discounts for people in education (beyond those who work in education).  The best options are: For university students: http://www.microsoft.com/student/discounts/theultimatesteal-uk/default.aspx - – Office £38.95, Windows 7 Pro - £30 For any age group in education - Office 2007 for around £39- £52 depending on which edition (Standard to Enterprise) and Windows 7 upgrades for £40-56 depending on the edition http://www.software4students.co.uk/ http://www.rm.com/shops/thebasement/Range.aspx?nguid=480909c5-102c-4700-8739-f3feedbb6a6d http://www.rm.com/shops/thebasement/Range.aspx?nguid=59137e0c-6185-4d95-a360-a680d60636ea     There are obviously some conditions you have to meet to qualify to use these products and each site has information about them.  If you are in full time education or a parent of someone who is then you likely qualify.  To learn more about Microsoft and education in the UK, have a look at http://www.microsoft.com/uk/education/default.aspx .  You will notice that both the organisations I linked above are linked on the Microsoft page, but I have experience with the above two.   Thanks David Technorati Tags: Windows 7 , Office 2007 , Education , Student discount , Microsoft
  • How to copy or archive files by year using the command line and robocopy

    I got this question via e-mail and decided I would post the answer here in a blog. I want transfer all files created in Office Word 2003 by year (annual batchs - ex: 2005, 2006, etc.) to external HD. How can to do this? I will appreciate your answer. Edgar To do this via the command line you can use Robocopy which is present in Windows Vista and Windows 7.  If you have Windows XP download the Server 2003 Resource Toolkit and install it.  Robocopy will be part of the install and found in the install directory. The actual command would look like this and would need to be entered into a command prompt: for /L %x in (2009,-1,2000) do robocopy source destination \%x *.doc? /minage:%x0101 /maxage:%x1231 /s To break it down a bit.. for /L %x in (2009,-1,2000) do This creates a counter from 2009 up in steps of -1 (or down in steps of 1) until 2000 is reached.  Each time the counter changes it is set into %x, so %x will become 2009, 2008 and so on.  It then executes the command after to "do". robocopy source destination \%x *.doc? /minage:%x0101 /maxage:%x1231 /s The robocopy command is very flexible.  Details of it can be found on the wiki page here .  The first two parameters are the sounce and destination locations.  so it might be c:\users\david\documents and F:\document_backup.  Note the \%x on the end.  This means it will put the files inside a folder on the destination location that matches the year you are archiving. *.doc? is a limiter to the files to be copied - if you want all files, simply remove it.  This will copy all Office 2003 and 2007 document files - if you only want Office 2003, use *.doc and don't include the question mark. The minage and maxage state how old the file is.  It can either be in days or a date in the form of yyyymmdd.  So with the %x set to 2009, the command will have /minage:20090101 /maxage:20091231 which equates to everything in 2009 and so on. The /s copies all subdirectories too You can optionally put the /MOV...
  • Outlook Anywhere (RPC over HTTP) not working or slow with SBS 2008

    I’ve been working with the Microsoft support teams to diagnose non-connection and very slow syncing for someone who uses SBS. The team came up with a fix and while there is no KB article on this yet, below is a link to a workaround that made logging on go to a few seconds from what was about 5 hours :-) Slow Connectivity for Outlook Anywhere and Sites that use the SBS Web Applications App Pool [Today's post comes to us courtesy of Wayne McIntyre, Justin Crosby, and Damian Leibaschoff] We are currently investigating an issue where connections to Outlook Anywhere are extremely slow or fail completely. This issue also affects other sites that use the SBS Web Applications app pool. If you notice these symptoms and wish to verify you are experiencing this problem, open IIS management console and check the worker process queue for the SBS Web Applications app pool as shown below. The Official SBS Blog : Slow Connectivity for Outlook Anywhere and Sites that use the SBS Web Applications App Pool ttfn David Technorati Tags: SBS 2008 , Exchange 2007 , RPC/HTTP , Outlook , Outlook Anywhere , Microsoft
  • The PowerPoint Team Blog : A Picture + 1000 Words…

    Want to know how to create amazing work in PowerPoint – look at the PowerPoint team blog! The PowerPoint Team Blog : A Picture + 1000 Words… We learn best by examples. And the better the example, the better the results. That’s why its a pleasure to point you to a new group of PowerPoint examples that are stunning, inventive, evocative… simply beautiful. Nice enough if it stops there, but each and every one of these examples includes very detailed instructions on how you can reconstruct the design, and learn how to apply the technique to your own work. Animation for graphics and text, static text effects, photographic effects, new background techniques, Smart Art and transition effects… this is a holiday present come early for PowerPoint users. And they’re free! Get them here . Here’s a small sample, which of course does not include the amazing animated designs. And in case you’re wondering, this is the work of PowerPoint MVP Julie Terberg of Terberg Design . Julie has done some amazing work for all you PowerPoint customers to benefit from and enjoy. Do let us know what you think! Amazing! ttfn David Technorati Tags: Microsoft , PowerPoint , Tips , Office System , Office 2007
  • Office Small Business 2007 – get up to 25% off in the UK

    I saw this at the Special Offers site from the Small Business team and thought I would share. Office Small Business 2007 – get up to 25% off Buy Office 2007 Small Business Edition before 17 January and you can get a discount of up to 25%. Enhance productivity in your workplace and manage tasks and your customers more efficiently with Microsoft Office Small Business 2007. Excel, Word, Publisher, Outlook and PowerPoint provide all the tools you need to give your business a professional edge. (Offer applies to FPP (Fully-Packaged Product) only, ie not via volume licensing or OEM etc.) Availability: UK Small Businesses Valid from: December 21 2008 Offer expires: January 17 2009 How to buy: Equanet: Microsoft Office 2007 Small Business CD Equanet: 2007 Version Upgrade Grey Matter: Microsoft Office 2007 Small Business CD MacWarehouse: Microsoft Office 2007 Small Business CD MacWarehouse: 2007 Version Upgrade Microwarehouse: Microsoft Office 2007 Small Business CD Microwarehouse: 2007 Version Upgrade PC World Business: Microsoft Office 2007 Small Business CD PC World Business: 2007 Version Upgrade WStore: Microsoft Office 2007 Small Business CD MS Store: Microsoft Office 2007 Small Business CD Hopefully it will make a nice present for the New Year. Have a Merry Christmas!! David Technorati Tags: Microsoft , Small Business , Office 2007 , Offer , Partners
  • Want to legally download Microsoft Software (Vista, Office, Works, Maths and Expression) - go to the www.MicrosoftStore.co.uk (UK & Germany for now)

    I would have put money on this not happening this year, but finally there is a legal place for people to download full copies of Microsoft products. Go to http://www.MicrosoftStore.co.uk and you can buy software and download it there and then. At the moment this is limited to the UK and Germany, but I would personally expect it to go broader like all Microsoft ventures! I suspect the list of products will also expand. ttfn David Technorati Tags: Microsoft , Windows Vista , Office 2007 , Works 9 , Expression , Buy , Download , Shop
  • How to find ANY command on the new Office Ribbon – Search for it with Search Commands

    There is a great web site out from Microsoft called OfficeLabs and one of the 1st great things published is: Project: Search Commands  Search Commands helps you find commands, options, wizards, and galleries in Microsoft Office 2007 Word, Excel and PowerPoint. Just type what you’re looking for in your own words and click the command you need. Search Commands also includes Guided Help, which acts as a tour guide for specific tasks. Crave more info? FAQ - get answers to frequently asked questions Blog - read the latest news from the team Discussions - connect with other users  Click here to download. Requirements: 32 bit Windows XP or Windows Vista. Office 2007. Limitations: English only. Works with Word, Excel and PowerPoint only. Give it a try!! ttfn David Technorati Tags: Microsoft , Word 2007 , Excel 2007 , Office 2007 , Search , Ribbon , find , If you only read one post today
  • Want to know more about Windows Sharepoint Services 3.0? Make time from 6pm in London on the 29th April 2008. Remember that you can load WSS v3 onto SBS 2003 and it is a part of SBS 2008 (Cougar) and Essential Business Server 2008 (Centro)

    I have said many a time that SharePoint will be a key asset for small business partners now and in the future and all the press suggests the exact same thing. Vijay has arranged, and will be presenting, at an Event in London with Steve Smith, Craig Carpenter and Bill English . Given the quality of the speakers, I would suggest that you sign up early to say that you will be there: Windows Sharepoint Services 3.0 Event for SBSC Partners on 29th April 2008 Venue & Time Microsoft London , Cardinal Place, 100 Victoria Street, London, SW1E 5JL meeting at 6.00pm for a 6.30pm start and 9.00pm finish. Presentations from some of the worldwide experts on Sharepoint on Windows Sharepoint Sservices 3.0 which will be a key component of SBS 2008 and which can be installed as a side-by-side installation on SBS 2003. Presenters Steve Smith MVP and Craig Carpenter (co-owners of Combined Knowledge one of the leading Sharepoint Training Consultancies). Steve is also one of the organisers of the Sharepoint User Group in the UK. Check out the bios here . Bill English MVP of US based Mindsharp and author of a number of MS Press Books on Sharepoint will be presenting on WSS User Management on the new DeliverPoint Platform. To register either leave a comment with your name and company or drop me an email at vijay@iqubed.biz . We are expecting a lot of interest and it will be opened up to the Sharepoint User Group as well ttfn David Technorati Tags: SharePoint , WSS , Windows SharePoint Services , SBS , SBS 2003 , SBS 2008 , Cougar , Office System , Office 2007
  • Are you a student, got an e-mail with .ac.uk and want Office 2007 Ultimate Edition (got everything edition) for £38.95? You can legally own this at this price until 30th April 2008

    I posted on this a little while back, but I thought I would do so again: If you're a student with a '.ac.uk' email address , you can get Microsoft Office Ultimate 2007 for £38.95, an estimated 90% off the retail price. This is a fantastic offer, so make sure you go to http://uksbsguy.com/r.ashx?T which is a short cut to the site http://www.theultimatesteal.co.uk , but also has an ability for me to see how many people click it. Feel free to pass on to everyone who is a student in the UK and tell your friends not to miss out too! The offer closes on April 30th 2008. ttfn David Technorati Tags: Student , UK , Education , Office 2007 , Office , Office 2007 Ultimate , ac.uk
  • Office Live Workspace Update for Windows Vista to enable "Open From" and "Save to" menu items in Office Word, Excel and PowerPoint

    One little feature that others might have missed with the new release of Office Live Workspace is the two nifty buttons for Office to enable direct access from the Office Live Workspace Update for Windows Vista The Office Live Workspace Update installs three Windows Vista updates (KB945435, KB945145, KB933860) and one Office 2007 update to ensure optimal performance on Windows Vista when using Microsoft Office Word, Excel, and PowerPoint with Office Live Workspace. The update improves the performance of opening and saving Workspace documents from these Office programs. In some cases, the update also resolves problems with "Open from Office Live" and "Save to Office Live" functions of the Office Live Add-in . This update is only needed for computers running Windows Vista. Download details: Office Live Workspace Update for Windows Vista ttfn David Technorati Tags: Live , Office Live Small Business , Office Live , Office Live Workspace , Vista , Windows Vista , Save to , Open From
  • Latest news, events and downloads in the Security world from Microsoft - Windows Server 2008, Mobile, employee habits, Antigen, IPSEC, ForeFront, NAP, XP Firewall, System Center

    Each month the TRM blog product this great summary of the Microsoft world in various product areas. The blog can be found here http://blogs.technet.com/trm/ News Help your customers securely deploy Windows Server 2008 with the Windows Server 2008 Security Guide! http://go.microsoft.com/fwlink/?LinkId=92550 Every day, adversaries attempt to invade your customers’ networks and access their servers—to bring them down, infect them with viruses, or steal information about customers or employees. Your customers are looking to Microsoft and Windows Server® 2008 to help them address these threats. To assist customers in taking full advantage of the rich security features in Windows Server 2008, Microsoft has developed the Windows Server 2008 Security Guide. The Windows Server 2008 Security Guide provides IT professionals with best practices, predefined security templates, and an automated deployment tool to help strengthen the security of servers running Windows Server 2008. Supporting Your Family, Friends, and Neighbours http://go.microsoft.com/?linkid=8287993 By Steve Riley, Senior Security Strategist, Trustworthy Computing Have you become a support professional outside of the workplace? Read this article and learn how to discuss security with your family, friends, and neighbours to better help them stay safe and secure online. More Security and Control for Mobile Devices http://go.microsoft.com/?linkid=8287995 Learn how to add, manage, secure, and update Windows Mobile devices like you do Windows-based laptops and PCs. Microsoft System Center Mobile Device Manager 2008 provides robust security features and a comprehensive device management solution that helps safeguard your corporate data, reduce the cost and complexity of mobile deployments, and centralize and simplify Windows Mobile device management. Island Hopping: The Infectious Allure of Vendor Swag http://go.microsoft.com/?linkid=8287996 The technique of island hopping -- penetrating a network through a weak link and then hopping around systems within that network...
  • Office Live Workspace is now available (in beta) for all - aka Windows SharePoint Services for all small businesses

    According to the site Workspaces (WSS for Office Live users) is now not quite out of beta, but still has a lot to offer: Anywhere Access Save 1000+ Microsoft Office documents in one place Access them from almost any computer with a Web browser No more flash drives or sending yourself documents via e-mail Learn more Share with Others Invite people to your workspace You control who can view, comment, and edit your documents Stop manually merging versions from multiple people Learn more Extend the Microsoft Office Experience Open and save files directly from Word, Excel, and PowerPoint Synchronize contact, task, and event lists with Outlook No need to learn a new program Learn more In terms of what is actually new: Public availability of Office Live Workspace beta at http://workspace.officelive.com with immediate access and no waitlist (English language version only) The easy way to save Office documents to/from the web Organise documents and projects online and work on them from almost any computer (full Firefox support) Invite others to view, edit or comment on documents and workspaces Full document versioning and time-stamping View and comment on documents in the browser, even if Office is not installed Create simple Web notes and Web lists (export to Excel and/or synch with Outlook) Share screen and documents in real time through integration with Microsoft SharedView Brand new features, such as an activity panel, notifications, direct links and multifile upload While this is all very nice, there is actually some excellent materials, including videos and more explaining much at Permanent Link to Microsoft Office Live Workspaces Goes Live and some commentary about Google vs Office Live here and from Tech Radar here which goes as far as to say: Microsoft has launched its equivalent of Google Docs - but without the ability to edit documents. It’s left the actual editing of documents to Office itself and offers Office Live Workspace as a way for individuals and small businesses to share files on the web. A nifty Office...
  • More ways to engage with customers using the Microsoft advertising campaigns

    [updated 4th March] Many people congratulated Microsoft after the Mr Busy campaigns allowed partners to drive their customers back to them using a MS campaign. Well, this is now being repeated for a number of campaigns. Today I found the click and go site to get them all ( http://www.campaigns.arvato-services.com/ ). You can get 200 post cards or 1,000 e-mails for free and then a low price for additional cards/ e-mails if required. The campaigns covered include: Business Productivity Customer Acquisition and Retention Security and Reliability Small Business PC Mr Busy This method of engaging is not new to the Small Business team and others have covered this before (eg Susanne here ), but it is worth re-highlighting this now as some of the campaigns have been renewed, so go back and visit the site!! ttfn David Technorati Tags: Microsoft , Marketing , Campaigns , Business Productivity , Customer Acquisition and Retention , Security and Reliability , Small Business PC , Mr Busy , Partner , SME , Small Business Server 2008 , Mid-Market
  • Office from the past, ODF and OOXML (Office of today and tomorrow) and why is organic growth nearly always bad for software and why re-writing is not good either

    As I have said many times in the past I used to write document conversation tools. I believe this gives me a valid reason to be able to pass comment on the ODF/OOMXL debate that is raging at the moment. If these types of questions interest you, have a look at the book I talk about later ( In Search of Stupidity: Over 20 Years of High-Tech Marketing Disasters (UK) or here for US link ) Lets start with some history about the Office 97-2003 file formats. Joel was writing about this today ( Why are the Microsoft Office file formats so complicated? (And some workarounds) - Joel on Software ). Note that part of what he has commented on is the fact that the documentation for the binary file format is now available from Microsoft: Why are the Microsoft Office file formats so complicated? (And some workarounds) This item ran on the Joel on Software homepage on Tuesday, February 19, 2008 Last week, Microsoft published the binary file formats for Office . These formats appear to be almost completely insane. The Excel 97-2003 file format is a 349 page PDF file. <snipped> If you started reading these documents with the hope of spending a weekend writing some spiffy code that imports Word documents into your blog system, or creates Excel-formatted spreadsheets with your personal finance data, the complexity and length of the spec probably cured you of that desire pretty darn quickly. A normal programmer would conclude that Office’s binary file formats: are deliberately obfuscated are the product of a demented Borg mind were created by insanely bad programmers and are impossible to read or create correctly. You’d be wrong on all four counts. With a little bit of digging, I’ll show you how those file formats got so unbelievably complicated, why it doesn’t reflect bad programming on Microsoft’s part, and what you can do to work around it. The first thing to understand is that the binary file formats were designed with very different design goals than, say, HTML. They were designed to be fast on very old computers. For the early...
  • Import and export business data in Business Contact Manager 2007 - Outlook with Business Contact Manager - Microsoft Office Online

    Again, something I have been asked before - how to get data into and out of BCM - have a look at Import and export business data in Business Contact Manager 2007 - Outlook with Business Contact Manager - Microsoft Office Online Import and export business data in Business Contact Manager 2007 You can use the Business Data Import and Export wizard to import (import: To bring information from one system or program into another. The system or program receiving the data must somehow support the internal format or structure of the data.) data into or export (export: To copy your Business Contact Manager for Outlook business data to a file of a different format for use in a database, a spreadsheet, or another program.) data from Business Contact Manager for Outlook 2007. What do you want to do? Import data Export data Use the wizard to update an existing database with information from another database ttfn David Technorati Tags: Microsoft , BCM , Business Contact Manager , Office 2007 , Office System , CRM , Small Business
  • Business Contact Manager Team Blog - good information, including SQL and VBA tools, Smartphone and product information

    I was hunting for an answer to a questions someone asked me and I came across this the BCM Team Blog. Below are some of the recent posts. It is worth adding to your RSS feed list. Troubleshooting BCM for Pocket PC/Smartphone Get Business Contact Manager with Outlook Standalone How to Change BCM Polling Interval? Happy Holidays Business Contact Manager for Outlook 2007 SP1 is Live Business Contact Manager Team Blog ttfn David Technorati Tags: Microsoft , BCM , Business Contact Manager , Office 2007 , Office System , CRM , Small Business
  • Microsoft Gets Gartner's Business Intelligence Top Ranking -- Business Intelligence

    Remember that BI starts with data in Excel and then includes SQL and builds from there. One of the nice things is that BI is now accessible to any business that wants to analyse their business. Now all that is needed is the understanding of what questions do I want to ask and what data do I have that can help me!! Microsoft Gets Gartner's Business Intelligence Top Ranking The company makes a surprise leap ahead of Business Objects and Cognos in its ability to execute on BI products and pricing. Business Objects and Cognos have long been considered the leaders in business intelligence platforms. But in a surprising new report, Gartner ranks Microsoft ahead of those companies in its ability to execute. Gartner's "magic quadrants" are typically annual market evaluations that place software vendors in one of four quadrants within a square: niche players, visionaries, challengers, and leaders. Specific placement within a quadrant depends on a vendor's ability to execute, which moves them upward, and completeness of vision, which moves them to the right. Business Objects, Cognos, and Microsoft were placed among the leaders in Gartner's just-released Magic Quadrant for Business Intelligence Platforms, 2008. But the research firm placed Microsoft above the other two in its ability to execute, including the competitiveness and success of its BI goods and services, its viability and investment in BI, and the execution of its sales and pricing. In last year's BI platform report, Gartner put Microsoft in the challenger quadrant. Business Objects and Cognos slightly outranked Microsoft in completeness of vision, which includes such things as market understanding, sales strategy, and product development and delivery strategy. By placing the world's largest vendor of commodity software as one of the BI market leaders, Gartner is demonstrating how quickly BI is moving from a specialized, expensive technology into a commodity itself. The rapidly commoditizing BI market, many industry observers believe...
  • Microsoft Dynamics CRM 4.0 VPC Image

    I saw this and thought I would share for those who had not seen it - Microsoft Dynamics CRM 4.0 VPC Image Microsoft Dynamics CRM 4.0 VPC Image Get familiar with the upcoming Microsoft Dynamics CRM 4.0 release: Preview Microsoft Dynamics CRM 4.0 in a Virtual PC (VPC) image. Overview This Microsoft Dynamics CRM 4.0 preview leverages Release Candidate (RC0) code in a Virtual PC image. The demo is designed as a one-computer setup with Microsoft Dynamics CRM 4.0 server and Microsoft Dynamics CRM 4.0 client for Microsoft Outlook. Note: Although the image can be utilised on a single PC or laptop computer, it is strongly suggested that the image be run using an external USB 2.0 hard drive for best performance. If you do not have an external drive, you can run the image locally on the host computer; however, you will experience a decrease in performance. Contents This VPC contains the following: Microsoft Dynamics CRM 4.0 (RC0) Microsoft Dynamics CRM Laptop and Desktop Client Microsoft Dynamics CRM SDK (C:\CRM Tools\SDK) Microsoft Windows Server 2003 R2 Enterprise Edition (SP2) Microsoft SQL Server 2005 Internet Explorer 7 Microsoft Office Professional 2007 Microsoft Office SharePoint Server 2007 Microsoft Visual Studio 2005 POP3 E-Mail Services (No Exchange) Microsoft LCA Approved Sample Data System Requirements Supported Operating Systems Windows Vista operating system; Microsoft Windows XP Other Requirements Personal computer with1.5 GHz or higher processor and at least 2.0 gigabytes (GB) of RAM 12 GB of available hard drive space Super VGA (1024x768) video adapter/monitor Microsoft Virtual PC 2007 software (Microsoft Virtual PC 2004 and Microsoft Virtual Server 2005 R2 also compatible) ttfn David Technorati Tags: MS CRM , CRM , Dynamics , Virtual PC , VPC
  • Lots of OneNote PowerToys (file and data importers, Outlook tools, table sums, word count, tools to subpage a page or merge pages, copy to mobile device, template maker, favourites, table of contents and even CRM)

    Many people out there love OneNote. Lots of people have it and don't use it - shame on you - try it, but also try the tutorial so you stand a better chance of "getting" this note taking tool. Anyway, I saw a mail by John listing some of the items posted about by him. It is an impressive list. Here's the list, broken down by area: Migrating to OneNote: 1. Journal import https://blogs.msdn.com/johnguin/archive/2007/12/21/journal-to-onenote-importer.aspx 2. Text File Importer: https://blogs.msdn.com/johnguin/archive/2007/04/30/customer-feedback-results-in-another-powertoy.aspx 3. Export Outlook Notes to OneNote: https://blogs.msdn.com/descapa/archive/2007/02/14/export-your-outlook-notes-to-onenote.aspx 4. Import books from Project Gutenberg: https://blogs.msdn.com/johnguin/archive/2007/05/31/a-tool-to-import-texts-from-project-gutenberg.aspx Outlook Addins: 5. Outlook Email to OneNote: https://blogs.msdn.com/descapa/archive/2007/02/06/powertoy-outlook-to-onenote-addin.aspx 6. Task Request https://blogs.msdn.com/johnguin/archive/2007/12/11/task-requests-from-onenote-meeting-notes-powertoy.aspx 7. Use OneNote instead of Outlook Notes: https://blogs.msdn.com/johnguin/archive/2007/04/16/4-16.aspx Work with data on page: 8. Audio Fine Tuner https://blogs.msdn.com/johnguin/archive/2007/12/12/media-fine-tuner-powertoy-for-onenote.aspx 9. Table Sums https://blogs.msdn.com/johnguin/archive/2007/12/10/table-sum-powertoy-for-onenote.aspx 10. Image Rotator https://blogs.msdn.com/johnguin/archive/2007/12/14/image-rotator-powertoy-for-onenote-2007.aspx 11. Printout Manager: https://blogs.msdn.com/johnguin/archive/2007/09/19/an-addin-to-manage-printouts-to-onenote.aspx 12. Word Count: https://blogs.msdn.com/descapa/archive/2007/02/14/onenote-2007-word-count.aspx Working with Pages: 13. Make a Page a Subpage: https://blogs.msdn.com/johnguin/archive/2007/09/07/make-subpage-addin-updated-and-a-lenovo-update.aspx 14. Merge Pages: https://blogs.msdn.com/johnguin/archive/2007/08/16/merge-pages-in-onenote-powertoy.aspx OneNote...
  • We may live in the Web 1.5/2.0/3.0 world, but most of our customers don't - Online office suites barely register with public, says study

    Just a final one before I go to bed (been at home ill today, so fired off some blogs while I was bed bound) - It is funny how much noise Saas and applications like Office suites online get in the IT press, yet go to your average consumer and you are down with 26% who are aware of them and just 6% who have tried them - and most of these are not regular users. Just reminds us to keep our feet firmly on the same planet as those of our customers, or help them very carefully to step to the new planet. A new study by the NPD Group doesn't paint a great picture for the current state of online productivity suites. If the numbers from a survey of 600 US residents are to be believed, most of us have never heard of, let alone tried, products such as Google Docs or Zoho . Considering various factors such as visibility and the industry's untested waters though, these numbers could be due for a significant shift in the coming years. According to NPD Group numbers, 73 percent of the 600 Americans surveyed have never heard of online office suites, while another 20 percent have, but simply haven't tried any for one reason or another. The remaining six percent of respondents are split between those who have heard of the suites and either haven't used them again, use them infrequently, and use both online suites and desktop apps like Microsoft Office. Based on these numbers, some have already written a eulogy for Web 2.0 office suites , but that assessment might be a bit early. Online office suites barely register with public, says study; that may change as they mature ttfn David Technorati Tags: Web 2.0 , SaaS , S+S
  • Independent study advises IT planners to go OOXML

    I'm not feeling my best, so no comments, but below was an article I found very interesing: Independent study advises IT planners to go OOXML Posted by Mary Jo Foley @ 6:41 am Market researchers with the Burton Group have issued a 37-page study– not commissioned by Microsoft or any other tech vendor — that finds Microsoft’s OOXML document format to be more useful than the rival ODF format backed by Microsoft’s competitors. The new study, freely downloadable (in exchange for registration) from Burton’s Web site is entitled “What’s Up, .DOC? ODF, OOXML, and the Revolutionary Implications of XML in Productivity Applications.” Office Open XML (OOXML) is Microsoft’s XML file format that it made the default in its Office 2007 suite. Open Document Format(ODF) is the file format championed by Sun Microsystems, IBM, Google and other Microsoft competitors. Microsoft is seeking ISO standards approval for OOXML, largely to appease customers who prefer/require standards-compliant products, as well as to head off ODF momentum, especially in developing nations. In September, Microsoft lost its bid to fast-track OOXML through ISO. In February 2008, ISO will hold a ballot-resolution meeting on Microsoft’s OOXML ISO standardization bid. After comparing the respective merits of OOXML and ODF, Burton made its recommendations for IT managers: “Any organization directly or indirectly (e.g., exchanging files with business partners) using Microsoft Office applications should plan to exploit OOXML. In addition to being the default file format in Office 2007, OOXML offers significant compression and security advantages relative to earlier, binary Microsoft Office file formats. “Although moving to OOXML file formats involves some administrative challenges, the opportunities for improved content management and productivity outweigh the short-term inconvenience of migrating from binary file formats.” Burton Group analysts Guy Creese and Peter O’Kelly, authors of the new study, explained why they believe OOXML “will be more pervasive than ODF...
  • CES (Computer Electronics Show) is coming and Microsoft will be there. Want to learn more and watch the keynote...

    I love CES. Yes, it is not business oriented, but it is great to see what everyone / anyone is doing in the consumer end of the market. Microsoft have a little silverlight site for people to find out more: This site can be found at http://www.microsoft.com/ces/ :-) Notice the areas we will be talking about at the bottom of the screen shot - Windows Vista, Xbox 360, Zune, Office, Windows Live, Windows Mobile and Games for Windows... rock on!! You can find links to more information, more ways to view etc at http://www.istartedsomething.com/20080105/bill-gates-ces-2008-keynote/ ttfn David (still officially on holiday)
  • How to Disable Internet features of Office 2007

    I saw this go around on a thread at work and I have seen it requested for those security conscious partners, so here is the answer (courtesy of Eric Ellis): 1) Via the Office Customisation Tool (OCT) and a custom MSP: — or — 2) Via Group Policy: The difference between the two is that using the OCT will preset the desired configuration during the initial installation (or in a maintenance mode change), but users can change the settings if they desire. Group policy enforces the desired configuration, and if a user makes a change to the setting, they will revert back to the settings defined in the policy during the next application session. ttfn David Technorati Tags: Office 2007 , Security , Internet , Group Policy , Office Customisation Tool , OCT
  • Do you want a Microsoft Architecture Poster?

    I saw this at Chris's site and thought I would share: Chris Bowen's Blog : Got Tech Posters? There are plenty of technology posters and charts for developers available on MSDN. I didn't realize just how many until I searched for "poster" on MSDN downloads . Here's a list of the more recent ones: [Edited list by David - more on Chris's blog] .NET 3.5 Namespaces Poster The .NET Framework 3.5 Common Namespaces and Types Poster Exchange Component Architecture Poster This poster highlights the architecture and feature set of Microsoft Exchange Server 2007. Visual Basic 2008 Keybinding Poster Printable wall poster containing list of useful keyboard shortcuts for Visual Basic 2008 developers Visual C++ 2008 Keybinding Poster List of keybindings for Visual C++ language within Visual Studio and Visual C++ Express 2008 Visual C# 2008 Poster Wall chart showing useful keyboard shortcuts for Visual C# programming language 2007 Office System: Developer Posters Download these posters to learn more about the new features and enhancement to the 2007 Microsoft Office System. Windows Server 2008 Component Posters Windows Server 2008 Component Posters, originally printed in the July 2007 issue of TechNet Magazine. Microsoft Silverlight 1.1 ( Ed: Make that 2.0 ) Developer Reference Poster Microsoft Silverlight Developer Reference Poster ttfn David Technorati Tags: Developer , .Net Framework , Visual C# , Visual C++ , Office System , Silverlight , Windows Server 2008
  • Office 2007 SP1 is here and it does more than just update the desktop - SharePoint gets AJAX for example

    I'm sure you have heard that the Office 2007 Service Pack is here. Darren Strange has documented what is in it and how to get it at Office 2007 sp1 ready for download today and OfficeRocker! : More detail about sp1 . In answer to Susanne's post at here , hopefully this post has some more info in it One of the little things he puts that I like is: Some other factoids about sp1 There are roughly 2500 fixes in SP1. This an average size for a service pack, but the issues fixed are very important to our customers. Almost 20% of those fixes are direct result of customer requests. Over 500 of those fixes focused on security. There are a total of 24 different releases in 38 languages. There are 683 distinct packages. All have released simultaneously today. If you get the whitepaper then you would be keen to see the information below. Notice that SharePoint amongst other things a developer update to support Ajax and that other server products (Groove and Project Server) are also updated. Stability Microsoft continues to improve its software products by listening to customers and acting on customer requests. With the 2007 Microsoft® Office system Service Pack 1 (SP1), Microsoft demonstrates this commitment by fixing at least the top five software bugs in each application that caused crashes, resulting in an even more stable product. The 2007 Office system SP1 also addresses many minor annoyances and distracting problems that users had to contend with in the initial release. Many of these minor usability and stability fixes are in response to customer requests as well. The following section lists summaries of some of the most notable stability improvements delivered with the 2007 Office system SP1. Access 2007 For third-party applications that use Data Access Object code to synchronize replicated information in a Microsoft Office Access™ 2007 database, Office Access 2007 no longer returns a run-time error that causes the application to close or time out. Communicator 2007 Microsoft Office Communicator 2007 now presents...
  • SharePoint continues to grow - now being considered "viral" in it's take up and what you can do about it.

    From a Microsoft and Microsoft Partner point of view the press article below is great news. IT departments are finding users who are deploying SharePoint to get the benefits and the easy of use that SharePoint offers as well as developers who are building on SharePoint as an application Platform. I recently had a partner who told me that their belief was that Windows 32/64 was the desktop and server operating system, but they saw SharePoint as the web OS. Given the benefits that SP1 provides to SharePoint this is even more the case. http://napps.networkworld.com/news/2007/120707-microsoft-sharepoint.html The analyst firm CMS Watch is claiming the newest version of Microsoft ’s SharePoint is spreading “virally” throughout enterprises, catching IT departments off guard and introducing risks related to uncontrolled content and regulatory compliance . […] CMS Watch says viral proliferation of SharePoint is nothing new, going back to the 2003 version. But Pelz-Sharpe says the “problem is becoming acute now” with the popularity of the 2007 product. SharePoint is a runaway success, reportedly generating $800 million in revenue this year for Microsoft, with 85 million licenses across 17,000 customers, the CMS Watch report states. For those who are finding SharePoint overload then a quick visit to http://technet.microsoft.com/en-us/office/sharepointserver/bb507202.aspx should offer some relief. ttfn David Technorati Tags: SharePoint , SharePoint Portal Server , SharePoint Portal Server 2007
  • Things that have fixed peoples problem running Office on Vista

    From the blog entry I published on How to get rid of the installer / configuration dialog when running Office 2007 and Office 2003 on the same system - for Vista and other versions of Windows I still get people e-mailing me with problems. While I have not been able to solve them all, but here are some solutions that I have seen success with: Problem: POP3 e-mail starts sending then gets stuck/hangs/stops: I have seen your blog at uksbsguy.com and it seems you are my only hope. Brand new laptop, small sized PST file, Vista Home Premium, Outlook 2007 Ultimate. I set up an account in Outlook 2007 to my bog standard POP3 account that has always worked. It starts to download my first email and slowly reaches 3 or 4KB then just hangs . Surprisingly I can sent (SMTP) absolutely fine. If I use another internet connection (dial up modem) instead of LAN then I can receive POP3 as well. But the same LAN connection works for my old laptop (XP/Outlook 2003) all settings same. I also tried the netsh command and the result is as follows: C:\Users\sparekh>netsh interface tcp set global autotuning=disabled Set global command failed on IPv4 The requested operation requires elevation. Sachin The solution: elevated netsh command You need to run an “elevated” command prompt. Find "command prompt" on your start menu, right click it and select “run as administrator” – then try the command "netsh interface tcp set global autotuning=disabled" (without the double quotes) Response: David, Magic! It worked! I elevated command prompt and netsh worked. My IT team spent so many hours and days for this. Thank you very much. Problem: Error code Ox800CCC0E when receiving email Vista running Outlook 2007 I get a Ox800CCC0E error everytime I try to receive email on my vista business machine running Outlook 2007. This problem just started this week. I have had no such problems with outlook since I purchase the machine 5 months ago. I have tried all the troubleshooting steps on your blog : http://uksbsguy.com/blogs/doverton/archive...
  • Open Office 2007 attachments to Outlook Mobile e-mail on Windows Mobile 5 or 6 - update released

    [updated on 4th December with UK English install instructions] As Steve would say, hat tip to Steve's blog . Microsoft Office Mobile 6.1 If you run Windows Mobile 5 or 6 and run Office 2007 (or get attachments from friends that do) this is a must have . You can now read Office 2007 file formats on your mobile device. More details from Jason :) [UK English Install] For those of us not in the US of A this install will complain about installing on our UK English (or other) devices. Fear not, go to the settings screen, move to region settings and change the language to US English. Ignore the prompt to reboot, run the setup on your PC. Once it is all finished it will need to reboot your device. Do so, set the language back to UK English and you now have an updated device. There is no English_UK install :-) ttfn David Technorati Tags: Windows Mobile , Office 2007
  • How to turn on e-mail logging in Office 2007 and ensure that your ports are open

    I was asked about this a while back and thought I would share. This person has e-mail receiving problems, so I wanted to turn on logging and check that the network ports were really open on his PC: To get a mail log for more details – go to Tools/Options – then the advanced tab/Other button/Enable logging. (mine is not checked – put a tick in yours). The location of the log file can be found at: MAPI (Exchange), POP3, and SMTP transports - The log file has the name OPMLog.log and is located in one of the following locations: c:\Users\ user name \AppData\Local\Temp\Outlook Logging - note this is the location on Windows VISTA You might also want to look at http://www.webpipe.net/howto/Outlook_0x800CCC0E . You will need to install at telnet, but this is documented as: By default, Telnet is not installed with Windows, but you can install it by following the steps below. To install Telnet Client 1. Click the Start button , click Control Panel, click Programs, and then click Turn Windows features on or off. If you are prompted for an administrator password or confirmation, type the password or provide confirmation. 2. In the Windows Features dialog box, select the Telnet Client check box. 3. Click OK. The installation might take several minutes. If the telnet works, but Outlook cannot get mail, try running “outlook /safe” and see if the same problem happens. If it does not, then it is an add-in. ttfn David Technorati Tags: Office 2007 , Windows Vista , logging
  • Microsoft Office System Developer Conference - February 10-13th 2008

    Where: San Jose Convention Center , San Jose, CA Who: 2000 developers and architects who build solutions on the Office platform (Office clients, servers, and services) ODC 2008 will bring together architects, developers, industry technical experts, Microsoft insiders and key partners in a public forum for the first time! Together, we will redefine what it means to be focused on Microsoft Office development, exchange ideas on how to continue innovating in this ever-changing space, and share best practices on how to craft the next generation of Office Business Applications . Microsoft Chairman Bill Gates will deliver a special keynote that is not to be missed (and probably one of the last ones, so be there!!). The web site http://www.odc2008.com is now live. Who is the Microsoft Office System Developer Conference for? Those involved or interested in using the Microsoft Office system (clients, servers, and services) as an application development platform. For example, people in technical roles e.g. architects, developers, designers, and technical managers. Will it cost to attend the conference? Yes, there will be a reasonable registration fee for the conference. For those that register early, we will have a special early bird rate as well. Which products/technologies will this conference cover? Obviously, the conference will cover everything in Microsoft Office system, including clients, servers and services, but business productivity applications don’t exist in isolation. More and more, we’re finding that people are using others parts of the technology stack and bringing together various technologies to make applications more compelling. So a great number of sessions will have topics involving Office application development in the context of leading-edge technologies such as VOIP, Silverlight, integration with third-party line of business applications, etc. I’ve heard there’s also a SharePoint Conference. What’s the difference? The SharePoint conference will take place in March 2008 in Redmond, WA. Unlike the Microsoft...
  • Download the "How to Sell, Deploy, and Build Business with Microsoft Windows Sharepoint Services 3.0 and SBS 2003 R2" now

    I have been asked about this loads of times, but for those of you who want to know more about using WSS v3 and SBS 2003, the guide is finally here at http://www.microsoft.com/downloads/details.aspx?FamilyID=59acc518-023e-43c3-b8f3-378c5e387461 . How to Sell, Deploy, and Build Business with Microsoft Windows Sharepoint Services 3.0 and SBS 2003 R2 Partner tool to create solutions using Windows SharePoint Services 3.0 and Windows Small Business Server 2003 R2. File Name: Selling_WSS_and_SBS_Kit.zip Date Published: 11/15/2007 Overview A new partner enablement tool helps you create solutions using Windows SharePoint Services 3.0 and Windows Small Business Server 2003 R2. Access the toolkit’s resources—including a process cookbook, technical documentation and marketing materials—to learn how to build your business by selling and deploying customized solutions. ttfn David Technorati Tags: SBS 2003 R2 , SBSC , WSS v3 , WSS , SharePoint , Windows SharePoint Services
  • How to make Office 2007 always save in Office 97-2003 format

    This is another area I get a lot of questions, so I thought I would share the answer. While my person preference is to tell people to load the tools onto Office 2000/XP/2003 machines as documented at How to open Office 2007 (Word, Excel, and PowerPoint 2007) files on Office 2000, Office XP and Office 2003 by downloading the Microsoft Office Compatibility Pack for File Formats - David Overton's Blog for some people this is not an option. So, how do you force Office to save in the older format? If you want to do it to lots of machines then look at http://msmvps.com/blogs/bradley/archive/2007/07/14/default-save-as-doc-and-xls.aspx . If you want to do it on your own personal machine, try this: Go the the "Opal" or the round Office button, and select Word Options Then go to the save tab and choose the file format you want, so Word 97-2003 for .doc files. You need to do the save in Excel and PowerPoint to get those too do it too. ttfn David Technorati Tags: Office 2007 , Office 2003 , Office XP , Office 2000
  • MSDN Evaluation Center for Office system, Biztalk, SQL Server 2005/2008 and Windows Server 2008

    I just found the MSDN Evaluation Center online today to give you evaluation resources that you might develop against. These include BizTalk Server, Office Communication Server, Office Enterprise , SharePoint Server, SharePoint Designer, SQL Server 2005, 2008, Express 2005 SP2, Windows Server 2008. I've pasted much of the content, but all the download links etc are country specific, so I have removed those. Click on the link above to get to download this stuff! MSDN Evaluation Centre Welcome to the MSDN Evaluation Centre, the central location for all Microsoft developer product trials and beta evaluations. Try a product before you buy it or test the latest beta to see what is in store for the next release. Start at the beginning of the evaluation process and follow the new products as they go through to the final releases. Remember to check back often as new products will be added as they become available. As you evaluate your software, we'll provide you with comprehensive and relevant insights and information delivered to your inbox. Resources like: Webcasts | Virtual Labs | Community insight | White papers| E-Learning | Events Featured Evaluations BizTalk Server BizTalk 2006 R2 Regardless of the size of your organization, you need best-in class infrastructure. BizTalk Server 2006 R2 delivers enterprise-class infrastructure that enables you to connect .NET applications and infrastructure with your non .NET applications and platforms, as well as those of your partners. Office system Microsoft Office Communications Server 2007 Microsoft’s unified communications platform enables developers to efficiently build secure, productivity enhancing applications on top of an extensible software foundation. Microsoft Office Enterprise 2007 Microsoft Office Enterprise 2007 provides a comprehensive suite of applications that developers can extend to deliver solutions that make data and processes more accessible and relevant to users. With Office Enterprise 2007 you can build solutions that give users the power to collaborate...
  • Office Open XML file format information or Standard ECMA-376 and the OOXML SDK information on MSDN

    I saw this question asked internally today, so I thought I would share. If you want to develop to use the Open XML document format you probably want to look at two things. The Microsoft resources (eg http://msdn2.microsoft.com/en-gb/office/aa905545.aspx ) and the ECMA resources Standard ECMA-376 . On the MSDN site you will find documentation and a MS SDK (less interest if you are developing using a functional language for your mainframe ). The ECMA site has the following: Standard ECMA-376 Office Open XML File Formats (December 2006) This Standard defines Office Open XML's vocabularies and document representation and packaging. It also specifies requirements for consumers and producers of Office Open XML. An Office Open XML overview is available on the Ecma website. Copy these file(s), free of charge: File name Size (Bytes) Content ECMA-376 Part 1 350 630 zipped DOCX file ECMA-376 Part 1 1 441 795 zipped PDF file ECMA-376 Part 2 341 625 zipped DOCX file with 2 Annexes ECMA-376 Part 2 1 286 494 zipped PDF file with 2 Annexes ECMA-376 Part 3 6 625 515 zipped DOCX file ECMA-376 Part 3 5 930 003 zipped PDF file ECMA-376 Part 4 14 477 799 zipped DOCX file with 4 Annexes ECMA-376 Part 4 29 008 573 zipped PDF file with 4 Annexes ECMA-376 Part 5 99 655 zipped DOCX file ECMA-376 Part 5 687 279 zipped PDF file Just thought I would share for those who know I am a big fan of easy access to the innards of document formats. ttfn David Technorati Tags: Open XML , Office System , Office Open XML , ECMA-376 , Open Standards , Developer
  • What is in Office Accounting for accountants... well, multiple account views, sharing, customisation and more, but it is not an practice management solution

    I saw that someone said on one of the online forums that there was not anything in Office Accounting for Accountants. I beg to differ. This product is not something that offers anywhere near the same capabilities of someone like Iris for Practice Management - it is not designed to do so, it is aimed at small businesses who want a simple to use accounting package and then a tool for accountants to simply extract and manage data from it. I am not an accountant, but Microsoft offer several areas for Accountants with Office Accounting: Ability to customise the product to brand it for a specific organisation, such as an accountant, ISV or partner Ability to monitor several people's accounts from the one place and gather updates via an secure online process (through Office Live) Client sends accounts to accountant, continues using them and then the changes are synchronised back from accountant without data loss Run payroll for multiple clients Single Journal entry with VAT that spans multiple dates, customers and suppliers Full audit on transactions and modifications to spot fraudulent actions easier Ability to produce a number of the reports that accountants may well want to automate A Microsoft backed network designed to listen to the needs of accountant and deliver further benefits for them - aka Microsoft Professional Accountants' Network which also provides the following software and support benefits: Free Support Free unlimited support until September 2009 Access to managed newsgroups Access to invitation-only training events specifically for accounting professionals Free Software One complimentary license of Microsoft Office Accounting Professional 2008 One complimentary license of Microsoft Office Small Business Edition 2007 All in all I would say that was quite a lot for something that is potentially free for customers and free for accountants!! ttfn David Technorati Tags: Microsoft Office Accounting , Office Accounting , Office System , MPAN , Microsoft Professional Accountants Network , Accounting , Accountant
  • Lots of Partner training (new url) - Licensing 101, Sales 101, Office PerformancePoint, Office Business Applications (OBA), Enterprise Search, SharePoint Services and Server 2007, Office Communications Server 2007, Infrastructure Optimisation (IO) ...

    [updated with a working URL] Partner Licensing 101 – The next one is being held on the 4 th December 2007 This session will equip sales people with a top level knowledge that will enable them to talk to new and existing customers about Microsoft licensing. Target Audience: This session is aimed primarily at sales people from all Partner types, although it is appropriate for all Partner roles whether in Sales, Purchasing or Technical. The course is ideal for new starters looking for a good introduction to Microsoft licensing or just a great as a refresher for those who have taken a break from Microsoft licensing. This session is suitable for people who present technology solutions to customers from a non-technical perspective and need to demonstrate the correct way for customers to purchase. Click Here to register For further information please contact Carla Symonds. Partner Sales 101 - The next one is being held on the 5 th December 2007 - Aim: This session will equip sales people with the knowledge and skills that will enable them to talk to new and existing customers about the business benefits of Microsoft technologies, and associated areas such as licensing. -Target Audience: This session is aimed at sales people. People within a partner organisation who present technology solutions to customers from a non-technical or business point of view and people who are not technical experts and do not demonstrate software, but talk about the possible solution outcome. -Objectives: For the sales person to gain an understanding of all key Microsoft technologies, with additional focus on infrastructure, and the Portals and Business Intelligence solutions, Windows Vista, Office 2007,the Microsoft Dynamics products and the fundamentals of Microsoft licensing. Click Here to register for the 5 th December 2007. For further information please contact Carla Symonds. Microsoft Office PerformancePoint Server 2007 Technical training. This four day instructor-led workshop provides students with the knowledge and skills to architect...
  • Visual Studio 2008 and .NET 3.5 Released - MSDN members can download the product and the Express and trial versions are available for download now too.

    I just saw this as Scott's blog while preparing something on SQL 2008 CTP. This is an amazing set of tools now released!! Visual Studio 2008 and .NET 3.5 Released Today we shipped Visual Studio 2008 and .NET 3.5. You can download the final release using one of the links below: If you are a MSDN subscriber, you can download your copy from the MSDN subscription site (note: some of the builds are just finishing being uploaded now - so check back later during the day if you don't see it yet). If you are a non-MSDN subscriber, you can download a 90-day free trial edition of Visual Studio 2008 Team Suite here . A 90-day trial edition of Visual Studio 2008 Professional (which will be a slightly smaller download) will be available next week. A 90-day free trial edition of Team Foundation Server can also be downloaded here . If you want to use the free Visual Studio 2008 Express editions (which are much smaller and totally free), you can download them here . If you want to just install the .NET Framework 3.5 runtime, you can download it here . Quick Tour of Some of the New Features VS 2008 Multi-Targeting Support <snipped - see the original blog entry for more> ASP.NET AJAX and JavaScript Support <snipped - see the original blog entry for more> VS 2008 Web Designer and CSS Support <snipped - see the original blog entry for more> Language Improvements and LINQ <snipped - see the original blog entry for more> Data Access Improvements with LINQ to SQL <snipped - see the original blog entry for more> Browsing the .NET Framework Library Source using Visual Studio <snipped - see the original blog entry for more> Lots of other improvements <snipped - see the original blog entry for more> The list above is only a small set of the improvements coming. For client development VS 2008 includes WPF designer and project support. ClickOnce and WPF XBAPs now work with FireFox. WinForms and WPF projects can also now use the ASP.NET Application Services (Membership, Roles, Profile) for roaming...
  • Where to get lots and lots of information on BCM (Business Contact Manager) 2007

    I found this blog and realised several things. 1) The Brelsford family (no, they are not related) are very good in the small business space. 2) I now have a BCM 2007 hero. Who am I talking about? Bill Brelsford - http://blog.rebarbusinessbuilders.com/about.html - who says "For the past 20 years, I have been working with and for small businesses in a variety of roles." I love BCM and here are some of the things he has written about BCM. It is worth noting that Bill does not just write about BCM, but many things including marketing and many other issues that a small business would face. BCM: Setting Up Marketing Campaigns in BCM Tracking Customer Anniversary Dates in BCM Getting Started Managing Suspects in BCM Small Business CRM It has to be worth a look. ttfn David Technorati Tags: Business Contact Manager , BCM , Small Business
  • Office Accounting Professional 2008 ships in the UK ... download the free Express version, buy or try the Professional version for extra features (Multi user, SQL support, sales order, purchase order etc) and also sign up for online services (Paypal, BACS

    Microsoft Office Accounting Professional 2008 It is finally here!! There are 2 major versions - the free version and the paid for version, plus a number of add-on services you might want to buy too. You can get lots of information at http://www.msofficeaccounting.co.uk/default.aspx and if you are an accountant then the Microsoft Professional Accounting Network is for you ( http://accounting.microsoft.com/mpanuk.aspx ). You can download the Express Version here: You can Download Free Trial here It says about itself: Microsoft® Office Accounting Professional is an easy to use, comprehensive accounting package that works with other Office applications you already know. Easy to learn and use Works just like Word, Excel and Outlook Get started in minutes with wizards that import your data Save time managing everyday tasks Share and reuse data across Word, Excel and Outlook Manage customers, suppliers, employees and stock Pay bills, track expenses, send invoices and bank online Get a complete view of your business Run customisable reports so you always know how you’re doing See all your important data in one glance with the Digital Dashboard Get reminders of important deadlines, pending bills and overdue invoices Product Overview information is available here: Product Overview Product Overview Below are the product features and the comparison between the 2 versions Top Features Click for details Get up and running in minutes Import data from Sage © or Excel * Choose from dozens of business templates to set up your company Work in the familiar Microsoft Office interface Visit the Resource Centre to get help with common questions Save time on everyday tasks Track your income and expenses Manage customers, suppliers and employees Print cheques, create quotes and invoices Bank online and download transactions Get paid faster with PayPal invoices Get reminders for recurring documents and activities Save time with Office integration Track billable time, create quotes and send invoices in Outlook Export reports to Excel with one...
  • Want Office 2007 with a 50% discount? You have until Christmas to upgrade and get a 50% discount with Open Value Subscription

    Again, browsing the small business blog and I thought this was very interesting: Why wait? Upgrade now to 2007 Office and save 50% Until 31 December 2007 you can get a 50% discount off the 2007 Microsoft Office system when you upgrade through the Microsoft Open Value subscription programme. Why do it this way? Because you get a huge discount, you can manage your payments over three years to help your cash flow, you’ll receive a single agreement for all your software licences, and get the benefit of Microsoft Software Assurance, which offers version upgrades and training and partner services. Learn more about the benefits of upgrading here . Microsoft's Small Business Blog : Why wait? Upgrade now to 2007 Office and save 50% ttfn David Technorati Tags: Office 2007 , UK , Discounts
  • There I was talking about Office Business Applications (OBA) and there is training around the UK available

    From the Empower Blog I saw: Office Business Applications (OBA) Technical Briefing This two day technical briefing explores an emerging category of applications, known as Office Business Applications (OBA). It explores the technologies that underpin them, in particular Microsoft Office 2007, Windows SharePoint Services, Microsoft Office SharePoint Services and Open XML. This two-day course is run as a seminar and the labs are provided as a take-away for attendees to go through in their own time. For more information and to enrol, follow the link to the Partner Learning Centre and sign in using your Partner Program login and password. OBA Briefing ttfn David Technorati Tags: Office Business Applications , OBA , Training
  • Where to start to build products that integrate with Microsoft Office

    I came across the OBA (Office Business Applications) web site www.OBACentral.com which has lots of information about nearly 200 OBA solutions. While there is a getting started and "on ramp" information on the site, I found the MSDN site ( Office Integration ) which I like almost as much. Given the prevalence of the Office Platform, assuming it is there and building on it can make life much easier!! Office Integration Need to integrate two or more Office products? Need to integrate Office products with other Microsoft products and technologies? Want to learn about designing and building applications using the Microsoft Office System? This section of the portal provides pointers to resources that will help you build real-world business solutions. Office Business Applications The 2007 Microsoft Office system provides a comprehensive set of servers, clients, and tools to make it easier for enterprises, software vendors and developers to build and deploy a new class of business applications called Office Business Applications (OBAs). OBAs connect Line of Business (LOB) systems with the people that use them through the familiar user interface of Microsoft Office. OBAs enable businesses to extend the Microsoft Office clients and servers into business processes running in LOB applications such as Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), and Supply Chain Management (SCM). This enables enterprises to create new value from existing IT investments by combining them in innovative ways. Microsoft Office System for Architects With the 2007 Office System, Microsoft Office has evolved beyond a productivity suite into a unified solutions platform that makes enterprise data and processes more accessible and relevant to users. Composed of clients, servers, services, and tools, it provides a single infrastructure for communication and collaboration, business intelligence, and content management solutions. This MSDN Solution Architecture Center brings together relevant ideas, concepts, and best...
  • How to use OCR (Optical Character Recognition) in Office 2007 (using OneNote or a small tool)

    As you know I have been away on holiday and I fly away again tomorrow. While I was traveling I asked my dad to send me a recipe for some scones. He was unable to find the OCR tool in Office 2007, but with the help of OneNote 2007 it was very easy. Paste the image you wish to OCR into OneNote and let it do the rest. I found the answer at OneNote 2007: OCR Rocks this researcher's world | Techwillow where there is more information, but in summary: This is how it works: Take any image of text, paste it into OneNote, right-click on it and select Copy Text from Picture . That's it, you can then paste it anywhere as text. What's more OneNote will automatically OCR and index all your images (if you enable this in the settings) so you can search through your clippings. Now, of course you might not have OneNote, but that does not mean you don't get scanning. As the project at http://www.codeproject.com/office/modi.asp points out, you can use their code and the Office 2007 scanning tools to make it work too. ttfn David Technorati Tags: Office 2007 , OCR
  • Office Rocker! : Ecma Open XML real world stories

    I don't know how many of you read the Office Rocker blog from Darren Strange ( http://blogs.msdn.com/officerocker ), but I did like this entry given all the recent discussions about Open XML. At the end of the day the discussion is not who's standard it is (ISO, ECMA etc) although there does appear to be a pecking order, but more about what people can do once it is in use. Darren has highlighted some people who are actually using Open XML to extend their business. Ecma Open XML real world stories This afternoon I was presenting at the Office Business Applications architects council with the good looking chaps on the right here. I was talking about some of the stories I've come across from our customers and partners who are using Ecma Open XML in their solutions. I have 4 stories published recently about Ecma Open XML that illustrate what I think are 3 significant categories: 1. Integrated add-in Fractal:Edge have a great visual concept for representing the drill down on data using what they call a 'Fractal Map'. The map is an add-in for Excel 2007 effectively but to store the settings for the map - like the data connection details, involves writing this to the file. This is very easy to do in Open XML and means you don't need to lug around a separate config file to travel around with the spreadsheet. They have a really good demo on their website. Being able to use Excel to store the fractalmap made their add-in highly portable which increased its adoption. <snipped> 2. Document interrogation Working out the history of a document, merging changes and looking for compliance violations is an area Workshare have an impressive depth of experience. Previously working with the binary format to do this was very hard not to mention fraught with danger of corrupting the file. Since Open XML, they've been able to create new versions of their products far faster, with greater precision and because poking about in the file is now supported, a much more secure and stable product. <snipped>...
  • Training for users on SharePoint 2007

    From the SharePoint product team: Greetings, Looking for end user training for WSS 3.0 and MOSS 2007 ? The product team has released the SharePoint End User Training Kit - http://blogs.msdn.com/sharepoint/archive/2007/10/11/sharepoint-end-user-training-kit-now-available.aspx . The SharePoint Server 2007 Training includes interactive demos, videos, and articles. You can customize the training to match your site look and feel or use it as is. The SharePoint End User Training Kit will also have a standalone deployment option, which can be installed on a PC and used by an individual. This version of the kit will be available within the next few weeks. For more information about the kit and instructions on how to obtain it, please go to the end user focused " Get the 'Point " blog. ttfn David Technorati Tags: SharePoint , Training
  • Videos on Office usage - Document Inspector, Excel Templates and formatting, Outlook on the go and enhancing word documents

    I have documented some of these videos before, but I thought I would document them all now - How to use the document inspector - How to find a template for Excel and then customise it for UK dates and currency, change the formatting and more - How to use conditional formatting in Excel - How to use Outlook Web Access and Outlook Anywhere (RPC over HTTP) - How to enhance a document using various things - cover pages, table of contents, pictures, smart art, formatting ttfn David Technorati Tags: Office 2007
  • How to save money when offering licensing to small businesses in the UK at the moment

    [updated to remove some inaccuracies about Susanne's microspeak - sorry Susanne] There are always special offers of some form or another from most companies and Microsoft is no exception (well, except in August when we are still in post financial year clean up :-)). Anyway, the UK SMB Girl aka Susanne Dansey at Westcoast has listed a couple of these.: N-3 Open Value Subscription Offer Promotion ends: 31 December 2007 Programme: OV Subscription Up-to-Date Discount (UTD) is a 50 per cent discount in OV Subscription for the first year invoice for any licence for the current (N) or previous (N-1) version of the selected Small Business or Professional Desktop platform products. For the OVS N-3 promo eligibility for receiving the 50 per cent discount is granted to N-3 versions of Office licences (back to Office 2000). Promtional SKUs are identified on the price list by the word ‘Promo’. Future proofing Microsoft Windows Small Business Server 2003 R2 Here’s a heads up to all Microsoft Partners thinking about licensing SBS 2003 so that you can save 15% on Windows SBS 2003 R2 (standard edition) for you and your clients (should you wish!). Offer: Save 15% on Windows SBS 2003 R2 Standard Edition License types: L only, L+SA Offer descriptions: Partners get an additional 15% off the regular Partner price for the Standard Edition of Windows SBS 2003 R2 (license only and license + Software Assurance). Partners are eligible to pass savings onto their customers. Offer good only when bought in a VL License (L or L+SA). SA will allow customer to upgrade to the next version of Windows SBS for free. Offer fulfillment: Partner discounts are available directly from official Microsoft distributors (such as me) Duration and timing: September 2007 through December 31, 2007 Considerations: The Windows Small Business Server CALs are not included in this discount How to hold a conversation with your customer regarding this offer AND MORE IMPORTANTLY, how to talk about SBS 2003: “Can I ask you, if you got hit by a virus, are you 100% confident...
  • IIS and SharePoint and ISA updates, information and web casts for this month

    This information comes from the Technical Rollup Mail blog which can be found here http://blogs.technet.com/trm/ . I extract the sections and then remove some of the items that don't work for me for ISVs and/or SBSC partners. News 6 new case studies published this month - http://www.microsoft.com/casestudies/search.aspx?ProTaxID=1265&NoDays=30 IIS The Tasty Morsels Found In Dogfood… MSCOM OPS Top 10 Changes In IIS7.0 http://blogs.technet.com/mscom/archive/2007/09/07/the-tasty-morsels-found-in-dogfood-mscom-ops-top-10-changes-in-iis7-0.aspx The .NET Show: IIS 7.0 (Shipping with Windows Vista will be the latest version of Internet Information Services (IIS), which includes a broad collection of features and capabilities that have been anxiously awaited by both developers and IT Pros. Scott Guthrie and Bill Staples describe and demo new features in IIS 7.0. ) http://msdn.microsoft.com/theshow/episode.aspx?xml=theshow/en/episode056/manifest.xml Sharepoint Technologies Correction for last month where we missed the URL off from this post The great Office Server smorgasbord: SharePoint 2007 - Microsoft's five new Office Servers give Office 2007 users a wealth of new features and capabilities. We examine how in this four-part series, starting with SharePoint 2007 So here it is: http://www.infoworld.com/article/07/08/13/33TCmoss_1.html SharePoint Designer Microsoft SharePoint Designer team looking for customer needs for data design, view and functionality. Copies of Office Professional are available in a sweepstake for all entrants. http://blogs.msdn.com/sharepointdesigner/archive/2007/09/19/sharepoint-designer-data-team-survey.aspx Latest Product test Drive Test Drive Microsoft Office and SharePoint 2007 in a new online package http://office.microsoft.com/en-us/products/HA101687261033.aspx Introducing the Performance Point Developer Portal Performance Point Server 2007 provides all the functionality that is needed for performance management. Performance Point offers features that not only help analysts monitor...
  • Installing WSS v3 on a Member Server in an SBS Network

    I have spoken before about how to install WSS on the SBS box, so it was quite nice to see the article on how to install on a member server - much simpler to do many less problems. Installing WSS v3 on a Member Server in an SBS Network If you’ve got a member server in your SBS network (especially if that server is a beefy SQL box) it may make sense from a performance standpoint to install Windows SharePoint Services version 3 on the member server instead of directly on the SBS box. This is actually a pretty straight-forward process, but in case you’re not totally comfortable with WSS v3 yet, the procedure is documented below using a combination of a Microsoft e-book and the WSS on SBS instructions Chad came up with for SBS. Installing WSS v3 on a Member Server in an SBS Network | NoGeekLeftBehind.com ttfn David Technorati Tags: WSS v3 , SharePoint , SBS 2003
  • Business Contact Manage 2007 (BCM) with LinkedIn and/or Windows Mobile

    I was reading the Small Business Building Blocks blog and noticed this handy time for BCM and LinkedIn. As many of you know BCM is a favourite product of mine and one that providing the machine has the grunt is an excellent productivity tool. I've been playing around with the LinkedIn toolbar for Outlook . One of the issues that I constantly run into with tools like this is that they are made to work with Outlook contacts but don't always work with Business Contact Manager (BCM). I've had better luck with this add-in than others, so I thought I would post a little about what I have found. If anyone has figured out a better way to address these issues, I'd love to hear from you. The LinkedIn toolbar has a couple of ways to create contacts. One is from the LinkedIn dashboard, when it recognizes a contact in LinkedIn or your e-mail folders that is not set up as a contact. A second way is to use the "grab" button to create a contact from text or an e-mail signature. When LinkedIn creates a contact, it creates an Outlook contact and saves it in an Outlook folder called "Collected Contacts". I want to create Business Contacts, not Outlook Contacts. One way to accomplish this is to 1) Create the contact and then 2) drag the newly created contact from the Collected Contacts folder to the Business Contacts folder. Once you have done this, you can open the contact and add any Business Contact fields that you need to. Another option is to change the folder that the LinkedIn toolbar uses to the contacts that it creates. For more information see the rest of the article at http://blog.rebarbusinessbuilders.com/rebar/2007/10/using-the-linke.html . Then I noticed Chris's post at http://www.chrisrue.com/funcave/2007/08/sync-bcm-and-public-folder-items-to-your-windows-mobile-device.html that talks about how to get almost anything sync'd to a Windows Mobile device, so if you want you can add better syncing between BCM and Windows Mobile over and above the MS app to do this. ttfn David Technorati...
  • Office Live Workspace: New Web Functionality for Microsoft Office

    I thought I should offer some clearer info on what is coming in Office Live Workspace Available at no charge, Office Live Workspace facilitates the following : Access documents anywhere. Organise documents and projects for work, school and home online, and work on them from almost any computer - even one not connected to the company or school network. Save more than 1,000 Microsoft Office documents to one place online and access them via the Web. Share with others. Work collaboratively on a project with others in a password-protected, invitation-only online workspace, helping to eliminate version-control challenges when e-mailing drafts to multiple people. Collaborators who don't have a desktop version of Microsoft Office software can still view and comment on the document in a browser. Extend Microsoft Office. Easily connect to Microsoft Office Word, PowerPoint ® , Excel ® and Outlook ® on their PC via the Web. Pre-register for the beta of Office Live Workspace today at www.officelive.co.uk Some people are equating this to Google Docs ( Microsoft Unveils its Answer to Google Docs ), but this is about sharing information using Office or other tools. It is not about 2 people being online at the same time editing the same document. While people talk about this I have never had a need to do this, so for me, all the functionality of Office, plus an online place to share and store them is much better. ttfn David Technorati Tags: Office Live , Windows SharePoint Services
  • An amazing deal for UK Students to get Office 2007 ULTIMATE for £39 to own or £13 per year to "rent it" - tell them all about it!

    This offer is called "The Ultimate Steal" and I have to say I can see why. Microsoft is now offering Office 2007 to university students for the sort of price that would normally suggest this was a con or stolen software, although as Steve Clayton has already verified, it is real . The Offer is simple "Get Microsoft® Office Ultimate 2007 for just £38.95 to own or £12.95 to use for one year" As I said this is only open for people in education, but if you go to The Ultimate Steal presented by Microsoft you can get lots more info. A summary, but not complete, eligibility requirements are: You must hold a valid email address at a U.K. educational institution ending in .ac.uk (for example, leina@contoso.university.ac.uk) Be actively enrolled with at least 0.5 course load. You must be able to provide proof of enrollment status (ie, student card) upon request by Microsoft. If you are unable to provide proof of enrollment, you will be required to pay the full retail price of Office Ultimate 2007 (approximate ERP £599.99). Here is how it works: Buy the product offer you want Download it or order a CD Enter your product key and use away You can download the Office Ultimate 2007 trial software anytime but to gain unrestricted access, you’ll need to activate it by entering a genuine product key! Own it. Use it for one year. I think this is pretty amazing!! ttfn David Technorati Tags: Office 2007 , Students , Offer , UK
  • SBSC and small business partners get a chance to find out more about the market they sell into and Microsoft technology that is here and coming

    Want to talk to Microsoft and hear where we see the market, opportunities and key technologies? Then get to one of these (there are even more dates on the web site) :-) We are taking to the road to see you, our partners! Jump in the driver's seat and join us to find out how we plan to get your business motoring. A top Microsoft technology and business team will map out the latest developments in the server and desktop markets and take you on the journey from market opportunity to technical 'how to' demonstrations. We'll get under the hood of Windows Vista and the 2007 Microsoft Office system, along with the Office Ready PC, giving you detailed insights to get your business moving. And of course, we'll be outlining the route ahead for the new Windows Server 2008, with its built-in web and virtualisation technologies for increasing the reliability and flexibility of your customers' server infrastructure. Additionally we will be running exclusive SBSC pre-sessions at four of the locations so be sure to make one of these events by signing up using the links below: 1. Wednesday 10 th October – Cardinal Place, London 2. Thursday 11 th October – TVP, Reading 3. Wednesday 17 th October – Park Plaza, Nottingham 4. Tuesday 23 rd October – The Lighthouse, Glasgow And, importantly, we'll have the chance to meet. We want to know what you think, how you see the industry and the challenges you face. It's only with the direct feedback from you, our partners, that we can be sure we are on the right road. So, please join the whole team: technical, sales, marketing and business development, over beer and pizza to chat through the journey! Yours sincerely, Jennifer Brinton SBSC Programme Manager Microsoft ttfn David Technorati Tags: SBSC , System Builder , Vista , Office 2007 , Windows Server
  • re-iterate - Action Pack Office 2007 licenses will not work with Terminal Server and at the moment this will not change

    I'm sorry to be so blunt. I get asked about this quite often, so thought I would write it down. The problem is that the Office 2007 applications will only run in a Terminal Server environment if volume licensing media and a volume license keys are used. Unfortunately the MAPS kit does not include volume licensing media, which means that the Office 2007 can not be used in a TS environment. There are some options on how to move this forward, which are: Acquire the Premium edition of MSDN via the Microsoft Open License Program. http://msdn2.microsoft.com/en-us/subscriptions/aa700832.aspx or For their own business use, Partners could purchase Office 2007 via the Microsoft Open License Program or one of the other volume licensing programs. Some people have commented that the same restrictions were not in place for the beta of Office 2007. It is worth noting that the beta code for Office 2007 software was created without regard to the channels that it will later be sold or distributed in. For this reason, Office 2007 Beta software that was shipped in the July 2006 Action Pack Kit was compatible with Terminal Server. Beta code is not normally supported by Action Pack but it was shipped in July 2006 as an exception to the normal Microsoft policy. ttfn David Technorati Tags: Office 2007 , Terminal Services
  • What to do when you get the error "This modification is not allowed because the selection is locked" in Word 2007

    I was contacted by Gerald who had this problem and after a bit of research I found the answer. The text explaining how to do this can be found at http://www.word07.com/locking.htm , however to explain a bit more, here are a few pictures and words. The problem arises when you "group" some text in the developer tab, so the answer is to ungroup it. 1st off, ensure the developer tab is showing by going to the file (round pearl menu button in the top left corner) and selecting the button on the bottom of the menu called "Word Options". This will bring you up a screen as below Now ensure the developer toolbar is enabled with a tick as in the picture Go to the document and find the text that you can't modify Ensure the developer toolbar is displayed and click in the document where the text is and then press the Group button in the toolbar and press the Ungroup option as below That is it - you should now be able to modify the text without any problems. If this does not solve your problem, please e-mail me at admin@davidoverton.com with contact details as Microsoft are keen to get further information to investigate the problem and resolve it. thanks David Technorati Tags: Locked selection , Word 2007 , Office 2007 , Developer Ribbon
  • Finding out where something is in Office 2007 and where it was in Office 2003 (Outlook, Word, Excel, PowerPoint and Access)

    I saw this recently and thought I had to blog it - if you know something was there in Office 2003 and now can't find it in Office 2007 then look at these spreadsheets to get some advice. The 1st set of links (ms-help:) will work on a machine with Office 2007 installed and the 2nd set pull the data from the Microsoft Office web site. From the installed help files Outlook ms-help://MS.RIBBON.12.1033/RIBBON/outlookmap.xls Word ms-help://MS.RIBBON.12.1033/RIBBON/wordmap.xls Excel ms-help://MS.RIBBON.12.1033/RIBBON/excelmap.xls PowerPoint ms-help://MS.RIBBON.12.1033/RIBBON/powerpointmap.xls Access ms-help://MS.RIBBON.12.1033/RIBBON/accessmap.xls From the Internet Outlook http://office.microsoft.com/search/redir.aspx?AssetID=AM101954661033&CTT=5&Origin=HA101934281033 Word http://office.microsoft.com/search/redir.aspx?AssetID=AM101938681033&CTT=5&Origin=HA100625841033 Excel http://office.microsoft.com/search/redir.aspx?AssetID=AM101864291033&CTT=5&Origin=HA100860481033 PowerPoint http://office.microsoft.com/search/redir.aspx?AssetID=AM101923921033&CTT=5&Origin=HA100666231033 Access http://office.microsoft.com/search/redir.aspx?AssetID=AM101757761033&CTT=5&Origin=HA101666061033 ttfn David Technorati Tags: Menu , Office 2007 , Office 2003 , Word , Excel , PowerPoint , Access , Outlook
  • The Open XML Vote (OOXML) and why I hate politics

    This is a rant and it is my opinion and does not reflect that of Microsoft or others - It is my Opinion! From 1992 to 1995 I had to write document converters - I had to pick apart binary file formats and translate them to another format. It was hard work and I JUST WISHED people would create a largely encompassing standard for documents that was documented so I did not have to do all the work myself. Role forward to today, Office is still the prominent document format (which is now documented on http://msdn.microsoft.com ), but there is a new kid in town that encompass everything that an Office document is and more. This is the Open XML document format. People have cried for years that they wanted the Office Document standard to become more than a defacto standard, they wanted it to become a format an open standard. It was always going to be large, but to cover all the features and functions available in Office, it would have to be. There is no point in the standard being something different to that used in Office as it would be useless. Today, something like 600 million people use the Office document standard and Open XML format is growing too with tools existing for previous versions of Office prior to 2007 to make the use of the ECMA standard seamless for users. So what happens, Microsoft submits their file formats to the standards bodies and while it is accepted by ECMA a HUGE POLITICAL effort is made to stop it becoming an ISO standard. I don't mind people saying they want more documentation, but the only reason I can think why people want to stop it becoming an ISO standard is because they don't want it to be easier for people to use Office documents - they want it to be hard, to make use of Office harder for developers, not easier. This means that those who said "make it a standard" really meant "don't use it because it is not a standard and that is the only weapon we have as to why you should not use it". You may disagree with me, but a while ago I tried to enter the discussion...
  • SharePoint User Group Meetings in UK (Newcastle and Reading) in September

    I got this e-mail today from the UK SharePoint User Group. They have two meetings coming up, one in Reading and one in Newcastle. Since SBS includes WSS and you can easily load WSS v3 onto it too, here are the details: Newcastle - 10th September MOSS MVP and general all round nice guy Spencer Harbar will be presenting an evening of goodness for all that attend. Arrive 6:30 for a 7pm start 1st Presentation: MOSS Server Farm Architecture & Design. This session introduces the fundamentals of MOSS Farm design including server roles, topology constraints and design goals which are paramount for delivery of a secure, available and scalable MOSS hosting platform. Each server roles’ unique characteristics will be covered with their associated trade-offs. In addition, three common models will be presented with a discussion of their strengths and weaknesses. 20 minute food and drinks break 2nd Presentatoin: Top 10 Tips for your SharePoint Development Environment. This session will present 10 essential tips, tricks, tweaks or utilities for making your SharePoint Development easier and quicker. All tips can be used equally in a Virtual Machine or on a “real” server. Many of the tips are also useful for systems administrators working with SharePoint 2007 location: BT, Unit 7, room 3, Innovation Place , Delta Bank, Newcastle upon Tyne, NE11 9DJ Please post your full name here if you with to attend. Reading - 17th September The famous Patrick Tisseghem is over from Belgium so it seemed like a great opportunity to arrange a meeting. 1800 - 1830 arrive 1830 - 1930 - OBA, Office Business Applications Explained - Patrick Tissegham This talk provides an overview of Office Business Applications. OBAs connect Line of Business (LOB) systems with the people that use them through the familiar user interface of Microsoft Office. They enable businesses to extend the Microsoft Office clients and servers into business processes running in LOB applications such as Enterprise Resource Planning (ERP), Customer Relationship Management (CRM),...
  • How to submit your templates to Microsoft for inclusion in the Office Template site

    I saw this and thought it was amazing. If you have a template that is good and you want to make it available to others, simply package it up (save it without personal information in it) and pop along to this site ( https://services.office.microsoft.com/en-us/templates/submission.aspx ) to post it. I like this - power to the people!! ttfn David Technorati Tags: Office 2007 , Templates , Community
  • Application news for developers - x64 support, application people ready assessments, Vista Gadget security inspection and SharePoint development

    While I am on holiday I thought I would forward these items for the developers out there. The http://blogs.iis.net blog looks awesome for IIS7 information, including videos and the other MSDN information demonstrates how to develop SharePoint tools. Application support Is Your Application Platform People-Ready? Complete the Self-Assessment and Find Out Take the Application Platform Infrastructure Optimisation assessment to measure the effectiveness of your current infrastructure in platform-agnostic terms, and compare your application platform infrastructure against industry best practices and the latest IT research. http://www.microsoft.com/business/peopleready/appplat/ac/apio.mspx Inspect Your Gadget http://msdn2.microsoft.com/en-us/security/bb498012.aspx Today, the Windows Vista Sidebar hosts Gadgets built from HTML, JavaScript, and potentially ActiveX controls. Because Gadgets are HTML, they are subject to Cross-site Scripting style bugs. These bugs are extremely serious because script in the Sidebar is capable of running arbitrary code in the context of the locally logged-on user. This article outlines some of the secure programming best practices that should be considered when building Windows Vista Sidebar Gadgets. ISV Support for Windows Server X64 White Paper The time is right for ISVs and developers to make the move to supporting their existing applications and developing new native applications for Windows Server x64 Edition. IIS7 related videos on blogs.iis.net Tips for Classic ASP developers on IIS7 I was reminded the other day just how many classic ASP applications and developers there are out there! The original ASP rocks, I remember experiencing it for the first time back in 1996/97 when it first came out with IIS3, and being amazed at h ... http://blogs.iis.net/bills/archive/2007/05/21/tips-for-classic-asp-developers-on-iis7.aspx Using ASP.NET Forms Authentication with all types of content on IIS7 (Video) One of my favorite ASP.NET features is forms authentication, supported by the powerful membership...
  • SharePoint webcasts, business information, KB support information and developer information

    When I talk to partners delivering solutions on Windows SharePoint Services V2, V3 and even for some Portal server is becoming a real business opportunity. When I met with Vin of Wem & Co the other day, some of the stuff they were doing was amazing! Anyway, here are the 3 things I thought might be useful - one being the SharePoint VHD so you can just download and play. SharePoint information Creating Business Value through Better Collaboration http://www.microsoft.com/downloads/Browse.aspx?DisplayLang=en&nr=20&productId=353C4E9D-9E78-4435-A360-01BB7F540D17&sortCriteria=date Tools Office SharePoint Server 2007 VHD This download comes as a pre-configured VHD. This download enables you evaluate Microsoft Office SharePoint Server 2007. http://www.microsoft.com/downloads/Browse.aspx?DisplayLang=en&nr=20&productId=353C4E9D-9E78-4435-A360-01BB7F540D17&sortCriteria=date Webcasts TechNet Webcast: Workflow in Microsoft SharePoint Products and Technologies 2007: Out-of-the-Box and Creating Custom Workflows (Level 200) In this session, we discuss the integration of Windows Workflow Foundation into Windows SharePoint Services version 3.0; how workflows are designed, stored, and used; and which capabilities are enhanced by taking advantage of client and server technology. We explain different authoring tools and techniques, including how to create no-code workflows using Microsoft Office SharePoint Designer 2007 and provide guidance on deployment and management in a Microsoft Office SharePoint Server 2007 environment. http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032340734%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22%2f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParams%5e TechNet Webcast: An In-Depth Look at SharePoint Server 2007 Search Technology (Level 200) In this...
  • How do I take a public folder offline

    I seem to have been asked this a number of times recently, so here is the answer. To take a public folder offline, simply add it to your favourites and then enable synching of public folders. Mark the public folder as a favourite (right click on the folder and select make favourite Go into your account settings and ensure that public folders are enabled for caching Tools / Account / Properties for the Exchange Account / More Settings / Advanced - then tick the box Now, when you sync the favourite public folders will be copied too. That is it ttfn David Technorati Tags: Offline , Public Folders
  • Questions from today's Webcast

    I promised to load the questions from todays webcast. The blog on the webcast can be found at Slides from todays Webcast on Windows SharePoint Services on SBS (WSS v2 & WSS v3) . The Questions were: Do uploaded files take up space in the system partition or can they be stored in a different partition They can do - all files are stored in the SQL database, so moving the SQL database will move the files from the system partition. if the existing SharePoint 2 is almost empty - will you loose out anything if you upgrade? Don't upgrade it - do a clean install and then move data across Do you recommend any books for end-user/creators? If you do this search, you can see a couple of books http://search.live.com/results.aspx?q=windows+sharepoint+services+book+sbs&src=IE-SearchBox - some people seem to rate the step by step book. You have a contacts list, can a specific detailed with field relevant to my business be created? Any fields can be added or removed from the WSS contacts fields, so yes, you can create specific fields and make them mandatory if you want Can the Share Point SQL Data be moved to another server by copying the SQL Database file or is there more involved Moving the SQL database using standard SQL processes will work just fine. WSS talks to SQL, so providing the SQL Services are running normally everything will be fine Can you give non members of the domain access to view specific area and documents You can enable anonymous access to the site and then control what anonymous users see. Other users can sign in to see secured data. You mention Webcasts on WSS, are the links on your website? These are not on my site, but if you look a the TechNet site or the webcast announcements in my blog you will find them. ttfn David Technorati Tags: WSS , WSS v2 , WSS v3 , Sharepoint , Windows SharePoint Services , Webcasts , Questions
  • Slides from todays Webcast on Windows SharePoint Services on SBS (WSS v2 & WSS v3)

    Today I did my last Webcast on SBS. It was the 3rd of a 3 parter on SBS. Part 1 was about how to use the OPK, part 2 was on Configuring SBS. I will post links to part 1 & 2 later today, but thought I would get the last one out 1st. If you watched the Webcast you will know that explorer crashed on my machine stopping the demos with word and excel working, which was not desired, but I did load 2 beta patches onto my system yesterday, so now the diagnosis as to wether that was the problem begins. Anyway, if you want the slides set they can be found here . Some of the useful links from the deck are: WSS v2 Office 2003 web parts (the last ones) http://www.microsoft.com/downloads/details.aspx?familyid=38be67a5-2056-46a1-84b1-337ffb549c5c&displaylang=en Samples and information http://www.sharepointcustomization.com/wss/articles.htm Enable Office 2007 support http://uksbsguy.com/blogs/doverton/archive/2007/03/13/how-to-get-companyweb-windows-sharepoint-services-v2-to-work-with-office-2007.aspx Backup and restore of WSS using admin command line http://www.microsoft.com/smallbusiness/support/articles/backup_restore_sbs2003.mspx#EPDAE Recycle bin support in WSS v2 http://mindsharpblogs.com/Todd/archive/2005/10/06/719.aspx WSS v3 Comparison of v2 & v3 features http://www.microsoft.com/technet/windowsserver/sharepoint/techref/versions.mspx External access to v3 site & renaming it to companyweb http://msmvps.com/blogs/cgross/archive/2007/01/25/companyweb-sharepoint-v3-part-1.aspx - Enable e-mail for WSS v3 site http://www.mrict.co.uk/resources/incoming_email_for_wss_3_and_sbs.asp Since the Office integration failed to fire due to the beta patches I will re-record these and post on the web. ttfn David Technorati Tags: WSS v2 , WSS v3 , Windows SharePoint Services , SBS 2003 , SBS 2003 R2 , Office System
  • Simple overview of what is in Windows SharePoint Services 2007 & MOSS 2007 and how to develop on them

    For those who wish to expand into SharePoint enhancements (remember that you can enhance the site without any dev tools using the browser features) I found this simple blog entry ( Know your options for developing with SharePoint 2007 - Program - .Net - Builder AU ) and it is quite nice. Read the whole blog, but here is a snippet. The editions of SharePoint One of the more confusing aspects of SharePoint is that there are two versions available: Windows SharePoint Services (WSS) 3.0 and Microsoft Office SharePoint Server (MOSS) 2007. Developers follow the same basic steps to get started with SharePoint regardless of the version. Here's an overview of both offerings. |> WSS: This is the so-called "free" version, as there are no additional licensing issues. It is included with the Windows Server 2003 operating system (version 2.0). The current 3.0 version is available via download. It provides core document management, collaboration, and search functions, which include blogs, wikis, RSS feeds, e-mail support, and Office 2003/2007 integration to name a few. WSS will suffice for small organisations or departments. |> MOSS: The server product is built on top of WSS. Along with the core WSS functions, it adds enterprise search and people search capabilities, along with an unlimited document repository, personal sites, additional Web parts, workflow, content syndication, and much more. MOSS targets organisations that will store more than 500,000 documents, which are usually larger enterprise customers. SharePoint utilises SQL Server on the backend. You may choose to use an existing SQL Server installation or the limited version (think MSDE) included with it. Development tools There is more than one way to get involved with SharePoint development. The most basic approach involves a FrontPage-esque tool and evolves to full-blown development with Visual Studio. Before exploring external tools, SharePoint provides browser-based editing tools that allow you to manipulate and customise SharePoint applications...
  • Upgrading to Office 2007 using retail boxes - what can you upgrade from

    [updated to change blog title to something meaningful] I was asked about this today - for those people with retail copies of Office, what can they upgrade from to Office 2007. Full details on Word, Excel, Access, Publisher and the suites can be found at 2007 Microsoft Office system pricing - Products - Microsoft Office Online . To see if you have a retail box of an earlier version of Office and if it will load without you needing to upgrade onto a new machine with Vista, have a look at http://uksbsguy.com/blogs/doverton/archive/2007/05/09/buying-vista-and-then-installing-an-old-version-of-office-whatare-you-allowed-to-do.aspx 2007 Microsoft Office suites 2007 Microsoft Office Suites Estimated Retail Price /Upgrade Price Qualifying Products for Upgrade Microsoft Office Basic 2007 Available only through OEMs; price not quoted Upgrade not applicable. Microsoft Office Home and Student 2007 $149/NA Upgrade not applicable. Microsoft Office Standard 2007 $399/$239 Microsoft Works 6.0–10; Microsoft Works suite 2000–2006 or later; any 2000–2007 Microsoft Office program or suite; any Microsoft Office XP suite except Office XP Student and Teacher. Microsoft Office Small Business 2007 $449/$279 Microsoft Works 6.0–10; Microsoft Works suite 2000–2006 or later; any 2000–2007 Microsoft Office program or suite; any Microsoft Office XP suite except Office XP Student and Teacher. Microsoft Office Professional 2007 $499/$329 Microsoft Works 6.0–10; Microsoft Works suite 2000–2006 or later; any 2000-2007 Microsoft Office program or suite; any Microsoft Office XP suite except Office XP Student and Teacher. Microsoft Office Ultimate 2007 $679/$539 Microsoft Works 6.0–10; Microsoft Works suite 2000–2006 or later; any 2000-2007 Microsoft Office program or suite; any Microsoft Office XP suite except Office XP Student and Teacher. Microsoft Office Professional Plus 2007 Available only through volume licensing; price not quoted Upgrade not applicable. Microsoft Office Enterprise 2007 Available only through volume licensing; price not quoted...
  • How to enable cached mode for Outlook when used inside Terminal Server (which means that BCM can work too)

    OK, this is in response to the people who have posted on this subject. Someone was kind enough to give me the exact details, but I shall protect my sources except to say they know the insides of MS tools well. The warning here is that this is unsupported and could completely destroy your users profiles, so only do this is you are comfortable editing the registry The short description: Open up Regedit navigate to [HKCU\Software\Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem\Profiles\<ProfileName>\13dbb0c8aa05101a9bb000aa002fc45a] Find the key 00036601 (REG_BINARY) - note the number in it now so you can undo the changes if needed Change the value to one of the following enabled value; 84 01 00 00 - note that on my desktop system the enabled value is 84 19 00 00, so play around with this a little enabled with Public Folders/Favorites: 84 05 00 00 disabled value; 04 00 00 00 FYI - you will need to search for "00036601" and adjust ALL of them since each key is for a different user on your system. ttfn David Technorati Tags: Cached Mode in Outlook , Office 2007 , Terminal Services
  • Business Contact Manager 2007 (BCM) is NOT supported on Windows Terminal Server, but a little hack will make it work

    [updated on 28th July] Hi, I've pinged this around a bit internally and the answer I got back is that this is not supported and will not work. I have not tried it myself, but don't expect it to work. If you need this sort of functionality you need to look at MS-CRM I am afraid. History: You need a Volume License of Office 2007 to run in Terminal Services. You can get BCM with Volume Licensing of Office 2007 as noted at http://office.microsoft.com/en-gb/suites/FX101635841033.aspx Outlook running in Terminal Services does not run in cached mode - http://technet2.microsoft.com/Office/en-us/library/ba930d00-dc38-4564-ad00-8304d74f1d8c1033.mspx?mfr=true 3) BCM requires Outlook to run in cached mode (Office 2003 note in a KB about this - http://support.microsoft.com/kb/831747/en-us and I have had PSS confirm this is still the case with BCM and Office 2007) Wish this was not the case, but better to say up front rather than pretend. Now, updated, if you look at How to enable cached mode for Outlook when used inside Terminal Server (which means that BCM can work too) then you can see how to enable cached mode, so providing you have a Volume License you can use BCM inside Terminal Services ttfn David Technorati Tags: BCM , Business Contact Manager , Office 2007 , Small Business
  • Unified Communications

    This information is from the last 2 Technet newsletters ( http://www.microsoft.com/technet ) Unified Communications Team Blog http://blogs.technet.com/uc/default.aspx Unified Communications - Office Communication Server 2007 Videos Two videos, one on Office Communications Server 2007 and one on Office RoundTable http://www.microsoft.com/downloads/info.aspx?na=22&p=4&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3d67d3e846-ae4a-4b30-9e0c-eac22bd2a58a%26DisplayLang%3den Unified Communications and Collaboration Event Presentation Downloads Unified Communications and Collaborations Event Downloads http://www.microsoft.com/downloads/info.aspx?na=22&p=5&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3da10931b2-dceb-4ddc-8c5a-25c4b2c5804c%26DisplayLang%3den Using Exchange Server 2007 for Unified Messaging and Fax How can you best implement the Unified Messaging (UM) features of Exchange Server 2007? Microsoft IT uses the UM features of Exchange Server 2007 to integrate voice messaging with the internal e-mail messaging environment. This content will detail the technical implementation and deployment strategy for deploying Exchange 2007 Unified Messaging features in the Microsoft enterprise messaging environment. http://www.microsoft.com/downloads/info.aspx?na=22&p=9&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=&u=%2fdownloads%2fdetails.aspx%3fFamilyID%3dde6b24ab-0d23-4d82-ac2e-342a86b22580%26DisplayLang%3den ttfn David Technorati Tags: Unified Communications , Office Communications Server , Exchange 2007 , RoundTable
  • Windows SharePoint Services (WSS) v3, SharePoint Portal and Office Communicator, Partner Sales 101 and Dynamics and CRM training

    Office Communications Server 2007 Ignite Workshop This two-day workshop introduces many of the new features and capabilities that are built into Microsoft Office Communications Server 2007, including Rich Presence, Instant Messaging, Audio/Video Conferencing, and Voice. Click here to enrol. Implementing and Maintaining Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 Course This is a residential, intensive and compressed course intended for those partners who want to get a head start on the new SharePoint certifications. Ten days compressed into five Training for 12+ hours a day Residential course, with 24 hour availability of labs and instructor Exams taken during the week Limited number of seats – few deliveries are planned, so if you want your Partners to attend please encourage them to sign up now Click here for more information or to enrol Partner Sales 101 The next one is being held on the 11 th September 2007 Aim: This session will equip sales people with the knowledge and skills that will enable them to talk to new and existing customers about the business benefits of Microsoft technologies, and associated areas such as licensing. Target Audience : This session is aimed at sales people. People within a partner organisation who present technology solutions to customers from a non-technical or business point of view and people who are not technical experts and do not demonstrate software, but talk about the possible solution outcome. Objectives : For the sales person to gain an understanding of all key Microsoft technologies, with additional focus on infrastructure, and the Portals and Business Intelligence solutions, Windows Vista, Office 2007,the Microsoft Dynamics products and the fundamentals of Microsoft licensing. Click Here to register. Dynamics Sales Workshop Being held on the 20 th September 2007 Aim : This one day course and workshop that will equip your Partners with the unique value proposition for you & Microsoft Dynamics, the Microsoft Dynamics Strategic value proposition...
  • Show Classic Menus and Toolbars on Ribbon of Office 2007 - two product choices

    I saw a blog entry at Susan Bradley's blog about her now deploying Office 2007 with a classic menu . It was worth of a blog link for all those who want to stick to the old, old ways where you search for items over multiple menus (especially if you turn on personalised menus which hide all the things you don't use regularly). The tool looks slick, but then I found a 2nd one are realised that some cunning ISVs had seen this as their great opportunity to fill a gap that is very unlikely to be filled by Microsoft. The Two solutions are shown below and can be linked to from pschmid.net - RibbonCustomizer™ Feature Tour - Part 3: Classic UI Tabs and Show Classic Menus and Toolbars on Ribbon of Office 2007 : V1.1 Feature Tour - Part 3: Classic UI Tabs RibbonCustomizer™ V1.1 ships with a set of Classic UI tabs for Excel, PowerPoint and Word 2007. Those tabs emulate the Office 2003 menus and toolbars in Office 2007. We provide these tabs to help you familiarize yourself faster with the new Ribbon User Interface in Office 2007. Please note that the tabs are not intended to be full replacements for the Ribbon. There are no plans to provide similar Classic UI tabs for Access and Outlook 2007. The Classic UI tabs can be used with the free Starter Edition of RibbonCustomizer™. This means that you can get the 2003 menus and toolbars in Office 2007 without having to make any purchase. The Classic UI tab can be shown as the first tab, as shown in the following Excel 2007 screenshot: Alternatively, you can show the Classic UI tab as last tab, as again demonstrated in Excel: You could display the two Classic UI tabs also at the same time. The Classic UI tab in PowerPoint can be seen in the next screenshot: The Classic UI tab in Word is next: pschmid.net - RibbonCustomizer™ Feature Tour - Part 3: Classic UI Tabs Classic Menu for Office 2007 Frustrated by endless searches for features on the Ribbon? Download and install this software to bring back the familiar menus and toolbars to Microsoft® Office® 2007. The software allows you...
  • How to get rid of the installer / configuration dialog when running Office 2007 and Office 2003 on the same system - for Vista and other versions of Windows

    I have been asked this many times following up on the blog entry Installing Office 2003 and Office 2007 on the same system where once people have removed the problem with the End User Licensing Agreement (EULA) appearing every time they start Office they then get the dialogs below every time they switch between Word 2007 and Word 2003. when starting Word 2003 when starting Word 2007 The fix to the problem is very simple as it turns out - simply run the following commands (by pressing the Windows Key+R or typing it into the Start/Run command box. Use the line with Office\11.0 if you have Office 2003 installed and Office\12.0 if you have Office 2007 installed. You can use both if you have both installed : reg add HKCU\Software\Microsoft\Office\11.0\Word\Options /v NoReReg /t REG_DWORD /d 1 reg add HKCU\Software\Microsoft\Office\12.0\Word\Options /v NoReReg /t REG_DWORD /d 1 That is it. Office 2007 might want to have one more spin round the block with it's configuration dialog box, but that should be it. ttfn David Technorati tags: Office 2003 , Office 2007 Deployment blocker fixed , Word 2003 , Word 2007 , Vista , Install , Same machine
  • Why should a small business use Office 2007

    Once again I thought I would put pen to e-paper on the top reasons I give people to move to Office 2007. I don't think there are many businesses out there that use a PC and don't use some form of office productivity suite and while most use Microsoft Office XX (where XX could be 97, 2000, XP or 2003), some use other products that in my opinion just don't compare for a business that wants to look great and work efficiently. With Office offering a massive choice of products and features, these are the headlines I use when talking to people. For those with a version of Microsoft Office, but not 2007 More Professional and Impressive documents and materials Use Microsoft Publisher 2007 to build sales and marketing materials that look agency made, but are actually in-house work The updated Microsoft Word 2007 has many features to ensure your documents have a professional, consistent look and feel throughout the whole document conforming to your brand goals (no matter how big or small they might be). The readability tests will also share with you how easy it is for someone to understand the document. Writing can be so unengaging, yet pictures are often very time consuming to get right. Using the new text features, features such as subtle shading or reflections or glowing words are a click away and can make text dazzle. For the words that can be better communicated in a picture the impressive Smart Art feature can take a simple list and turn it into a process diagram, or an organisation chart and all with any of the new professional style schemes to be sure to enhance the impact. Most people can recognise an "old" Excel charts - the colours are bland and the charts often quite flat. For this very reason the charts in Office 2007 have been given a significant facelift to ensure they look professional, while still conveying the information they are supposed to. While sending an Office document to someone is very common, sometimes you want to be able to send something they can't edit, such as a price...
  • How to find and use an Accounting template to use with Office Excel 2007 and then change it from US to UK currency, change the formatting of dates and drag lists (or Excel Tips and Tricks 1) - 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 these features in Excel 2007 and apply them to all of the Office 2007 applications: Find a template and use it - I use an accounting template as it is based on Office 2003 and US based Change the currency cells from dollars to pounds using find and replace for formatting Change the date formatting from US to UK Dragging a list across a range of cells to give column a different month To see the Excel 2007 Video played using Silverlight (just try it) click here *. If you want to download it as a WMV file then head over to the new bCentral - the UK Small Business Center on MS.com - It is on this page as an Excel Accounting sample: * 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 as I went. When presenting to an audience it is easy to correct anything you do without anyone caring, however I tried to fix up the videos so this was not a problem. This has one drawback which is that the sound is not that good (one of those things I want to fix, but have not yet got round to) due to editing & cutting of the videos. I find it really hard to talk and move the mouse to the right place at the same time without a fluff in either my words or my mouse movements. Having captured the video is was simple to turn them into "Silverlight" Videos that were hosted on the Silverlight Streaming site for your pleasure - if you like them I can do more. Feel free to re-record the audio and play for your customers of make as a download for them. I have cut 10 videos to date and will release them over the next 2 weeks. The videos cover: For Vista - How to...
  • How to connect to and import data from an XML Web Service into Excel 2007

    I have been wondering how to do this recently for one of my own projects and then the subject came up internally. A very unassuming Hovsep then wrote up the answer, so as a tip here it is - if you follow the link at the bottom you will see a step by step process with screen shots to help you along the way. Excel 2007 - How to connect to and import data from an XML Web Service Many organizations have adopted a Service-Oriented Architecture (SOA) as the architecture of choice. SOA allows a company to expose its services and data in a manner that is compliant with industry standards. SOA is the buzzword these days. Down the wire of SOA is XML data that is exchanged between entities. Microsoft Office Excel 2007 has built-in features that allow a user to connect to and consume XML data. Such data can be stored in an XML file on the local hard drive, shared in a portal or returned from an XML Web Service. If you’d like to use Excel to import XML data from a Web Service, follow these step-by-step guidelines. For the sake of simplicity, this document will be using a web service that is available on the Internet called Teach a Techie ( http://teachatechie.com ). This web service has a function named GetLocation and the URL we’ll be using is http://teachatechie.com/GJTTWebServices/ZipCode.asmx/GetLocation?ZipCode=11413 Go to Hovsep uses SQL Server for Development : Excel 2007 - How to connect to and import data from an XML Web Service for all the details ttfn & thanks to Hovsep. David Technorati Tags: Excel 2007 , Web Services
  • 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 line items, all you do is select them in an opportunity and use % discounts to make them fit. For example, if you wanted to give £2,000 discount, simply add the trade in (1000) qty 2 to the opportunity. You can add a higher number and then discount down, so for example if you want to add a trade in of £39,000 then you would discount by 2.5% and have a qty of 4 for trade in (10000) - see the picture on the left. Hopefully this little kludge will enable you to do trade-ins. ttfn David Technorati Tags: BCM , Business Contact Manager , Office 2007 , Trade Ins , Discounts , How to
  • 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 improved financial control and an umbrella view of client activities for smaller law firms that are trying keep costs down. ttfn David Technorati Tags: Office Live , Windows Live , Small Business
  • David Overton moving on to pastures new

    With a tear in my eye the time has come for me to move my stick hut somewhere new. I have loved working in and with the small business community and with a set of awesome partners who can complain and nag, but normally with good cause and that are more willing to say thank-you and "good job" when the time is right. To you all I take my hat off for making me feel so welcome. As a legacy we now have SBSC up and running, partner groups that support themselves, a voice into Microsoft from the smaller end of the partner community and a better understanding of the motivations of both Microsoft and our partners. We also have a new level of engagement with customers. I wish I could take credit for all of this, but I am just a figurehead for a great team of people inside Microsoft. A nice chap called Mark in the OEM team will be helping to drive Cougar knowledge through the community when the time comes (no, this is not the time yet, trust me), SBSC has been supported by Jen as many of you would have seen from the e-mails and SBS has a product manager who cares in the form of Sonal. Finally campaigns like Mr Busy prove that while we still have some implementation details to improve on, the ideas are getting better and better and the team responsible for these will continue to push forward on this front. They say you can take the boy out of the small business, but not small business out of the boy and this will be true for me - the blog will continue and I will still try to be a voice of reason and rant as I feel appropriate and pass on comments to the right people internally within Microsoft, just realise that I have less time to do this now. This points to the fact that I will still be with Microsoft. My next challenge is to help those ISVs (Independent Software Vendors) who wish it to move further along a path with Microsoft to do so, whether they already work with us today or not. This should be a fun challenge - viewing all of the Microsoft world as a platform rather than a solution, but this is something I have...
  • 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
  • How to customize Business Contact Manager 2007 forms in Outlook 2007

    I found this on the Office Website when someone asked me about form customisation for BCM. I thought I would share it. Demo: Customize Business Contact Manager forms You can customize Microsoft Office Outlook 2007 with Business Contact Manager forms by adding fields and list items (drop-down lists) that are unique to your business. You can customize the following types of forms: Account Business Contact Opportunity Business Project You can customize drop-down lists by clicking Edit this list and then adding your item to the list. Watch this short demo to see how to customize a Business Contact Manager for Outlook form. How to do it (text version) Customize your Business Contact Manager forms through user-defined fields Customize drop-down lists on Business Contact Manager forms Demo: Customize Business Contact Manager forms - Outlook - Microsoft Office Online ttfn David Technorati Tags: Business Contact Manager , BCM , Customise , Customize
  • Spreadsheets and documents based on standards - OpenXML and ODF, ODF and Excel or all 3

    I have been using and referencing standards for a long time. They are great. C# is an ECMA standard for example as are parts of .Net which is how project Mono has managed to come great strides in delivering part of the .Net experience on non-Microsoft platforms. Also my 1st job out after University was writing document converters. So there are two things here - one, what is wrong with more than 1 standard - we have several for networks, several for character sets. Often one standard will work where another will not. Nearly always one standard is driven by an interested party. Open Office is very keen to see greater adoption of ODF. Microsoft is very keen to seen greater adoption of OpenXML. OpenXML is already a European standard (ECMA) and one of the nice things about that is the stability you are offered if you are developing against it. There is no requirement to have Office to use this file format. OK, so we could say "lets not use the European standard and create a similar one, but not quite the same" - so we have Office 2007 and the ECMA standard in one camp competing against a similar almost identical offering elsewhere... not really ideal. Now to ODF, the "why don't we all just use ODF" standard? Well, you know how those little details can be a killer - how about this? The formulas in ODF spreadsheets are NOT covered by the standard, so ANY string that goes into a cell is just that. It is down to the individual implementation as to which formulas to support or not. This alone says to me that ODF can't be used as a serious interchange standard (if it is just used as the document file format for OpenOffice then why bother with it as a standard?). it is the same with Macro's. They can be stored, but no talk about the language they use or how they work, so again, you have a document you can open, but not know if the formulas will work etc. So, if you think there is any merit in having more than 1 document format in the world, please click here and sign the petition . For more information...
  • Darren Strange of Office 2007 / 12 fame talks about Max Office document converters and the the role of beta software

    I saw this and thought those of you with Mac customers might find this useful if Office 2007 is around or potentially around in their businesses. Also of note is the fact that beta, trial and RTM seems to be very blurred today. Do you ever deploy beta code? I do, often in small environments with big warning labels, but I do do it. Following on from some of your less than exuberant feedback about the new Mac converters, I looked into it. To summarise, the Mac BU have released the beta 1 of the file format converters of Office for Mac. You can download the converter for Word documents here . More info is at the ever useful macmojo blog First thing to point out is that this is a BETA and also that it is a BETA 1. There is a bug-ette in that apparently it doesn't handle some reserved characters from non-english languages or some special Unicode characters such as ™. Any docs that have these characters seem to screw up or don't convert at all. Apparently the issues with Unicode was documented in the help with the beta. There is a fix which will roll out with beta 2 of the converter which is due out soon but I can't tell you when. This is good to know but doesn't answer why it apparently needs admin rights to run. What interests me about this is people's expectation for product quality from a beta 1 now. I remember the day when anything short of RTM was not to be used in production and when beta 1 would be considered only for the enthusiast. Now that we live in the world of Internet startups, betas seem to be the norm. Office Rocker! : beta by far: the role of trial software - click for more! ttfn David Technorati Tags: Mac OS X , Mac Office , Office 2007 , beta
  • Microsoft Office Outlook Connector Beta (how to connect Office Live Basics or Windows Live Hotmail to Outlook)

    Don't you love the way the title of a product described what it is? While this product does what it says on the tin, it misses out the most important thing - what can you connect Outlook to. The answer is e-mail and contacts based on our Hotmail service, so this includes OfficeLive. If you sign up to one of the subscription OfficeLive services (i.e. you pay us to use it) then you get a connector which can do all this AND synchronise your calendar items too. Once in Outlook you can do all the searching, filing and manipulation you want to do. Today you can now download the beta of the next version of the Microsoft Office Outlook Connector. Download: Microsoft Office Outlook Connector (Beta) The Microsoft Office Outlook Connector is designed to let you access your Windows Live Hotmail account through Outlook 2003 or Outlook 2007. You will be able to download and install the Connector to sync up your email and contacts in Windows Live Hotmail for free. However, if you are a paid subscriber of MSN Premium, Office Live Essentials, or Office Live Premium you will get the added functionality of being able to sync up your calendar, tasks and notes from Outlook to Windows Live Hotmail. I know many of you probably took note to the statement made on the download page of being able to "synchronize your Windows Live Calendar in Outlook". Windows Live Hotmail currently has a built in calendar service which is essentially your Windows Live Calendar. Your calendar from Outlook is published and viewable through this service in Windows Live Hotmail. The Windows Experience Blog : Microsoft Office Outlook Connector Beta Now Available ttfn David Technorati Tags: Outlook , OfficeLive , Sync , beta
  • Go to MSN today to see a great Office 2007 advert - interact with the web page using a Word 2007 ribbon - today only 12th June

    This is a quick one - hope along to http://uk.msn.com and today you will be greeted with the Office 2007 ribbon bar. You can change the formatting of the picture or the MSN section at the top using the live preview function of Office 2007. This will be 24 hours only I am told, so about 14 3/4 hours left! Image changes as you hover over the formats - available in Office 2007 and now MSN UK for the day!! We also have style changes on the headers. ttfn David Technorati Tags: MSN , Office 2007
  • Whatever happened to FrontPage and what has it got to do with SharePoint Designer or Web Expression

    I seem to be being asked this a lot, so I thought I would pop up my simple answer: FrontPage has been both extended and then split into two products. We now have SharePoint Designer which is one child of FrontPage, but obviously ideally suited to modifying SharePoint (and OfficeLive) sites and then we have the “any type of web page editor” which is Expression Web. If you look at http://www.microsoft.com/products/expression/en/web_designer/fpwd_faq.mspx you will also see: How is Expression Web different from Microsoft Office FrontPage 2003? Expression Web builds on Microsoft Office FrontPage® 2003 technologies to provide an unprecedented level of support for creating standards-based Web sites. Valuable feedback from customers like you have helped us create a new product that fully supports Web standards such as Extensible Hypertext Markup Language (XHTML), cascading style sheets (CSS), and Extensible Markup Language (XML). If you are familiar with FrontPage, then you will find Expression Web easy to use. Expression Web has strong CSS support and takes full advantage of the power of ASP.NET 2.0 with integrated support for server and user controls. Who is Expression Web for? Expression Web is designed for creative professionals. However, experienced WYSIWYG Web designers will also appreciate the extensive features of Expression Web. No technical background is required to start using Expression Web. Convenient task panes and menus help users build attractive and compelling Web pages without knowing any markup or server code. How is Expression Web different from Microsoft Office SharePoint Designer 2007? Microsoft Office SharePoint® Designer 2007puts the emphasis on creating and customizing SharePoint Web sites. Expression Web is a new product for creating standards-based Web sites. The two products share common technologies including a high-fidelity design surface with deep support for CSS and ASP.NET. Can I use Expression Web to work on files created in FrontPage? Yes. You can use Expression Web to open Web sites created...
  • Office XP, 2003, 2007 feature comparison for small businesses

    I saw this on the Small Business site in the US and thought it was an excellent tool as to what has changed between the versions of Office from XP through to Office 2007. Simply go to http://www.microsoft.com/smallbusiness/products/wowpc/CompareOffice.aspx and click out the tabs to get the details. Ttfn David Technorati Tags: Office System , Office 2007 , Office 2003 , Office XP , Comparison , Small Business
  • 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
  • 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
  • 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 done by Office Live and of course, the Office Live Recycle Bin is there in case it is needed. If neither of these needs to be used, everything is handled in Access 2007, i.e. the normal end-user just sees Access 2007 and no web user interface. The image below shows the main screen of the application, i.e. where the main customer contact information is entered. Source: Clint Covington: Software design, Microsoft Office Access : Cool As Ice uses Office Live and Access 2007 with custom ribbon ttfn David Technorati Tags: Office Live , Access
  • 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 bread roll?” said Jonathan. “But the English language is constantly changing. Due to a complex combination of influences, local words occasionally disappear from common usage or are replaced by others which become absorbed into our everyday vocabulary.” Darren Strange, Microsoft Office 2007 product manager, will also join Jonathan in judging the contributions to the new online dictionaries. “Lots of people believe that regional dialects are dying out, but this is a popular misconception,” added Darren. “It’s the diversity of Britain’s dialects that has led us to develop the new dictionaries. So in future, your Microsoft Outlook will be able to recognise emails where you ask your ‘marra’ to get you a ‘buttie’ instead of inserting red lines beneath all the unfamiliar words,” said Darren Strange. “We wanted to give everyone the chance to adapt and personalise their software, and at the same time recognise the diversity of dialects we use here in the UK that makes us completely different to any other country...
  • 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 felt like a development tool at times and a throw back to the days of Word 95. I've included the comprehensive screen shots here with the aim of allowing anyone to recreate this experiment. Thankfully, this is a science project, not a business. Source: Chris Parkes: A PC is not just for Christmas... : Microsoft Office Word 2007 and OpenOffice.org 2.2.0 Mail Merge Comparison ttfn David Technorati tags: OpenOffice , Office 2007 , Mail merge
  • OneNote Calendar at OneNote PowerToys to view your notes against the day you wrote them

    I saw this and knew it was an awesome tool! Josh Einstein, the developer of TEO 3.0, has created a nifty new application for OneNote. The OneNote Calendar gives you a calendar view of all of your notes, allowing you to view them by when they were created or modified. There is a preview pane that allows you to view your notes. More good news. It is free. Source: Josh Einstein’s OneNote Calendar at OneNote PowerToys
  • Want Microsoft to get you leads - this is how you do it

    One of the most commonly asked questions is "How do I get Microsoft to send me leads?" While we run campaigns that point people to the bCentral site and the find a small business IT advisor process some want more direct action. Well, using the Mr Busy campaign you can now get us to carry our a campaign on your behalf. Yes, that is right, we will carry out a campaign on your behalf to people you want to - either by e-mail (EM) or post (DM). The process is really simple - go here and read the instructions. For the Post Card campaign we know that using post cards effectively communicate with your customers and provide short and focused information. You can customise the postcard with your company details, your logo and a relevant web URL and phone number. We advise that the URL you supply has information about the IT healthcheck to increase the number of customers then contacting you. Your postcards will be sent directly to your customers in a neutral envelope within five business days of you submitting the contact list. The timing for a e-mail campaign are good as research has shown that more marketing messages are reach their targets via email than previously. A helpful and targeted communication, headed by a pertinent subject line is an excellent and fast way to contact your customers! Your emails will be sent within two calendar days and you will receive a full reporting, including emails sent, links clicked, bounced emails etc. With this report you will be able to identify the potential within your customer base. To see the output is may be worth putting yourself on the list of recipients :-) In each case it is a 3 stage process: Personalise the campaign Provide company logo It gets sent out Enjoy and tell me about your successes. ttfn David Technorati Tags: If you only read one post today , marketing , it healthcheck
  • How to do mail merge letters and labels in Office 2007

    I got a mail on this today, so thought I had better drop a quick note. The Office 2007 web site has a great search system that got me an answer straight away that includes screen shots to make it real simple. (I searched on the site for mail merge and then picked Word 2007 from the product picker). Please note that you can also e-mail merge to result in a number of e-mails being sent (perhaps with a newsletter) and that if you use publisher then you can also do things like put in place web links that have a unique identifier so you can tell who clicked on them. The answers can be found at: http://office.microsoft.com/en-gb/word/HA100819761033.aspx?pid=CH100626281033 for the letters http://office.microsoft.com/en-gb/word/HA101091611033.aspx?pid=CH100626261033 for the labels ttfn David Technorati tags: mail merge , word 2007 , Office 2007
  • Installing Office 2003 and Office 2007 on the same system

    [updated 16:42 9th May 2007 with url for MS Support of this] [updated 9:45 22nd July 2007 with url to fix for install dialog coming up with word] I was recently asked in Office 2003 and Office 2007 can co-exist on the same system. The answer is yes, except for Outlook which as in previous versions get a little precious if this is attempted (it will not let you do this, btw). You can choose to have them both installed to the same drive or one to an external hard drive, it does not matter. The key option is when installing Office 2007 is to customise the options and select to NOT uninstall the previous versions. When you install both copies of Office to be installed on 1 machine that switching between Word 2003 and Word 2007 will result in an install dialog box coming up. See How to get rid of the installer / configuration dialog when running Office 2007 and Office 2003 on the same system - for Vista and other versions of Windows to fix this. For more support information, look at http://support.microsoft.com/default.aspx/kb/928091 which details the install order and any key requirements Thanks David
  • 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 MS07-029 Critical Windows 2000 (server), Windows Server 2003 Remote Code Execution Summaries for these new security bulletins may be found at the following pages: http://www.microsoft.com/technet/security/bulletin/ms07-May.mspx Customers are advised to review the information in the bulletins, test and deploy the updates immediately in their environments, if applicable. Microsoft Windows Malicious Software Removal Tool Microsoft is releasing an updated version of the Microsoft Windows Malicious Software Removal Tool on Windows Server Update Services (WSUS), Windows Update (WU) and the Download Center. Note that this tool will NOT be distributed using Software Update Services (SUS). Information on the Microsoft Windows Malicious Software Removal Tool can be located here: http://go.microsoft.com/fwlink/?LinkId=40573 High-Priority Non-Security Updates on Microsoft Update (MU), Windows Update (WU), Windows Server Update Services (WSUS) and Software Update Services (SUS) Microsoft is also releasing High-Priority...
  • How to remove those spaces before, after and inbetween paragraphs in Word 2007 (Part of Office 2007)

    I got this mail on the blog today, so decided I would post a solution: 2007 Vista Student and Office Edition does not allow me to create one line spacing in Address Headings but okay within the body of the letter, is this a glitch. I have never experienced this in my former Word Programs. In the dialog box it does specify single spacing. Any advice would be appreciated I have created a simple document and you might notice that there is a big gap between each sentence. This is caused by both line spacing and space before or after the paragraphs. I will walk you through the process I went through to make things look less spaced out. To do all of this I will be using just one icon on the ribbon bar - the one circled below If I hover over this, you can see it is for line spacing. The 1st thing I did was highlight my text and try setting the line spacing to 1.0 - you can see the result is that the text is slightly closer together. Next I clicked the "Remove Space Before Paragraph" option and you will notice that things now look as they should do. Now if I select the top line as a heading, all the space has gone, but there is a huge chunck of space at the top, doing the same as above to the heading sorted that out too :-) The finished product ttfn David Technorati tags: Office 2007 , Tips
  • What is the difference between an Outlook contact and a Business Contact Manager (BCM in Office 2007) contact

    I was asked this by someone today and thought I would show you the differences BCM Contact General Page followed by the Outlook Contact General Page: There are lots of differences, but the big ones are: Information Source - where did it come from, how did you get this contact and which account started it. Classification - Is this a lead and is the person still "active". Also who is managing this person, what their credit rating is and whether there is a payment issue BCM Details Page followed by the Outlook Details Page: A host of job related information and then a section for personal information about the person, plus a huge comments section. There is also the communication preferences piece and the ability to suppress mailings (do not call, do not e-mail, do not fax, do not mail (write to on paper)). Finally the BCM (only) History Page: Some of this information can be automatically generated, so for example, the e-mail items can be auto generated whenever you mail, or they mail you. ttfn David Technorati Tags: BCM , Business Contact Manager , Contact
  • 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 to be the charting feature in Excel 2007. Try a free 60-day trial of the 2007 Office system by visiting TryMicrosoftOffice.com . ttfn David Technorati Tags: Whihc Office Version are you
  • Speed issues with large OSTs & PSTs patch for Outlook 2007 Available

    I saw this over at the The Official SBS Blog and thought I had better tell everyone about it given the traffic on the web page. Once you apply this patch you might get an BCM (Business Contact Manager) error if you have installed it - to fix this, go look at My BCM Updates Post and grab the one about "Outlook 2007 with Business Contact Manager: Prevent error message about version mismatch when certain Office 2007 applications are launched". [Today's post comes to us courtesy of Mark Stanfill] There is a new patch available for Outlook 2007 that fixes performance issues with large PSTs/OSTs. We highly recommend applying this patch on all systems with Outlook 2007 installed. If you are preparing a new installation, this patch should be applied in addition to the steps outlined in http://support.microsoft.com/default.aspx?scid=kb;EN-US;926505 . Direct Download: http://www.microsoft.com/downloads/details.aspx?FamilyID=c262bcfd-1e09-49b6-9003-c4c47539df66&DisplayLang=en KB article: http://support.microsoft.com/?kbid=933493 Source: The Official SBS Blog : Outlook 2007 Update Available ttfn David Technorati Tags: Office 2007 , Performance , BCM , Business Contact Manager

(c)David Overton 2006-13