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

Office System - David Overton's Blog

  • Office 2007 training for Word, Excel, PowerPoint, Outlook, Office, Access

    This is the download your own stuff: http://office.microsoft.com/en-us/templates/CT102036981033.aspx - currently 18 slide decks here Training presentation: Outlook 2007—Create great-looking signatures for your e-mail Rating: (16 votes) Training presentation: Microsoft Office—Get up to speed with the 2007 system Rating: (85 votes) Training presentation: PowerPoint 2007—Get up to speed Rating: (101 votes) Training presentation: Outlook 2007—Get out of your Inbox Rating: (21 votes) Training presentation: Microsoft Office—Keyboard shortcuts in the 2007 system Rating: (6 votes) Training presentation: PowerPoint 2007—Create your first presentation Rating: (81 votes) Training presentation: Access 2007—Get up to speed Rating: (17 votes) Training presentation: Word 2007—Get up to speed Rating: (55 votes) Training presentation: PowerPoint 2007—Get visual with SmartArt graphics New! Rating: (7 votes) Training presentation: Outlook 2007—Calendar basics Rating: (49 votes) Training presentation: Excel 2007—Create a chart Rating...
  • I'm sorry - I am not perfect and nor is Microsoft. Sometimes it is our fault

    I can be abrasive sometimes and whether it "is my fault" or not, I don't always understand others' point of views. To this I would like to say "It is my fault". Now, if you have got up off the floor, let me give you a few examples. I say "contact our customer support" and you say "I don't have time". Before I rant - OK, I understand this, if you could share the bug at some time, we will try to fix it. We haven't been able to identify it yet, so need your help I say "There is no OEM media, get over it" and you say "I need OEM media to do my installs". OK, I can't fix this one. I do understand where you are coming from. If I were to share the fact that in the UK, which is a low piracy country, our tests so far have shown between 10-15% of all copies of Windows are pirated and many come from Action Packs and other OEM keys, does that help understand why this is such an issue? I do wish I could give you back OEM media, but I've been told it is just not possible. While Microsoft did publish the changes coming, I now...
  • Jeff Raikes (Important Exec at Microsoft) talkes about lots of things, including how Office might go in a SaaS / SwS world

    This is funny, I was discussing Software as a Service (SaaS) / Software with Service (SwS) with a few people the other day. I said that I thought Exchange and Outlook were the best examples of Software WITH Service and why SWS is better than SAAS. Lets run through a scenario, it’s OK, not brilliant, but highlights the point. Client Server – a bit like Outlook with a POP3 account and no offline functionality. Service only – Exchange without any client except Outlook Web Access – full web based access – the 07 version is great, but no offline capability and limited by what a browser can do. Software WITH Service – Outlook connected to Exchange 07 – can use on the web (OWA) can use disconnected – Outlook in Cached mode. You get the best when the two are connected and working together. To me, this is the ideal of the future – I get what I want when I want it – like now, on a train, writing this blog – I hit send, when I sync up, it will appear on my blog. Magic and the 3 hours on the train are useful catch-up time...
  • Nick talks sage into posting a fix for Sage Line 50 and Office 2007

    I was browsing Nick Whittome’s blog when I came across this : Sage Line 50 Version 12 - A fix for the ACCREP32.DLL error I would like to publicly thank Sage – specifically Lydia Coakley in Sage Ireland – for listening to my whining and helping me work directly with the Line 50 Development team on getting a fix . Please note that this fix is unsupported at this time, but should be in an update to the version 12 patches soon. In the mean time, this will get your Sage Line 50 version 12 working correctly with Outlook 2007. Good to see them moving on this. Ttfn David Published with BlogMailr
  • Win an XBOX 360 or 5 x Office and Vista while getting Microsoft to pay some or all of your Marketing Campaign Builder Expenses for Small Business PC, Branch Office solutions or Build Customer Connections Campaigns. Time limited - ends 30th April 2007

    Hopefully I have your attention, which is good. Microsoft UK are trying to encourage the use of our marketing tools and also gain some feedback. First of all, the prizes for the best feedback - an Xbox 360 system OR 5 x Vista Ultimate AND 5 x Office 2007 Pro. Next, the cash - we can offer a limited number of people £150 towards a marketing campaign - if that covers the whole of the campaign, then so be it and it has cost you nothing! This money is to be used at the UK Partner Campaign Builder portal. OK, so now for the pitch! As many of you know we like to help our partners in many ways here at Microsoft and one area that small business partners have asked for help is in the marketing area. Campaign Builder is a one stop shop to either produce materials and run the campaign yourself, or use the agency to run the campaign for you (or at least print the materials). Well, we have a limited number of discount vouchers to make this a £150 easier process. The idea is simple to do, simply do the following this April...
  • 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...
  • 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
  • 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...
  • 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...
  • 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
  • Are you an IT related architect (Office Business Application, Windows Server Security or Services Revolution aka SaaS) - if so then one of these events could be for you

    I've hung up my architecting gloves, but I still get the e-mails. I saw this and thought there were a few partners out there who would want to take advantage of the events. As a practising or aspiring architect, it's vital to keep up to date with the latest news and technological developments to make sure your work remains at the cutting edge. By attending a free Microsoft Architect Forum you'll learn how to get the most from your architecture and gain information to aid your architectural decisions. The Architect Forum series gives you free access to one-day events providing an expert overview of a specific topic as well as fantastic networking opportunities. To register for one of these events, follow the relevant link below: Office Business Applications Architect Forum - 13 September 2007, London Office Business Applications are an emerging class of application that helps businesses unlock the value of their line-of-business (LOB) systems and turn document-based processes into real applications...
  • VoIP and Unified Communications may be the future, but it has plenty of pitfalls for networks, phone systems and vendors alike

    In many ways I am a traditionalist. I wasn't the 1st to embrace the UC/VoIP and I have to admit that my personal commercial foray into this has so far left me turning off this technology as the sound quality was not there. Apparently my 20mb/768kb line is not good enough with my website on the same line :-( So that is me, but what about others. Information Week showed that network congestion is a growing problem - most of us don't carefully budget network traffic and while we are aware of "slow" internet connections etc, the impact on internal and external network connection is sometime something left to experimentation rather than science. A survey of 576 unified communications users found that 75% said one-quarter of their network traffic in the last three months consisted of UC applications like VoIP, unified messaging, and instant messaging. The survey was conducted by Network General Corp., which polled its worldwide customers. "The ramp-up in unified communications is already taking...
  • 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 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...
  • 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...
  • 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
  • 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
  • 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...
  • 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...
  • 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...
  • 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
  • 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...
  • 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
  • David Overton's technical presentations now in the "My Files" section

    So the Harry B event for me was another great time to chat to people and update everyone on the direction Microsoft was headed. The core elements for me were: 1) Microsoft understands that you have a growing and capable business model today 2) We believe that using our new technologies over the next 18 months there is even more opportunities for partners and customers alike 3) We also believe that making use of the technologies already deployed in customers is a great way to expand your business. This includes Windows Sharepoint Services and the 30 templates available for these – I will post more on these on Monday – MS CRM, Office on the desktop and so on 4) You need to understand our roadmap to choose when to jump on and why The technologies covered in the presentations were: SBS 2003 R2 MS CRM V3 Windows Vista Microsoft Office Small Business Edition 2003 Microsoft Small Business Accounting SBS Longhorn – note this is x64 only, but many servers are already running x64 chips, even though they are running 32-bit...
  • Want to know a litttle bit about our other products - watch it here

    The team I am part of is a fun little group and we made a roup of videos which discuss our technology. Each video is just a few minutes long, but might give you the overview you need before or after the meetings. The videos we have are: http://www.microsoft.com/uk/partner/blog/demo01-gettingemailanywhere.wvx http://www.microsoft.com/uk/partner/blog/demo03-realtimecommunications.wvx http://www.microsoft.com/uk/partner/blog/demo04-datavisualisation.wvx http://www.microsoft.com/uk/partner/blog/demo05-portals.wvx http://www.microsoft.com/uk/partner/blog/demo06-electronicforms.wvx http://www.microsoft.com/uk/partner/blog/demo08a-businesssolutions.wvx http://www.microsoft.com/uk/partner/blog/demo08b-businesssolutions.wvx http://www.microsoft.com/uk/partner/blog/demo08c-businesssolutions.wvx http://www.microsoft.com/uk/partner/blog/demo11-crm.wvx http://www.microsoft.com/uk/partner/blog/demo13-enterpriseprojectmanagement.wvx I am sure you can figure out which is which. ttfn David
« First ... < Previous 4 5 6 7 8 Next > ... Last »

(c)David Overton 2006-23