DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  
David Overton's Blog » All Tags » Tips » Office System (RSS)

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

  • Can't find the WSS (Windows SharePoint Services) sales and marketing toolkit for SBS 2003 - here it was

    I've had someone ask me about the WSS toolkit that was referenced at How to Sell, Deploy, and Build Business with Microsoft Windows Sharepoint Services 3.0 and SBS 2003 R2 . The download location has moved to http://www.partnersalesresources.com/Pages/sbskit.aspx# . ttfn David Technorati Tags: Windows SharePoint Services , WSS v3 , SBS , SBS 2003 R2 , Microsoft , Partners

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

  • WSS v3 Search and Search Server - how to mix the two and fix the error "The search request was unable to connect to the Search Service"

    I got this e-mail the other day: Hi David,From your posting "How to install Microsoft Search Server 2008 Express - including how to install on Windows Home Server" it seems that you had some similar problems that I am experiencing regarding running wss3 and ssx on the same server. In my case it effectively broke the "search this site" option and I'm trying to find a solution to this do you by any chance now what is my problem? I keep getting the error message: The search request was unable to connect to the Search Service . Regards Peter After a bit of research the answer can be found at http://wss.asaris.de/sites/walsh/Lists/WSSv3%20FAQ/DispForm.aspx?ID=1256 . While I have not used this, the feedback from Peter was excellent "Thanks a bundle, This was the solution to my problem.", so I feel confident sharing it. ttfn David Technorati Tags: Search Server Express Edition 2008 , Search Server , Windows SharePoint Server , WSS , SSX

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

  • Fixing the last 2 problems with my Search Server Express - DCOM error 10016 (application settings do not grant Activation Permission form COM) and Gather warning 2436 for Search Services on my home server

    Obviously when I wrote the last blog entry on installing search server , not quite everything was working, although I did not realise it until a few errors appeared in the event log. The errors appear below - one is a DCOM permissions error and the other is a Gather error. The DCOM error Event Type: Error Event Source: DCOM Event Category: None Event ID: 10016 Date: 09/11/2007 Time: 06:35:26 User: NT AUTHORITY\NETWORK SERVICE Computer: HOMESERVER Description: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {61738644-F196-11D0-9953-00C04FD919C1} to the user NT AUTHORITY\NETWORK SERVICE SID (S-1-5-20). This security permission can be modified using the Component Services administrative tool. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Fixing the DCOM error is all about setting permissions in the DCOM system. The magical application was IIS WAMREG admin Service. I worked this out by...

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

  • How to give a user the ability to send mail 'on behalf of' a Public Folder

    I have been asked several times how someone can have an e-mail alias, such as "[email protected]" which not only receives into a public folder, but also has the ability to send e-mails. Obviously the setting up of the public folder, e-mail etc is well documented, but since I have been asked this again I thought I would share my source of knowledge - How to Give a User the Ability to Send Mail on Behalf of a Public Folder How to Give a User the Ability to Send Mail on Behalf of a Public Folder To give a user the ability to send mail on behalf of a public folder, perform the following procedure. In Exchange System Manager, under Folders , right-click the public folder for which you want to give a user the ability to send mail, and then click Properties . Click Exchange General , and then click Delivery Options . Click Add to specify a user. You may have to make additional modifications if the following conditions are true: The user's mailbox resides in a domain that is different from the public...

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

  • Exchange 2007 updates - Blogs for Exchange and Outlook, Virtual Machines, Webcasts, Service Pack 1 (SP1) and more

    This information is from the last 2 Technet Newsletters ( http://www.microsoft.com/technet ). Webcasts that have occurred in the past are available for download by clicking on the URLs. Blogs Exchange Team Blog http://msexchangeteam.com/default.aspx Outlook Team Blog http://blogs.msdn.com/outlook/default.aspx Awards Exchange Server wins CRN award The 2007 CRN Channel Champions Awards have been recently announced! http://msexchangeteam.com/archive/2007/05/11/438675.aspx Evaluation Quickly Evaluate Microsoft and Partner Solutions Through a Series of Pre-Configured Virtual Hard Disks Microsoft Exchange on virtual hard disk (VHD) lets you try out the key features of Exchange Server 2007. With the VHD Test Drive program, you can download VHDs and evaluate them for free in your own environment, without the need for dedicated servers or complex installations. http://www.microsoft.com/downloads/details.aspx?FamilyID=692a6e3c-81c9-4d8a-93fa-266d651735dc&DisplayLang=en Educating Information Workers About Exchange Server...

  • 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...
1 2 Next >

(c)David Overton 2006-23