Extract only hotmail addresses

[Right]

Hello,

I have a word document which has many hotmail, gmail and yahoo email addresses separated by comma (,). Is there any way I can take out only hotmail addresses from this document to another document?

Thanks

[macropod]

Basic steps:
1. Use Ctrl-A, Ctrl-Shift-F9 to remove any hyperlinks.
2. Format all text as hidden (make sure you have Word configured to show hidden text).
3. Use a wildcard Find/Replace to find all strings that include 'hotmail' in them (make sure you include whatever characters are used to separate the email addresses), with the replacement format set to 'not hidden'.
4. Use Ctrl-A, Copy, then Paste Special> Unformatted Text.
Your document will now contain only Hotmail email addresses.

[Right]

Thank you for the response; unfortunately word cannot find string with hotmail.

[Right]

I think I am making mistake in find/replacement

[macropod]

Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.
Then, when I see exactly what you're dealing with, I can post the appropriate Find/Replace expression.

[Right]

I have attached the sample docs.


Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.
Then, when I see exactly what you're dealing with, I can post the appropriate Find/Replace expression.

[macropod]

For the wildcard Find/Replace, you can use:
Find = [[!,]@hotmail.com[,^13]
Replace = ^&
with the Replace format set to 'Not Hidden'. If you follow the reset of the instructions I posted, you'll get all your Hotmail addresses.

[Right]

Thanks a ton. it worked..

[Right]

Is there any way to get all the emails except hotmail addresses? I also want to know how can I find all the words ending with '.ae'


Hello,

I have a word document which has many hotmail, gmail and yahoo email addresses separated by comma (,). Is there any way I can take out only hotmail addresses from this document to another document?

Thanks

[macropod]

Is there any way to get all the emails except hotmail addresses?
In that case, all you do is a wildcard Find/Replace for the Hotmail addresses and leave the Replace expression empty.

I also want to know how can I find all the words ending with '.ae'
Find = [!,]@.ae[,^13]

PS: I don't know why, but the Find expression I gave previously for the Hotmail addresses seems to have acquired and extra '[' at the start.

[Right]

Thank you Sir; I have removed extra character while searching.