Recent content by SteveFairclough

Hi thanks for replying. I've tried that but it doesn't work. For example, if my domain name is xyz.com then I put that in the rule but no joy. I've also tried using the X400 or X500 addresses but I'm not entirely sure of the correct notation or syntax for this in a rule. Any more ideas ...

Hi does anybody know how to color code emails in Outlook 2003 / 2007 that are only from internal addresses or servers, ie the Global Address List ? I know you can apply automatic formatting based on the sender's address but I'm trying to do this based on the fact they are in the GAL. Any...

Hi, is it possible to migrate mailboxes from a 5.5 server to a 2003 server without having to re-create ost files for remote mobile users. We have many laptop users who use Outlook 2000 and 2002 in offline mode and I am trying to avoid having to recreate the offline ost files. Can anybody...

There's quite a bit of code, a bit too much to paste into hear. However, I think I'll comment out most of it and re-introduce the code bit by bit and hopefully identify the offending code by a process of elimination. I'll let you know how it goes.. Steve Fairclough I.T. Manager

Sam How would I know this ? I've now tried putting in a 20 second delay before the Application.Quit command to allow for any backgound stuff that may be going on. Still doesn't work though. Steve Fairclough I.T. Manager

The only problem with that is the Application.Quit line will not then execute as the macro will be closed down with the workbook. However, your suggestion did prompt me to change my method slightly by saving the workbook first using ActiveWorkbook.Save and then quitting but it still does not...

I have a simple macro that automatically starts when the spreadsheet is opened. I am desperately trying to get the macro to automatically close excel at the end. However, Excel will only quit when I'm stepping though the code to debug it, if I run the code normally then all the other code...

Thanks Paul, I would do that if I knew how to !! Any ideas how to make the printer use the same NE port number on all three machines ? Steve Fairclough I.T. Manager

Hi I am trying to get my code to select a PDF printer to generate PDF files. When I look at the properties of the printer in XP, the details are Printer Name "Win2PDF" Printer Port "PDFFILE:" Therefore, my code for selecting the printer is Application.ActivePrinter = "Win2PDF on PDFFILE:"...

I hope sombody can help with this. I need to create a query based one just one table that will group records by a Reference Number but join the contents of a string field into the group summary. Here's a simple example of what I'm looking for :- Ref String 1 A 1 B 1 C 2...

I'm trying to set up an email requestor service that will automatically reply with an attachment. I am trying to use the Rules Wizard to create this function. The attachment is just an Excel file that is updated every night. As I see it, there are two possible ways to acheive this. 1. Create a...

Hi does anybody know where I can download an ODBC driver foir Sage Payroll v8.03 ? Many thanks Steve. Steve Fairclough I.T. Manager

Does anybody know where I can get the latest firmware for an Archive Python 06408-xxx DDS Dat drive. I have one in a Poweredge 2450. I've searched Dell and Seagate web sites without success. It will write to the tapes but no longer reads them ? I want to make sure I have all the latest drivers...

Hope somebody can help with this. I've searched Microsoft Technet and their web site but cannot find anything about this. I'm trying to establish a two-way trust that once existed but has since been removed. I have a one way trust going but when I try to set up the trust in the other direction...

Pretty sure it handles both. Steve Fairclough I.T. Manager