Posts Tagged ‘Tips’

Excel 2007: Automatic Formula Recalculation

November 9th, 2009 No comments

Are your Excel formulas not recalculating automatically?

Check: Formulas tab> Calculation options> Automatic


Categories: Tips Tags: , ,

Symantec AntiVirus Corporate: 64 bit PCs not updating

November 6th, 2009 No comments

If you’re running Symantec Antivirus Corporate Edition on your network and you have some 64 bit machines on your network, you may find that the 64 bit machines aren’t updating their virus definitions. This is because the 64 bit machines cannot update from a 32 bit server. The way round this is to set the 64 bit machines to update from the Internet instead of from your server. To do this you need to create a client group with the just the 64 bit machines in, like so:

  1. Create a client group.
  2. Drag the 64 bit machines into the new client group.
  3. Right-click the client group.
  4. Uncheck Inherit settings from Server Group.
  5. Right-click the client group, and then select All Tasks > Symantec AntiVirus > Virus Definition Manager.
  6. In the Virus Definition Manager dialog box, uncheck Update virus definitions from parent server.
  7. Check Schedule client for automatic updates using LiveUpdate, click Schedule, specify a schedule, and then click OK.
  8. Click OK.


Categories: Tips Tags: , ,

Remove Outlook attachments

November 2nd, 2009 No comments

I just found this out myself the other day, you can remove attachments from emails in Outlook. Handy for reducing your Exchange mailbox size.

Just open the email (can’t be done from preview), right click the attachment and select Remove. Close and save the email when prompted.

Categories: Tips Tags: ,

Exchange 2003: .edb and .stm?

October 30th, 2009 No comments

Want to know what the difference is between your exchange .edb and .stm files?

.edb: A rich-text database file containing message headers, message text, and standard attachments.

.stm: A streaming internet content file containing audio, video and other media that are formatted as streams of Multipurpose Internet Mail Extensions (MIME) data.

So now you know.

Categories: Tips Tags: , , ,

Internet Explorer 8: Open as web folder

October 28th, 2009 2 comments

Tried to do Open as web folder in Internet Explorer 8? You’ll have noticed the option isn’t there any more. It’s been removed. Apparently this is because they have done some work to separate  Internet Explorer from the Windows Shell.

There’s a way round this though. You can map a internet folder as a network drive. Just click map a network drive  like so:

Map network drive

Then, click ‘Connect to a Web site that you can use to store your documents and Pictures’ at the bottom.

Map network drive

Follow the wizard that pops up and you’re done.


Exchange 2003: Switch off NDR

October 20th, 2009 No comments

Want to turn off Non-Delivery Reports (NDR) in Exchange 2o03? You can find the setting in the following location:

Exchange System Manager> Global Settings> Internet Message Format. Double click on ‘Default’ (or whatever you have listed there)> Advanced tab> Uncheck ‘Allow non-delivery reports’.


Categories: Tips Tags: , ,

Outlook 2003 Hyperlinks not working

October 19th, 2009 No comments

Do you get the following error message when clicking on a hyper link in Outlook 2003?

This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.

This is usually very easily fixed. Go to Control Panel> Internet Options> Programs> Reset Web Settings.

That should fix it!

Categories: Tips Tags: ,

SPF Record: ISP SMTP Server

October 15th, 2009 No comments

Spam. It’s the bane of the Internet. Most of us get it. At work we get tons. Most (like about 90-95%) of the email we receive is spam. Some of it was getting through the filters too, which is even more annoying. For this reason, I’ve be doing quite a bit fine tuning of our spam filtering software, GFI MailEssentials. DNS blacklists have turned out to be the most effective, most of our spam doesn’t even get as far as the Junk box now.

Another thing I looked into was SPF records. I posted about SPF records a while back, but I thought I’d post again to give a few tips on the problems I encountered.

If you use a smarthost with your Exchange server then the server that is actually sending the emails is that of your ISP. This means that you have to put the address of your ISP’s server in your SPF record. No big deal right? Wrong.

You can enter the domain name of the ISP’s server, but if they don’t have an SPF record (which they probably wont), then yours will fail too.

It’s easy enough to find out the IP address of you ISP’s mail server (although they probably have more than one), but, and it’s a very big but, what if they change the IP address of their server without telling you? All of a sudden all your emails out would start SPF failing and possibly being marked as spam!

There is a way round it however. Using reverse DNS lookup. As long as the reverse DNS of your ISP’s mail server is set up correctly (if it isn’t, ask them to fix it) then you can enter this into your SPF. Just put this in your SPF record:


Categories: Tips Tags: , ,

Robots.txt: Allow Directive

October 7th, 2009 No comments

Just a quick tip for writing a robots.txt file for your website, especially if you’re using the Google Webmaster Tools website to help you; the allow: /directory-name/ directive is not part of the standard protocol.

It’s definitely supported by Google but I’m not sure about other search engines.

Categories: Tips Tags: ,

Printscreen/Screenshot software

October 5th, 2009 No comments

Ever needed to do a lot of screenshots? Creating a manual for example. You need to take loads of screenshots and then go back and forth to the manual pasting them. So time consuming! Well there is another way.

Using Print Screen 3.0 you can have all of your screenshots automatically saved to a folder ready to be inserted to your document at a later time. Perfect!