Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Mictain

    Need to Reject Outgoing Messages To A Specific Domain

    Thanks for your response, Zelandakh :-) In the end we set the 'blocked domain' SMTP Connector to route to our own mail server and we got nice 5.3.5 errors back like we wanted. So job done! Just thought I'd share in case it helps someone else :-D
  2. Mictain

    Need to Reject Outgoing Messages To A Specific Domain

    Dear All, My company wants to reject all outgoing mail to one particular domain, say blah.com, and have the sender receive an undeliverable message from the system when this happens. I have tried to set this up by following this information I was sent: ------ [Exchange 2003] Create an SMTP...
  3. Mictain

    Exchange 2003 Policy Being Ignored

    Hello all. I recently added a domain address to an Exchange Email Address Policy but the change hasn't shown up as a default addition for the users and I'm not sure why. Yes, I made sure I applied the policy afterwards :-D We currently have a mix of 3 mail name policies: Domain, UK and US with...
  4. Mictain

    Excel Count Based On 'AND' Criteria Being Met

    Thanks for all your help on this, folks. It's now looking more like I'd hoped: I'm going to leave it alone now before I mess it up [smile] Thanks again. Neil.
  5. Mictain

    Excel Count Based On 'AND' Criteria Being Met

    Thanks Molby. I've never created a pivot table before so I've had a quick bash at one and yes, it's displaying the category / breakdown count as required [smile] The original request was to have the count displayed for all combinations in a results table at the same time, like this: And my...
  6. Mictain

    Excel Count Based On 'AND' Criteria Being Met

    Hello, This is probably very simple, but I can't quite convert what seems logical into a formula to get the results needed. I have two columns of data with this setup: Cat. Time Range A 30 to 60 A 60 to 120 A 60 to 120 B 180 to 240 B 300+ C 0 to 30 C 60 to 120 I...
  7. Mictain

    Excel - Combine VLOOKUPs Using IF Function

    I was initially trying to work around the formula I had, and I have not used Offset before so was unaware this kind of setup could be achieved. Now I am I shall endeavour to use that instead where applicable. Thank you for your input.
  8. Mictain

    Excel - Combine VLOOKUPs Using IF Function

    Thanks Skip. I'll have a go with that one later [smile]
  9. Mictain

    Excel - Combine VLOOKUPs Using IF Function

    Rates!A3:H9 - Same format as the original shot but with three isolated tables: http://www.boomspeed.com/mictain/ExcelTable2.jpg HTH Neil.
  10. Mictain

    Excel - Combine VLOOKUPs Using IF Function

    Thanks for the quick reply, Skip. With a little bit of tweaking that formula setup worked. Cheers [thumbsup] This one works: =VLOOKUP(I7,IF(J7="A",Rates!$A$3:$B$4,IF(J7="B",Rates!$D$3:$E$7,Rates!$G$3:$H$9)),2,TRUE) As you asked for a sample... In this shot I start with the item weight, which...
  11. Mictain

    Excel - Combine VLOOKUPs Using IF Function

    Hi All, I am currently using a VLOOKUP formula on a weight against price spreadsheet and it works well, but I need to expand it so it looks at three column sets and pulls the required information from the correct one depending on which data is in another column. At the moment I am using...
  12. Mictain

    Excel - If Data Is Between X and Y Then...

    Thanks for that firefytr [thumbsup] The price scale will change every now and again, but what you suggested is what I was thinking of initially, so it's good to have that formula as well. That sounds like an achievement to celebrate then, xlhelp. You need one of these... [medal] [bigsmile]
  13. Mictain

    Excel - If Data Is Between X and Y Then...

    Wow, fast responses there! [smile] I've had a play with what you've suggested and it looks like it's going to work out nicely, so many thanks xlhelp and xlbo [2thumbsup] Neil.
  14. Mictain

    Excel - If Data Is Between X and Y Then...

    Hello all, I'm trying to set up a formula as per the post subject relating to weight and price but with about 17 conditions per cell. So I'm looking at: If cell A1 is between 0 and 60 then show '32' in A4; if it's between 61 and 100 then show '49' in A4, if it's between 101 and 150 then show...
  15. Mictain

    Change Mailbox Owner In Exchange 2003

    After coming across this thread thread955-785016 which sort of relates to this issue, I thought I'd post some additional blurb I found and used successfully in case others are left scratching their heads on what used to be such a simple issue to resolve with 5.5 :-) Instead of selecting a new...
  16. Mictain

    Reading & Restoring Raw IMCDATA Messages?

    Thanks for that, zbnet. I got a shortlist(!) of 1,000 mails after an initial text search, so used a renaming program to give them all this extension, then dragged and dropped the lot into OLExpress and sorted further that way. Nice one [2thumbsup]
  17. Mictain

    Reading & Restoring Raw IMCDATA Messages?

    Afternoon all, As a starting point I'd like to say "yes, I know they can be individually read using notepad!" And now that's out of the way... [wink] I have been asked to try and find some particular e-mails during a month long period, which means I have about 40k+ archived mail messages to go...
  18. Mictain

    determine when email was opened

    Ah, I see what you're getting at now. Sorry; it's been a long day! Don't know if I can help with this one, I'm afraid. I'll have a look around and if I find anything I'll let you know because you've got me intrigued now :-) You never said what mail program you're using, btw. Neil.
  19. Mictain

    False 'Undeliverable' Message Going Out

    External customer across the pond (?) Or are you talking domain? We're using Exchange 5.5 on an NT4 box atm.
  20. Mictain

    determine when email was opened

    What mail program are you using? If you're using Outlook you could set up read receipts. Is that what you're after, or am I missing something? Neil.

Part and Inventory Search

Back
Top