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

  • 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...
  • 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
  • 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...
  • 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...
  • 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...
  • 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...
  • 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
  • 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...
  • 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...
  • 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
  • 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
  • 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...
  • 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,...
  • 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
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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
  • 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...

(c)David Overton 2006-18