<?xml version="1.0" encoding="utf-8"?>
<rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:pingback="http://madskills.com/public/xml/rss/module/pingback/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:dc="http://purl.org/dc/elements/1.1/" version="2.0">
  <channel>
    <title>Footprints in the snow of a warped mind - Software|Office</title>
    <link>http://blogs.thesitedoctor.co.uk/test/</link>
    <description>newtelligence powered</description>
    <language>en-us</language>
    <copyright>Tim</copyright>
    <lastBuildDate>Mon, 01 Dec 2008 13:53:59 GMT</lastBuildDate>
    <generator>newtelligence dasBlog 2.3.9074.18820</generator>
    <managingEditor>timgaunt@gmail.com</managingEditor>
    <webMaster>timgaunt@gmail.com</webMaster>
    <item>
      <trackback:ping>http://blogs.thesitedoctor.co.uk/test/Trackback.aspx?guid=bec53a39-db58-4562-91a7-b8add80d89e0</trackback:ping>
      <pingback:server>http://blogs.thesitedoctor.co.uk/test/pingback.aspx</pingback:server>
      <pingback:target>http://blogs.thesitedoctor.co.uk/test/PermaLink,guid,bec53a39-db58-4562-91a7-b8add80d89e0.aspx</pingback:target>
      <dc:creator>Tim</dc:creator>
      <wfw:comment>http://blogs.thesitedoctor.co.uk/test/CommentView,guid,bec53a39-db58-4562-91a7-b8add80d89e0.aspx</wfw:comment>
      <wfw:commentRss>http://blogs.thesitedoctor.co.uk/test/SyndicationService.asmx/GetEntryCommentsRss?guid=bec53a39-db58-4562-91a7-b8add80d89e0</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <p>
          <img height="204" src="http://blogs.sitedoc.co.uk/tim/img/MicrosoftOfficeAccountingProfessionalCrash.png" width="366" align="right" />We've
had an irritating issue recently with our accounting system, when creating the custom
invoices.
</p>
        <p>
Basically, every time we tried to create a custom invoice with Microsoft Office Accounting
the entire application would crash for no obvious reason.
</p>
        <p>
Checking the exception's stack trace it would talk about get_item which lead me down
one path but the answer was actually (and irritatingly) more simple than that -we
had a couple of merged cells in the footer of the totals table. Silly I know but it
made all the difference!
</p>
        <p>
So if you're getting a crash with Microsoft Office Accounting when creating your invoices,
check for merged cells first!
</p>
        <img width="0" height="0" src="http://blogs.thesitedoctor.co.uk/test/aggbug.ashx?id=bec53a39-db58-4562-91a7-b8add80d89e0" />
      </body>
      <title>Microsoft Office Accounting Professional crashes with custom invoice</title>
      <guid isPermaLink="false">http://blogs.thesitedoctor.co.uk/test/PermaLink,guid,bec53a39-db58-4562-91a7-b8add80d89e0.aspx</guid>
      <link>http://blogs.thesitedoctor.co.uk/test/2008/12/01/MicrosoftOfficeAccountingProfessionalCrashesWithCustomInvoice.aspx</link>
      <pubDate>Mon, 01 Dec 2008 13:53:59 GMT</pubDate>
      <description>&lt;p&gt;
&lt;img height="204" src="http://blogs.sitedoc.co.uk/tim/img/MicrosoftOfficeAccountingProfessionalCrash.png" width="366" align="right" /&gt;We've
had an irritating issue recently with our accounting system, when creating the custom
invoices.
&lt;/p&gt;
&lt;p&gt;
Basically, every time we tried to create a custom invoice with Microsoft Office Accounting
the entire application would crash for no obvious reason.
&lt;/p&gt;
&lt;p&gt;
Checking the exception's stack trace it would talk about get_item which lead me down
one path but the answer was actually (and irritatingly) more simple than that -we
had a couple of merged cells in the footer of the totals table. Silly I know but it
made all the difference!
&lt;/p&gt;
&lt;p&gt;
So if you're getting a crash with Microsoft Office Accounting when creating your invoices,
check for merged cells first!
&lt;/p&gt;
&lt;img width="0" height="0" src="http://blogs.thesitedoctor.co.uk/test/aggbug.ashx?id=bec53a39-db58-4562-91a7-b8add80d89e0" /&gt;</description>
      <comments>http://blogs.thesitedoctor.co.uk/test/CommentView,guid,bec53a39-db58-4562-91a7-b8add80d89e0.aspx</comments>
      <category>Business</category>
      <category>Software/Office</category>
      <category>The Site Doctor</category>
    </item>
    <item>
      <trackback:ping>http://blogs.thesitedoctor.co.uk/test/Trackback.aspx?guid=2520da02-1f11-4612-8e60-57859d902449</trackback:ping>
      <pingback:server>http://blogs.thesitedoctor.co.uk/test/pingback.aspx</pingback:server>
      <pingback:target>http://blogs.thesitedoctor.co.uk/test/PermaLink,guid,2520da02-1f11-4612-8e60-57859d902449.aspx</pingback:target>
      <dc:creator>Tim</dc:creator>
      <wfw:comment>http://blogs.thesitedoctor.co.uk/test/CommentView,guid,2520da02-1f11-4612-8e60-57859d902449.aspx</wfw:comment>
      <wfw:commentRss>http://blogs.thesitedoctor.co.uk/test/SyndicationService.asmx/GetEntryCommentsRss?guid=2520da02-1f11-4612-8e60-57859d902449</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <p>
I've had an irritating issue for the past week or so. I used to use POP3 in Outlook
however the other day I switched to the internal Exchange server and I got stuck in
an eternal loop saying that Exchange needed to connect to the server to synchronise
the offline files and folders -but you couldn't do that until the files were transferred.
</p>
        <p>
The message looked something like this:
</p>
        <blockquote>
          <p>
The set of folders cannot be opened. You must connect to Microsoft Exchange with the
current profile before you can synchronise your folders with your offline folder file.
</p>
        </blockquote>
        <p>
Took me a while but the fix was to remove the profile and setup the exchange inbox
first:
</p>
        <ol>
          <li>
Click <strong>Start</strong>, and then click <strong>Control Panel</strong>. 
</li>
          <li>
Click <strong>Switch to Classic View</strong>, and then double-click <strong>Mail</strong>. 
</li>
          <li>
In the <strong>Mail Setup</strong> dialog box, click <strong>Show Profiles</strong>. 
</li>
          <li>
On the <strong>General</strong> tab, click <strong>Prompt for a profile to be used</strong>,
and then click <strong>Add</strong>. 
</li>
          <li>
In the <strong>Profile Name</strong> box, type a descriptive name for the new e-mail
profile, and then click <strong>OK</strong>. 
</li>
          <li>
In the <strong>E-mail Accounts</strong> dialog box, click <strong>Add a new e-mail
account</strong>, and then click <strong>Next</strong>. 
</li>
          <li>
Click the appropriate server type for your new e-mail account, and then click <strong>Next</strong>. 
</li>
          <li>
Type your account information in the required boxes, and then click <strong>Next</strong>.</li>
          <li>
Click <strong>Finish</strong>, and then click <strong>OK</strong>.</li>
        </ol>
        <img width="0" height="0" src="http://blogs.thesitedoctor.co.uk/test/aggbug.ashx?id=2520da02-1f11-4612-8e60-57859d902449" />
      </body>
      <title>Can't launch Outlook when switching to Exchange from POP3</title>
      <guid isPermaLink="false">http://blogs.thesitedoctor.co.uk/test/PermaLink,guid,2520da02-1f11-4612-8e60-57859d902449.aspx</guid>
      <link>http://blogs.thesitedoctor.co.uk/test/2008/05/30/CantLaunchOutlookWhenSwitchingToExchangeFromPOP3.aspx</link>
      <pubDate>Fri, 30 May 2008 20:14:36 GMT</pubDate>
      <description>&lt;p&gt;
I've had an irritating issue for the past week or so. I used to use POP3 in Outlook
however the other day I switched to the internal Exchange server and I got stuck in
an eternal loop saying that Exchange needed to connect to the server to synchronise
the offline files and folders -but you couldn't do that until the files were transferred.
&lt;/p&gt;
&lt;p&gt;
The message looked something like this:
&lt;/p&gt;
&lt;blockquote&gt; 
&lt;p&gt;
The set of folders cannot be opened. You must connect to Microsoft Exchange with the
current profile before you can synchronise your folders with your offline folder file.
&lt;/p&gt;
&lt;/blockquote&gt; 
&lt;p&gt;
Took me a while but the fix was to remove the profile and setup the exchange inbox
first:
&lt;/p&gt;
&lt;ol&gt;
&lt;li&gt;
Click &lt;strong&gt;Start&lt;/strong&gt;, and then click &lt;strong&gt;Control Panel&lt;/strong&gt;. 
&lt;/li&gt;
&lt;li&gt;
Click &lt;strong&gt;Switch to Classic View&lt;/strong&gt;, and then double-click &lt;strong&gt;Mail&lt;/strong&gt;. 
&lt;/li&gt;
&lt;li&gt;
In the &lt;strong&gt;Mail Setup&lt;/strong&gt; dialog box, click &lt;strong&gt;Show Profiles&lt;/strong&gt;. 
&lt;/li&gt;
&lt;li&gt;
On the &lt;strong&gt;General&lt;/strong&gt; tab, click &lt;strong&gt;Prompt for a profile to be used&lt;/strong&gt;,
and then click &lt;strong&gt;Add&lt;/strong&gt;. 
&lt;/li&gt;
&lt;li&gt;
In the &lt;strong&gt;Profile Name&lt;/strong&gt; box, type a descriptive name for the new e-mail
profile, and then click &lt;strong&gt;OK&lt;/strong&gt;. 
&lt;/li&gt;
&lt;li&gt;
In the &lt;strong&gt;E-mail Accounts&lt;/strong&gt; dialog box, click &lt;strong&gt;Add a new e-mail
account&lt;/strong&gt;, and then click &lt;strong&gt;Next&lt;/strong&gt;. 
&lt;/li&gt;
&lt;li&gt;
Click the appropriate server type for your new e-mail account, and then click &lt;strong&gt;Next&lt;/strong&gt;. 
&lt;/li&gt;
&lt;li&gt;
Type your account information in the required boxes, and then click &lt;strong&gt;Next&lt;/strong&gt;.&lt;/li&gt;
&lt;li&gt;
Click &lt;strong&gt;Finish&lt;/strong&gt;, and then click &lt;strong&gt;OK&lt;/strong&gt;.&lt;/li&gt;
&lt;/ol&gt;
&lt;img width="0" height="0" src="http://blogs.thesitedoctor.co.uk/test/aggbug.ashx?id=2520da02-1f11-4612-8e60-57859d902449" /&gt;</description>
      <comments>http://blogs.thesitedoctor.co.uk/test/CommentView,guid,2520da02-1f11-4612-8e60-57859d902449.aspx</comments>
      <category>Software/Office</category>
      <category>The Site Doctor</category>
    </item>
    <item>
      <trackback:ping>http://blogs.thesitedoctor.co.uk/test/Trackback.aspx?guid=79f637e2-b7e7-4954-bebc-76ce633c4864</trackback:ping>
      <pingback:server>http://blogs.thesitedoctor.co.uk/test/pingback.aspx</pingback:server>
      <pingback:target>http://blogs.thesitedoctor.co.uk/test/PermaLink,guid,79f637e2-b7e7-4954-bebc-76ce633c4864.aspx</pingback:target>
      <dc:creator>Tim</dc:creator>
      <wfw:comment>http://blogs.thesitedoctor.co.uk/test/CommentView,guid,79f637e2-b7e7-4954-bebc-76ce633c4864.aspx</wfw:comment>
      <wfw:commentRss>http://blogs.thesitedoctor.co.uk/test/SyndicationService.asmx/GetEntryCommentsRss?guid=79f637e2-b7e7-4954-bebc-76ce633c4864</wfw:commentRss>
      <slash:comments>2</slash:comments>
      <title>Excel change case -sentance, proper, lower and upper</title>
      <guid isPermaLink="false">http://blogs.thesitedoctor.co.uk/test/PermaLink,guid,79f637e2-b7e7-4954-bebc-76ce633c4864.aspx</guid>
      <link>http://blogs.thesitedoctor.co.uk/test/2006/12/05/ExcelChangeCaseSentanceProperLowerAndUpper.aspx</link>
      <pubDate>Tue, 05 Dec 2006 14:38:04 GMT</pubDate>
      <description>&lt;p&gt;
Have you ever been sorting through a client&amp;rsquo;s product data and needed to change
the case of the text? This is a great little add-in for Excel that can help.&lt;br /&gt;
&lt;a href="content/binary/caseconvert.zip"&gt;Download the zip file&lt;/a&gt; and run the xla
file, you&amp;rsquo;ll then have a new option &amp;ldquo;Convert Text&amp;rdquo; under your &amp;ldquo;Tools&amp;rdquo;
menu:
&lt;/p&gt;
&lt;p&gt;
&lt;img src="img/Excel-Change-Case-Menu.png" alt="Excel change case &amp;quot;Convert Text&amp;quot; Tool Menu" width="175" height="304" /&gt;
&lt;/p&gt;
&lt;p&gt;
To use it, select the text you want to change and then choose &amp;ldquo;Convert Text&amp;rdquo;,
you can then choose from:
&lt;/p&gt;
&lt;ul type="disc"&gt;
&lt;li&gt;
lower case&lt;/li&gt;
&lt;li&gt;
UPPER CASE&lt;/li&gt;
&lt;li&gt;
Proper Case&lt;/li&gt;
&lt;li&gt;
Sentence case&lt;/li&gt;
&lt;/ul&gt;
&lt;p&gt;
It also has a number of other useful options like removing white space, adding characters
etc.
&lt;/p&gt;
&lt;p&gt;
&lt;img src="img/Excel-Change-Case-Dialog.png" alt="Excel Change Case Dialog Window" width="387" height="431" /&gt;
&lt;/p&gt;
&lt;p&gt;
&lt;a href="content/binary/caseconvert.zip"&gt;Download the Excel Change Case Add-in here&lt;/a&gt; 
&lt;/p&gt;
&lt;img width="0" height="0" src="http://blogs.thesitedoctor.co.uk/test/aggbug.ashx?id=79f637e2-b7e7-4954-bebc-76ce633c4864" /&gt;</description>
      <comments>http://blogs.thesitedoctor.co.uk/test/CommentView,guid,79f637e2-b7e7-4954-bebc-76ce633c4864.aspx</comments>
      <category>Software/Office</category>
    </item>
    <item>
      <trackback:ping>http://blogs.thesitedoctor.co.uk/test/Trackback.aspx?guid=9ade0737-59cb-4db6-98a9-e0c91b24a292</trackback:ping>
      <pingback:server>http://blogs.thesitedoctor.co.uk/test/pingback.aspx</pingback:server>
      <pingback:target>http://blogs.thesitedoctor.co.uk/test/PermaLink,guid,9ade0737-59cb-4db6-98a9-e0c91b24a292.aspx</pingback:target>
      <dc:creator>Tim</dc:creator>
      <wfw:comment>http://blogs.thesitedoctor.co.uk/test/CommentView,guid,9ade0737-59cb-4db6-98a9-e0c91b24a292.aspx</wfw:comment>
      <wfw:commentRss>http://blogs.thesitedoctor.co.uk/test/SyndicationService.asmx/GetEntryCommentsRss?guid=9ade0737-59cb-4db6-98a9-e0c91b24a292</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <p>
This is still unconfirmed and somewhat word-of-mouth etc atm but if you check out
Ian Moulster's blog you'll see his post about Microsoft giving away <a href="http://blogs.msdn.com/ianm/archive/2006/11/03/free-copies-of-the-released-versions-of-windows-vista-and-microsoft-office-2007-if-you-re-in-the-uk-plus-some-other-caveats.aspx">free
copies of the release version of Vista and Office 2007</a> check out his blog post
to find out more.
</p>
        <p>
Hopefully we'll hear more before <a href="http://www.developerday.co.uk/">DDD Day</a></p>
        <img width="0" height="0" src="http://blogs.thesitedoctor.co.uk/test/aggbug.ashx?id=9ade0737-59cb-4db6-98a9-e0c91b24a292" />
      </body>
      <title>Free copies of the released versions of Windows Vista and Microsoft Office 2007</title>
      <guid isPermaLink="false">http://blogs.thesitedoctor.co.uk/test/PermaLink,guid,9ade0737-59cb-4db6-98a9-e0c91b24a292.aspx</guid>
      <link>http://blogs.thesitedoctor.co.uk/test/2006/11/04/FreeCopiesOfTheReleasedVersionsOfWindowsVistaAndMicrosoftOffice2007.aspx</link>
      <pubDate>Sat, 04 Nov 2006 22:58:14 GMT</pubDate>
      <description>&lt;p&gt;
This is still unconfirmed and somewhat word-of-mouth etc atm but if you check out
Ian Moulster's blog you'll see his post about Microsoft giving away &lt;a href="http://blogs.msdn.com/ianm/archive/2006/11/03/free-copies-of-the-released-versions-of-windows-vista-and-microsoft-office-2007-if-you-re-in-the-uk-plus-some-other-caveats.aspx"&gt;free
copies of the release version of Vista and Office 2007&lt;/a&gt; check out his blog post
to find out more.
&lt;/p&gt;
&lt;p&gt;
Hopefully we'll hear more before &lt;a href="http://www.developerday.co.uk/"&gt;DDD Day&lt;/a&gt;
&lt;/p&gt;
&lt;img width="0" height="0" src="http://blogs.thesitedoctor.co.uk/test/aggbug.ashx?id=9ade0737-59cb-4db6-98a9-e0c91b24a292" /&gt;</description>
      <comments>http://blogs.thesitedoctor.co.uk/test/CommentView,guid,9ade0737-59cb-4db6-98a9-e0c91b24a292.aspx</comments>
      <category>Software/Office</category>
      <category>Software/Windows</category>
    </item>
    <item>
      <trackback:ping>http://blogs.thesitedoctor.co.uk/test/Trackback.aspx?guid=57541e0c-f290-4087-a39c-51ab1859d2b1</trackback:ping>
      <pingback:server>http://blogs.thesitedoctor.co.uk/test/pingback.aspx</pingback:server>
      <pingback:target>http://blogs.thesitedoctor.co.uk/test/PermaLink,guid,57541e0c-f290-4087-a39c-51ab1859d2b1.aspx</pingback:target>
      <dc:creator>Tim</dc:creator>
      <wfw:comment>http://blogs.thesitedoctor.co.uk/test/CommentView,guid,57541e0c-f290-4087-a39c-51ab1859d2b1.aspx</wfw:comment>
      <wfw:commentRss>http://blogs.thesitedoctor.co.uk/test/SyndicationService.asmx/GetEntryCommentsRss?guid=57541e0c-f290-4087-a39c-51ab1859d2b1</wfw:commentRss>
      <body xmlns="http://www.w3.org/1999/xhtml">
        <style type="text/css">
          <!--
.style1 {color: #0000FF}
.style2 {color: #666666}
.style6 {color: #FF9900; font-weight: bold; }
-->
        </style>
        <p>
I know this is covered all over the web but I'm forever forgetting it so if Outlook
has started blocking email attachments i.e. ASP files you can easily adjust this by
adding a String Key called "Level1Remove" to the registry, navigate to: <span class="style2">Current
User --&gt; Software --&gt; Microsoft --&gt; Office (x) --&gt; Outlook --&gt; Security</span> (where
(x) is the version of office you are running: 9 = Outlook 2000, 10 = Outlook 2002
11 = Outlook 2003
</p>
        <p>
Then right click and choose "<span class="style6">New</span>" and "<span class="style6">String
Key</span>", then add in a list of the attachments you would like to allow seperated
by semi-colons i.e.:<br /><span class="style1">.exe;.mdb;.url;.asp;.aspx;.zip</span></p>
        <img width="0" height="0" src="http://blogs.thesitedoctor.co.uk/test/aggbug.ashx?id=57541e0c-f290-4087-a39c-51ab1859d2b1" />
      </body>
      <title>Stopping Outlook Blocking Attachments</title>
      <guid isPermaLink="false">http://blogs.thesitedoctor.co.uk/test/PermaLink,guid,57541e0c-f290-4087-a39c-51ab1859d2b1.aspx</guid>
      <link>http://blogs.thesitedoctor.co.uk/test/2006/07/04/StoppingOutlookBlockingAttachments.aspx</link>
      <pubDate>Tue, 04 Jul 2006 10:46:14 GMT</pubDate>
      <description>
&lt;style type=text/css&gt;
&lt;!--
.style1 {color: #0000FF}
.style2 {color: #666666}
.style6 {color: #FF9900; font-weight: bold; }
--&gt;
&lt;/style&gt;
&lt;p&gt;
I know this is covered all over the web but I'm forever forgetting it so if Outlook
has started blocking email attachments i.e. ASP files you can easily adjust this by
adding a String Key called "Level1Remove" to the registry, navigate to: &lt;span class=style2&gt;Current
User --&amp;gt; Software --&amp;gt; Microsoft --&amp;gt; Office (x) --&amp;gt; Outlook --&amp;gt; Security&lt;/span&gt; (where
(x) is the version of office you are running: 9 = Outlook 2000, 10 = Outlook 2002
11 = Outlook 2003
&lt;/p&gt;
&lt;p&gt;
Then right click and choose "&lt;span class=style6&gt;New&lt;/span&gt;" and "&lt;span class=style6&gt;String
Key&lt;/span&gt;", then add in a list of the attachments you would like to allow seperated
by semi-colons i.e.:&lt;br /&gt;
&lt;span class=style1&gt;.exe;.mdb;.url;.asp;.aspx;.zip&lt;/span&gt;
&lt;/p&gt;
&lt;img width="0" height="0" src="http://blogs.thesitedoctor.co.uk/test/aggbug.ashx?id=57541e0c-f290-4087-a39c-51ab1859d2b1" /&gt;</description>
      <comments>http://blogs.thesitedoctor.co.uk/test/CommentView,guid,57541e0c-f290-4087-a39c-51ab1859d2b1.aspx</comments>
      <category>Software/Office</category>
    </item>
  </channel>
</rss>