Search results for query: *

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

Did you know you can drag all your address fields into a text box. You can set the "suppress embedded field blank lines" properties of the text box to suppress any gaps. This method eliminates the need to have multiple sections or place everything in a formula. Hope this helps...

This could be one of these situations... 1. Do you have the "New Page After" ticked in the properties of the Report Header. 2. Do you have the "New Page Before" ticked in the properties of the section immediately under the Report Header or Page Header - maybe a group ? 3...

I've never found a way of printing the actual design layout from within Crystal, I've always done it by hitting the Print Screen key to capture the screen image to the clipboard and then pasting into an imaging program, even MS Paint will do. It's a bit primitive I know but it does the trick on...

I'm also using Crystal Report Designer v7 on Win2K and do not have any problems. I also distribute compiled v7 reports to many users on our network also running Win2K - no problems there either. Steve Fairclough I.T. Manager

You may need to change it in the ODBC Connection on the user's machine rather than the Crystal Report Design. Steve Fairclough I.T. Manager