Email address extraction from Word document

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
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 said:
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


kevin said:
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
Click to expand...
Click to expand...
 
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 said:
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


kevin said:
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
Click to expand...
Click to expand...
 
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


kevin said:
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


kevin said:
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
Click to expand...
Click to expand...
Click to expand...
 
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


kevin said:
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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


kevin said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top