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.  

Browse by Tags

  • 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...
  • 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. (Updated 16th Feb 2017 with a typo correction) 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? /maxage:%x0101 /minage:%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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
1 2 3 4 5 Next > ... Last »

(c)David Overton 2006-18