A couple of guys answered this in the MS Office forum. If this has been a problem for anyone else, the formula in excel is:
=MID(A14,FIND("SMTP:",A14),(FIND("%",A14,FIND("SMTP:",A14))-FIND("SMTP:",A14)))
Substitute A14 for the field that the 'e-mail...
Guys,
If you where female I'd kiss u! But you'll just have to make-do with a manly handshake, a shiny purple star and a MASSIVE THANK YOU!
:)
If someone annoys you, walk a mile in their shoes. That way you'll be a mile away from them, and you'll have their shoes :o)
I have an imported csv file 16000 records in it. One of the fields has a format that looks like this:
"SNADS:DOMAIN/SMITHJO%SMTP:John.Smith@domain.com%X400:c=COM;a=DBP;p=ABC;o=COMPANY;s=Smith;g=John;i=AK;%MRS:John.Smith@MRSIN.domain.com"
I would like to be able the export the...
I've been sent an address book export from one of our of sister companies.
Unfortunately they have exported all of the e-mail address (x400, MRS, etc) as well as the SMTP address. Does anybody know a formula I could use in excel to extract only the SMTP information from the e-mail addresses...
Hi,
Check out Pest patrol @
http://www.sunbeltsoftware.com/product.cfm?id=911
It scans for all sorts of spyware, malware etc that virus checkers don't look for :) If someone annoys you, walk a mile in their shoes. That way you'll be a mile away from them, and you'll have their shoes :o)
Hi,
I'm creating a .bat file for some tasks I want to automate and I need to create a ;NT4.0 section and a ;Win2k section.
Does anyone know of an environment variable I can use to distinguish between NT and 2k?
The %OS% variable for both NT and 2k is 'Windows_NT', which isn't too helpful...
FTP servers (in this case IIS) can be set to only accept connections from hosts that have a valid reverse DNS.
I'm trying to find out if IIS does this by default. I know there is a way to add this functionality via the metabase, but I'm unsure if this feature is enabled by default when you...
Hi,
Could anyone tell me if Reverse DNS Lookup is enabled by default in IIS 5.0?
TIA,
Kris. If someone annoys you, walk a mile in their shoes. That way you'll be a mile away from them, and you'll have their shoes :o)
Just to add to this, you can set the permissions to view the other mailbox through Exchange administrator too.
To do it, go into the properties of the generic mailbox, click on permissions and add yourself as a user.
There can be a downside to this whe using this method with users though, as...
As far as I know, there is no way to send a 'rejected' message when you use the filtering option in the IMC. To enable a rejected message to be sent, you'd have to run a 3rd party filtering application such as mimesweeper on Exchange. If someone annoys you, walk a mile in their shoes. That way...
Have a look at articles Q280449 and Q261251. One of them should help :) If someone annoys you, walk a mile in their shoes. That way you'll be a mile away from them, and you'll have their shoes :o)
what Event ID does the error give in Event Viewer? If someone annoys you, walk a mile in their shoes. That way you'll be a mile away from them, and you'll have their shoes :o)
If you set the permissions through Exchange Administrator instead of Outlook, there's an option to propogate settings to sub-folders.
Click on the public folder then press [ALT] + [ENTER] to access the permissions screen.
If someone annoys you, walk a mile in their shoes. That way you'll be a...
Hi,
Have a look at MS Article Q264426. It's a list of knowledgebase articles on x400 Troubleshooting. If someone annoys you, walk a mile in their shoes. That way you'll be a mile away from them, and you'll have their shoes :o)
Thanks for getting back to me :)
The setup is quite complex. Unfortunately I've been pulled off to another project for the moment, but I'll get to back to you soon!!
Thanks again mate :) If someone annoys you, walk a mile in their shoes. That way you'll be a mile away from them, and you'll...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.