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

  • Diagnosing connectivity problems to Exchange and Office 365

    I was asked today about an Outlook synchronisation of the address book over the web (RPC over http) and did some digging and found this excellent diagnosis tool - https://www.testexchangeconnectivity.com .  The nice thing is that it tests many products – Exchange, ActiveSync and Office 365 . Once you start the tool you have to choose what diagnosis you want: or After you have completed your sign-in details, you get the results.  In the example below it shows that my certificate is not publically signed and a number of other issues that I could address if they were the cause of connectivity issues (but I don’t need to as I get the functionality I want with the current setup)   ttfn David
  • Outlook Anywhere (RPC over HTTP) not working or slow with SBS 2008

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

    So there I was talking about migration issues and Chris Pucket pointed to this GREAT store of error messages and resolutions for SBS installs.  I've copied the links for now, but expect them to be updated over time!! Still let me know Migration issues on the link above! Catalog of Windows Small Business Server 2008 Installation Error Messages This topic links to information about errors that you might encounter while installing Windows SBS 2008. If you encounter an error that does not appear on this page, see “Troubleshooting Windows Small Business Server 2008” in the Windows Small Business Server Technical Library (http://go.microsoft.com/fwlink/?LinkId=111318). Click a link to view information about that error message. An error occurred while installing or configuring a Windows SBS 2008 application An error occurred while promoting the server to a domain controller Anti-spam agents for Exchange Server 2007 cannot be installed Anti-spam automatic updates for Exchange Server 2007 cannot be configured...
  • 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
  • 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...
  • 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...
  • 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...
  • Finding out where something is in Office 2007 and where it was in Office 2003 (Outlook, Word, Excel, PowerPoint and Access)

    I saw this recently and thought I had to blog it - if you know something was there in Office 2003 and now can't find it in Office 2007 then look at these spreadsheets to get some advice. The 1st set of links (ms-help:) will work on a machine with Office 2007 installed and the 2nd set pull the data from the Microsoft Office web site. From the installed help files Outlook ms-help://MS.RIBBON.12.1033/RIBBON/outlookmap.xls Word ms-help://MS.RIBBON.12.1033/RIBBON/wordmap.xls Excel ms-help://MS.RIBBON.12.1033/RIBBON/excelmap.xls PowerPoint ms-help://MS.RIBBON.12.1033/RIBBON/powerpointmap.xls Access ms-help://MS.RIBBON.12.1033/RIBBON/accessmap.xls From the Internet Outlook http://office.microsoft.com/search/redir.aspx?AssetID=AM101954661033&CTT=5&Origin=HA101934281033 Word http://office.microsoft.com/search/redir.aspx?AssetID=AM101938681033&CTT=5&Origin=HA100625841033 Excel http://office.microsoft.com/search/redir.aspx?AssetID=AM101864291033&CTT=5&Origin=HA100860481033 PowerPoint http://office...
  • 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
  • Business Contact Manager 2007 (BCM) is NOT supported on Windows Terminal Server, but a little hack will make it work

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

    I saw a blog entry at Susan Bradley's blog about her now deploying Office 2007 with a classic menu . It was worth of a blog link for all those who want to stick to the old, old ways where you search for items over multiple menus (especially if you turn on personalised menus which hide all the things you don't use regularly). The tool looks slick, but then I found a 2nd one are realised that some cunning ISVs had seen this as their great opportunity to fill a gap that is very unlikely to be filled by Microsoft. The Two solutions are shown below and can be linked to from pschmid.net - RibbonCustomizer™ Feature Tour - Part 3: Classic UI Tabs and Show Classic Menus and Toolbars on Ribbon of Office 2007 : V1.1 Feature Tour - Part 3: Classic UI Tabs RibbonCustomizer™ V1.1 ships with a set of Classic UI tabs for Excel, PowerPoint and Word 2007. Those tabs emulate the Office 2003 menus and toolbars in Office 2007. We provide these tabs to help you familiarize yourself faster with the new Ribbon User Interface...
  • 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 use Office Outlook 2007 with any internet connection and how to access Outlook Web Access from any web browser - 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 Outlook via a web browser and via an internet connection: Outlook Web Access with recent browser (IE5 or above) Outlook Web Access basic or lite edition for low speed internet connections Configure Outlook to use RPC over HTTP To see the video played using Silverlight (just try it) click here *. I am hoping that in the near future that the WMV file will be available at new bCentral - the UK Small Business Center on MS.com. At the moment it is not available there, but a copy can be found here * it will take a few moments to open if you have Silverlight installed and require you to download Silverlight if you don't, but it is a 1MB download How I made it I simply ran through part of my normal demo talking...
  • How to customize Business Contact Manager 2007 forms in Outlook 2007

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

    Don't you love the way the title of a product described what it is? While this product does what it says on the tin, it misses out the most important thing - what can you connect Outlook to. The answer is e-mail and contacts based on our Hotmail service, so this includes OfficeLive. If you sign up to one of the subscription OfficeLive services (i.e. you pay us to use it) then you get a connector which can do all this AND synchronise your calendar items too. Once in Outlook you can do all the searching, filing and manipulation you want to do. Today you can now download the beta of the next version of the Microsoft Office Outlook Connector. Download: Microsoft Office Outlook Connector (Beta) The Microsoft Office Outlook Connector is designed to let you access your Windows Live Hotmail account through Outlook 2003 or Outlook 2007. You will be able to download and install the Connector to sync up your email and contacts in Windows Live Hotmail for free. However, if you are a paid subscriber of MSN Premium, Office...
  • May security updates for Server DNS and Office 2003/2007 and IE7. Also Quicktime needs an update

    I did a quick scan and it seems that this month Office is the main target of updates, along with one critical one for Windows Server (for DNS RPC attack) and one for IE7. Worth a quick download and install :-) I also got this in the mail today: Apple QuickTime 7.x must be upgraded to 7.1.5 or higher. On the security updates: Microsoft is releasing the following new security bulletins for newly discovered vulnerabilities: Bulletin Number Maximum Severity Affected Products Impact MS07-023 Critical Microsoft Excel (all currently supported versions) Remote Code Execution MS07-024 Critical Microsoft Word 2000, 2002, 2003, 2004 (Mac) Remote Code Execution MS07-025 Critical Microsoft Office (all currently supported versions) Remote Code Execution MS07-026 Critical Microsoft Exchange (all current versions) Remote Code Execution MS07-027 Critical Internet Explorer - all current versions on all currently supported versions of Microsoft Windows Remote Code Execution MS07-028 Critical CAPICOM, BizTalk Server Remote Code Execution...
  • What is the difference between an Outlook contact and a Business Contact Manager (BCM in Office 2007) contact

    I was asked this by someone today and thought I would show you the differences BCM Contact General Page followed by the Outlook Contact General Page: There are lots of differences, but the big ones are: Information Source - where did it come from, how did you get this contact and which account started it. Classification - Is this a lead and is the person still "active". Also who is managing this person, what their credit rating is and whether there is a payment issue BCM Details Page followed by the Outlook Details Page: A host of job related information and then a section for personal information about the person, plus a huge comments section. There is also the communication preferences piece and the ability to suppress mailings (do not call, do not e-mail, do not fax, do not mail (write to on paper)). Finally the BCM (only) History Page: Some of this information can be automatically generated, so for example, the e-mail items can be auto generated whenever you mail, or they mail you. ttfn David Technorati...
  • 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...
  • New downloads for Business Contact Manager for Office 2007 (and 2003) to provide Pocket PC / Windows Mobile 5 & 6 support, Admin a database on a SBS box, setup a database on a SBS box and offer Office Live Maps for contacts

    I have just got my new mobile phone and I thought I would update the BCM client - a quick trip to http://download.microsoft.com (link takes you to these results) led me to these results below. I think the ones shown are key for many people. Results for - "business contact manager" Title Release Date Popularity Outlook 2007 with Business Contact Manager: Prevent error message about version mismatch when certain Office 2007 applications are launched Prevents error message about version mismatch when you start certain Office 2007 applications on a computer that is running Microsoft Office Outlook 2007 with Business Contact Manager 5/1/2007 #963 Outlook 2007 or 2003 with Business Contact Manager Add-in: Business Contacts for Pocket PC This release is an add-in that allows you to synchronize your business contacts and a subset of your communication history to your Microsoft Windows Mobile 5.0 Pocket PC. 4/25/2007 #536 Business Contact Manager Database Admin Tool Users of Business Contact Manager for Outlook...
  • Setting up Yahoo Mail Plus (the paid for service) for Pop3 download into Outlook 2007

    I have had someone ask me about POP3 mail and Outlook 2007 wiht Yahoo mail, so here is a walk through. Go to the tools menu and select Account Settings. press New selected the top option filled in my details and clicked next let it finish processing job done Going back to Account settings screen I see that the settings are not quite the same as the details at http://help.yahoo.com/l/us/yahoo/mail/original/mailplus/pop/pop-36.html Clicking More Settings the last tab needed some changing from the screen on the left to the screen on the right that is it - SSL based login and e-mail working ttfn David Technorati tags: yahoo mail , Outlook 2007
  • What does it take to run Office 2007 on a PC (Windows XP and Vista)

    I saw this on Darrens blog ( Office Rocker! : Is your PC beefy enough for Office 2007? ) and decided that I would add to it. One point Darren makes very clear is that Office 2007 will run on Windows XP SP2 or Window Vista (you do not need to have Vista - just as Office 2003 will run on Windows Vista too). The Office 2007 spec is one of the more comprehensive that I have seen, which is good - just like Vista it scales according to the capabilities of the PC it is running on. You will note that to get grammar checking, contextual spell check and search you would need a 1GB machine, whihc is the minimum recommended spec for a Vista Business machine. If you are a power user, go for more memory. I run a 1GB machine at the moment, but when I have 10 windows open it can get sluggish swapping between the applications. Anyway, this is what Darren said: The hardware spec on our website says a few other interesting things, in small print at the end of this list has some of the exceptions: 2 gigahertz (GHz) processor or higher...
  • Job aids (things to help you do your job) with Microsoft Office 2007

    2007 Microsoft Office System Be productive while using the new versions of Microsoft Office desktop applications. · Microsoft Office Fluent User Interface Get Started · Microsoft Office Charts and SmartArt Get Started · Microsoft Office Styles Get Started · Microsoft Office Tasks Get Started · Microsoft Office Tasks Learn More Everyday Work Discover best practices for working with e-mail, organizing your time, and more. · Windows Vista and Microsoft Office Work Smarter Checklist · InfoPath 2007 Forms Get Started E-mail · E-Mail Basics Get Started · Outlook 2007 E-Mail Signatures Get Started · Outlook 2007 E-Mail Rules Get Started · Outlook 2007 Out of Office Assistant · Delegating Outlook 2007 Access Learn More · Outlook 2007 and SharePoint Server 2007 Integration Overview · Outlook 2007 and SharePoint Server 2007 Integration Get Started · RSS (Really Simple Syndication) Overview · Subscribing to Web Content with RSS Time and Task Management · Microsoft Office Tasks Get Started · Microsoft Office Tasks Learn More...
  • How to add external contacts to the GAL (global address list or the list of names found by default in Outlook) by adding them to Active Directory

    So you may remember the call for help that led to the article How to add public folders to the list of contacts in Outlook : We currently have several public folders which contain email address and contact information for people outside of our company that we want to keep up with. I would like to put these in the All Contacts list on the server, so everyone can open it and reference it when sending email. The only thing I can find it to put them in Active Directory so they can be on the list. Surely there is another way to get this done, but how. I also am not opposed to manually typing them in (and weeding out old contacts), but don't feel very comfortable putting 800 outsiders in my AD. Having proposed the solution in the above link, I then got back the following reply: Thanks David for the reply. I have some address books in the public folder that I have done that to, but was trying to move away from the public folder and have the addresses included in the "All Contacts" under the "All Addresses" section for...
  • How to add Public Folder Contacts to the list of Address Books in Outlook so anyone can send e-mail to a shared contact

    I was recently asked by someone how to do this. Considering the fact that there are pre-defined public folders in SBS, including those for contacts I thought it was worth sharing this with a wider audience. Set this up for a customer using SBS and they can easily share contacts across the whole business. Add the contacts folder to the favourties list and they are also cached offline :-) I found the answer by experimentation, but then this article describes it well too. The magic tab in Office 2007 (and 2003) is pictured below from my system. How to add Public Folder Contacts to the list of Address Books First thing you need to make sure that the public folders has a contact list created. Also, double check the permissions so that your users can view the contact list. To setup the Contact List in the Address Book navigate to your public folder and find the contact list you want to add. Right-click on the Contacts Folder and click properties . Click on the Outlook Address Book tab. Check the box next to “Show...

(c)David Overton 2006-17