Please does anyone have a way of extracting all the email addresses from a
long document and placing them in a new document. Presumably a way would be
to look for the @ symbol, then move to the first space before and the last
space after that string, copy and paste into a new document. so much for the
idea, can anyone tell me how to make it happen?
Many thanks if you can
--
kevin
(Word 2003 SP2)

Use the find routine (CTRL+F) to find

[ ][a-zA-Z0-9\-_.]{1,}\@[a-zA-Z0-9\-_.]{1,}[ ]

with the wildcards box and the highlight all found entries box checked.
The e-mail addresses will be highlighted.
Close the find dialog. Then copy
open a new document and paste.
This worked for all the e-mail addresses in my database.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



kevin gb wrote:
Please does anyone have a way of extracting all the email addresses
from a long document and placing them in a new document. Presumably a
way would be to look for the @ symbol, then move to the first space
before and the last space after that string, copy and paste into a
new document. so much for the idea, can anyone tell me how to make it
happen?
Many thanks if you can

Brilliant Graham, that is just the solution (though for some reason the
square brackets at the start and end of the expression need to be deleted for
it to work on my documents).
Many thanks for the expert help.
--
kevin


"Graham Mayor" wrote:

Use the find routine (CTRL+F) to find

[ ][a-zA-Z0-9\-_.]{1,}\@[a-zA-Z0-9\-_.]{1,}[ ]

with the wildcards box and the highlight all found entries box checked.
The e-mail addresses will be highlighted.
Close the find dialog. Then copy
open a new document and paste.
This worked for all the e-mail addresses in my database.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



kevin gb wrote:
Please does anyone have a way of extracting all the email addresses
from a long document and placing them in a new document. Presumably a
way would be to look for the @ symbol, then move to the first space
before and the last space after that string, copy and paste into a
new document. so much for the idea, can anyone tell me how to make it
happen?
Many thanks if you can

I suspect that the e-mail addresses are on lines of their own then? The
search code assumed them to be embedded in text. The brackets contain spaces
that would thus form the start and ends of the addresses. The brackets
themselves are not required.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



kevin gb wrote:
Brilliant Graham, that is just the solution (though for some reason
the square brackets at the start and end of the expression need to be
deleted for it to work on my documents).
Many thanks for the expert help.

Use the find routine (CTRL+F) to find

[ ][a-zA-Z0-9\-_.]{1,}\@[a-zA-Z0-9\-_.]{1,}[ ]

with the wildcards box and the highlight all found entries box
checked. The e-mail addresses will be highlighted.
Close the find dialog. Then copy
open a new document and paste.
This worked for all the e-mail addresses in my database.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



kevin gb wrote:
Please does anyone have a way of extracting all the email addresses
from a long document and placing them in a new document. Presumably
a way would be to look for the @ symbol, then move to the first
space before and the last space after that string, copy and paste
into a new document. so much for the idea, can anyone tell me how
to make it happen?
Many thanks if you can