How to extract email addresses from a word document or htm web page?

[andreadambra]

Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also have in
txt format or .htm format
The word document is several pages and he has a lot of e-mail addresses
that I cannot just copy and past with the search tool because they are
too much.
How do I do to extract all the email addresses from the word document?
Thanks!

 

[Graham Mayor]

The search tool will work fine for this. 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 to the clipboard.
Open a new document and paste.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

 

[andreadambra]

How do I do without knowing the e-mail addresses? There are hundreds of
e-mail addresses. The only thing they have in commun is the "@".
How do I do?
Thanks

Graham Mayor ha scritto:

The search tool will work fine for this. 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 to the clipboard.
Open a new document and paste.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also have
in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word document?
Thanks!

 

[Graham Mayor]

Read my last message and follow the instructions!

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

How do I do without knowing the e-mail addresses? There are hundreds
of e-mail addresses. The only thing they have in commun is the "@".
How do I do?
Thanks

Graham Mayor ha scritto:

The search tool will work fine for this. 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 to the clipboard.
Open a new document and paste.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also have
in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word
document? Thanks!

 

[Suzanne S. Barnhill]

Graham has given you a wildcard search term that will find all the email
addresses. Did you try the solution he gave you?

1. Use Ctrl+C to copy the search term below:

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

2. Use Ctrl+V to paste it into the "Find what" box in the Find dialog.

3. Click More to display the rest of the dialog; check the boxes for "Use
wildcards" and "Highlight all items found."

4. Find All.

5. Click on the title bar of the document to return the focus to the
document.

6. Press Ctrl+C to copy all the highlighted email addresses.

7. Open a new document and Paste.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

How do I do without knowing the e-mail addresses? There are hundreds of
e-mail addresses. The only thing they have in commun is the "@".
How do I do?
Thanks

Graham Mayor ha scritto:

The search tool will work fine for this. 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 to the clipboard.
Open a new document and paste.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also have
in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word document?
Thanks!

 

[andreadambra]

I'm Italian, so my word is in italian and I don't know what is the
equivalent for "use wildcards"
Thanks!

Suzanne S. Barnhill ha scritto:

Graham has given you a wildcard search term that will find all the email
addresses. Did you try the solution he gave you?

1. Use Ctrl+C to copy the search term below:

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

2. Use Ctrl+V to paste it into the "Find what" box in the Find dialog.

3. Click More to display the rest of the dialog; check the boxes for "Use
wildcards" and "Highlight all items found."

4. Find All.

5. Click on the title bar of the document to return the focus to the
document.

6. Press Ctrl+C to copy all the highlighted email addresses.

7. Open a new document and Paste.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

How do I do without knowing the e-mail addresses? There are hundreds of
e-mail addresses. The only thing they have in commun is the "@".
How do I do?
Thanks

Graham Mayor ha scritto:

The search tool will work fine for this. 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 to the clipboard.
Open a new document and paste.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

(e-mail address removed) wrote:
Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also have
in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word document?
Thanks!

 

[andreadambra]

I tried doing like you told me but the only thing I copied and pasted
were the "@" or ".com" but no the rest of the e-mail address.
How do I can do to copy/past all the e-mail addresses?
Thanks

Suzanne S. Barnhill ha scritto:

Graham has given you a wildcard search term that will find all the email
addresses. Did you try the solution he gave you?

1. Use Ctrl+C to copy the search term below:

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

2. Use Ctrl+V to paste it into the "Find what" box in the Find dialog.

3. Click More to display the rest of the dialog; check the boxes for "Use
wildcards" and "Highlight all items found."

4. Find All.

5. Click on the title bar of the document to return the focus to the
document.

6. Press Ctrl+C to copy all the highlighted email addresses.

7. Open a new document and Paste.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

How do I do without knowing the e-mail addresses? There are hundreds of
e-mail addresses. The only thing they have in commun is the "@".
How do I do?
Thanks

Graham Mayor ha scritto:

The search tool will work fine for this. 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 to the clipboard.
Open a new document and paste.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

(e-mail address removed) wrote:
Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also have
in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word document?
Thanks!

 

[Suzanne S. Barnhill]

That's perhaps because you haven't checked the box for "Use wildcards." I
don't know what it would be in Italian, but in my English version of Word,
it is the third of five check boxes for "Search Options," following "Match
case" and "Find whole words only" and preceding "Sounds like (English)" and
"Find all word forms (English." If this is an Italian version, those last
two may well not appear.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

I tried doing like you told me but the only thing I copied and pasted
were the "@" or ".com" but no the rest of the e-mail address.
How do I can do to copy/past all the e-mail addresses?
Thanks

Suzanne S. Barnhill ha scritto:

Graham has given you a wildcard search term that will find all the email
addresses. Did you try the solution he gave you?

1. Use Ctrl+C to copy the search term below:

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

2. Use Ctrl+V to paste it into the "Find what" box in the Find dialog.

3. Click More to display the rest of the dialog; check the boxes for "Use
wildcards" and "Highlight all items found."

4. Find All.

5. Click on the title bar of the document to return the focus to the
document.

6. Press Ctrl+C to copy all the highlighted email addresses.

7. Open a new document and Paste.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

How do I do without knowing the e-mail addresses? There are hundreds of
e-mail addresses. The only thing they have in commun is the "@".
How do I do?
Thanks

Graham Mayor ha scritto:

The search tool will work fine for this. 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 to the clipboard.
Open a new document and paste.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

(e-mail address removed) wrote:
Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also have
in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word document?
Thanks!

 

[andreadambra]

I found what the use wildcards option is and I checked it but when I
check it and then I enter for example the "@" than word says it cannot
search for this.
I can only search for "@" without the box checked.


Suzanne S. Barnhill ha scritto:

That's perhaps because you haven't checked the box for "Use wildcards." I
don't know what it would be in Italian, but in my English version of Word,
it is the third of five check boxes for "Search Options," following "Match
case" and "Find whole words only" and preceding "Sounds like (English)" and
"Find all word forms (English." If this is an Italian version, those last
two may well not appear.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

I tried doing like you told me but the only thing I copied and pasted
were the "@" or ".com" but no the rest of the e-mail address.
How do I can do to copy/past all the e-mail addresses?
Thanks

Suzanne S. Barnhill ha scritto:

Graham has given you a wildcard search term that will find all the email
addresses. Did you try the solution he gave you?

1. Use Ctrl+C to copy the search term below:

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

2. Use Ctrl+V to paste it into the "Find what" box in the Find dialog.

3. Click More to display the rest of the dialog; check the boxes for "Use
wildcards" and "Highlight all items found."

4. Find All.

5. Click on the title bar of the document to return the focus to the
document.

6. Press Ctrl+C to copy all the highlighted email addresses.

7. Open a new document and Paste.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

How do I do without knowing the e-mail addresses? There are hundreds of
e-mail addresses. The only thing they have in commun is the "@".
How do I do?
Thanks

Graham Mayor ha scritto:

The search tool will work fine for this. 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 to the clipboard.
Open a new document and paste.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

(e-mail address removed) wrote:
Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also have
in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word document?
Thanks!

 

[Doug Robbins - Word MVP]

Run the following macro when the document containing the email addresses is
the active document
Macro to extract all of the email addresses from a document
Sub CopyAddressesToOtherDoc()

Dim Source As Document, Target As Document, myRange As Range
Set Source = ActiveDocument
Set Target = Documents.Add
Source.Activate
Selection.HomeKey Unit:=wdStory
Selection.Find.ClearFormatting
With Selection.Find
Do While .Execute(findText:="[+0-9A-z._-]{1,}\@[A-z.]{1,}", _
MatchWildcards:=True, Wrap:=wdFindStop, Forward:=True) = True
Set myRange = Selection.Range
Target.Range.InsertAfter myRange & vbCr
Loop
End With
Selection.HomeKey Unit:=wdStory
Target.Activate
End Sub

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Graham Mayor]

The @ symbol has a special meaning in Wildcard searches, and you have to use
an escape character - here '\' whenever such a special character is used.
The search string
[a-zA-Z0-9\-_.]{1,}\@[a-zA-Z0-9\-_.]{1,}
if pasted from here, works with English versions of Word. With other
languages you may have to change the escape character '\' for whatever is
appropriate for your language version. Check the help for Wildcard
replacements in your copy of Word and see what that character is - then
replace the three instances of '\' with that character.


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

I found what the use wildcards option is and I checked it but when I
check it and then I enter for example the "@" than word says it cannot
search for this.
I can only search for "@" without the box checked.


Suzanne S. Barnhill ha scritto:

That's perhaps because you haven't checked the box for "Use
wildcards." I don't know what it would be in Italian, but in my
English version of Word, it is the third of five check boxes for
"Search Options," following "Match case" and "Find whole words only"
and preceding "Sounds like (English)" and "Find all word forms
(English." If this is an Italian version, those last two may well
not appear.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

I tried doing like you told me but the only thing I copied and
pasted were the "@" or ".com" but no the rest of the e-mail address.
How do I can do to copy/past all the e-mail addresses?
Thanks

Suzanne S. Barnhill ha scritto:

Graham has given you a wildcard search term that will find all the
email addresses. Did you try the solution he gave you?

1. Use Ctrl+C to copy the search term below:

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

2. Use Ctrl+V to paste it into the "Find what" box in the Find
dialog.

3. Click More to display the rest of the dialog; check the boxes
for "Use wildcards" and "Highlight all items found."

4. Find All.

5. Click on the title bar of the document to return the focus to
the document.

6. Press Ctrl+C to copy all the highlighted email addresses.

7. Open a new document and Paste.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

How do I do without knowing the e-mail addresses? There are
hundreds of e-mail addresses. The only thing they have in commun
is the "@". How do I do?
Thanks

Graham Mayor ha scritto:

The search tool will work fine for this. 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 to the clipboard.
Open a new document and paste.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

(e-mail address removed) wrote:
Hello,
I'm in trouble because I'm trying to find the way to extract
some e-mail addresses that are in a .doc document I have that I
also have in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word
document? Thanks!

 

[Graham Mayor]

Doug

I suspect that your macro may run into the same language issues that the
search string is having problems with i.e. the escape character \ before the
@


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Run the following macro when the document containing the email
addresses is the active document
Macro to extract all of the email addresses from a document
Sub CopyAddressesToOtherDoc()

Dim Source As Document, Target As Document, myRange As Range
Set Source = ActiveDocument
Set Target = Documents.Add
Source.Activate
Selection.HomeKey Unit:=wdStory
Selection.Find.ClearFormatting
With Selection.Find
Do While .Execute(findText:="[+0-9A-z._-]{1,}\@[A-z.]{1,}", _
MatchWildcards:=True, Wrap:=wdFindStop, Forward:=True) = True
Set myRange = Selection.Range
Target.Range.InsertAfter myRange & vbCr
Loop
End With
Selection.HomeKey Unit:=wdStory
Target.Activate
End Sub

Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also have
in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word
document? Thanks!

 

[andreadambra]

It doesn't work...
How can I know what is the italian thing for "\"?
You work for Microsoft and you know anyone of your colleagues in Italy
that can pass you this information?
Thanks!

Graham Mayor ha scritto:

Doug

I suspect that your macro may run into the same language issues that the
search string is having problems with i.e. the escape character \ before the
@


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Run the following macro when the document containing the email
addresses is the active document
Macro to extract all of the email addresses from a document
Sub CopyAddressesToOtherDoc()

Dim Source As Document, Target As Document, myRange As Range
Set Source = ActiveDocument
Set Target = Documents.Add
Source.Activate
Selection.HomeKey Unit:=wdStory
Selection.Find.ClearFormatting
With Selection.Find
Do While .Execute(findText:="[+0-9A-z._-]{1,}\@[A-z.]{1,}", _
MatchWildcards:=True, Wrap:=wdFindStop, Forward:=True) = True
Set myRange = Selection.Range
Target.Range.InsertAfter myRange & vbCr
Loop
End With
Selection.HomeKey Unit:=wdStory
Target.Activate
End Sub

Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also have
in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word
document? Thanks!

 

[Graham Mayor]

I don't work for Microsoft - nor does anyone else answering queries here.
This is a user peer group. You have the answer at your fingertips - the
commands are explained in Word Help. The principloes of wildcard searches
are explained at http://www.gmayor.com/replace_using_wildcards.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

It doesn't work...
How can I know what is the Italian thing for "\"?
You work for Microsoft and you know anyone of your colleagues in Italy
that can pass you this information?
Thanks!

Graham Mayor ha scritto:

Doug

I suspect that your macro may run into the same language issues that
the search string is having problems with i.e. the escape character
\ before the @


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Run the following macro when the document containing the email
addresses is the active document
Macro to extract all of the email addresses from a document
Sub CopyAddressesToOtherDoc()

Dim Source As Document, Target As Document, myRange As Range
Set Source = ActiveDocument
Set Target = Documents.Add
Source.Activate
Selection.HomeKey Unit:=wdStory
Selection.Find.ClearFormatting
With Selection.Find
Do While .Execute(findText:="[+0-9A-z._-]{1,}\@[A-z.]{1,}", _
MatchWildcards:=True, Wrap:=wdFindStop, Forward:=True) = True
Set myRange = Selection.Range
Target.Range.InsertAfter myRange & vbCr
Loop
End With
Selection.HomeKey Unit:=wdStory
Target.Activate
End Sub


Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also
have in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word
document? Thanks!

 

[Graham Mayor]

My next step would have been to direct you to the Italian Word
newsgroup -but I see that you have already found that one

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

I don't work for Microsoft - nor does anyone else answering queries
here. This is a user peer group. You have the answer at your
fingertips - the commands are explained in Word Help. The principloes
of wildcard searches are explained at
http://www.gmayor.com/replace_using_wildcards.htm

It doesn't work...
How can I know what is the Italian thing for "\"?
You work for Microsoft and you know anyone of your colleagues in
Italy that can pass you this information?
Thanks!

Graham Mayor ha scritto:

Doug

I suspect that your macro may run into the same language issues that
the search string is having problems with i.e. the escape character
\ before the @


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Doug Robbins - Word MVP wrote:
Run the following macro when the document containing the email
addresses is the active document
Macro to extract all of the email addresses from a document
Sub CopyAddressesToOtherDoc()

Dim Source As Document, Target As Document, myRange As Range
Set Source = ActiveDocument
Set Target = Documents.Add
Source.Activate
Selection.HomeKey Unit:=wdStory
Selection.Find.ClearFormatting
With Selection.Find
Do While .Execute(findText:="[+0-9A-z._-]{1,}\@[A-z.]{1,}", _
MatchWildcards:=True, Wrap:=wdFindStop, Forward:=True) =
True Set myRange = Selection.Range
Target.Range.InsertAfter myRange & vbCr
Loop
End With
Selection.HomeKey Unit:=wdStory
Target.Activate
End Sub


Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also
have in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word
document? Thanks!

 

[andreadambra]

Thanks. On the italian NG someone gave me the right macro to have all
the e-mails in a new document.
The problem is that the macro take all the "linked e-mails" that have
an hyper-link but the e-mail addresses in my document are all in simple
text, without link.
How do I transform these addresses in hyper link addresses?
Thanks!

Graham Mayor ha scritto:

My next step would have been to direct you to the Italian Word
newsgroup -but I see that you have already found that one

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

I don't work for Microsoft - nor does anyone else answering queries
here. This is a user peer group. You have the answer at your
fingertips - the commands are explained in Word Help. The principloes
of wildcard searches are explained at
http://www.gmayor.com/replace_using_wildcards.htm

It doesn't work...
How can I know what is the Italian thing for "\"?
You work for Microsoft and you know anyone of your colleagues in
Italy that can pass you this information?
Thanks!

Graham Mayor ha scritto:

Doug

I suspect that your macro may run into the same language issues that
the search string is having problems with i.e. the escape character
\ before the @


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Doug Robbins - Word MVP wrote:
Run the following macro when the document containing the email
addresses is the active document
Macro to extract all of the email addresses from a document
Sub CopyAddressesToOtherDoc()

Dim Source As Document, Target As Document, myRange As Range
Set Source = ActiveDocument
Set Target = Documents.Add
Source.Activate
Selection.HomeKey Unit:=wdStory
Selection.Find.ClearFormatting
With Selection.Find
Do While .Execute(findText:="[+0-9A-z._-]{1,}\@[A-z.]{1,}", _
MatchWildcards:=True, Wrap:=wdFindStop, Forward:=True) =
True Set myRange = Selection.Range
Target.Range.InsertAfter myRange & vbCr
Loop
End With
Selection.HomeKey Unit:=wdStory
Target.Activate
End Sub


Hello,
I'm in trouble because I'm trying to find the way to extract some
e-mail addresses that are in a .doc document I have that I also
have in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word
document? Thanks!

 

[Graham Mayor]

I haved already told you repeatedly how to extract email addresses from a
document. This string works fine for English versions of Word. I am
hampered in modifying that for Italian Word by not knowing what the correct
escape character is for the Italian version. Ask your Italian correspondents
in the other group to fix the search string so that it works in your version
i.e. what needs to replace the '\' character.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Thanks. On the italian NG someone gave me the right macro to have all
the e-mails in a new document.
The problem is that the macro take all the "linked e-mails" that have
an hyper-link but the e-mail addresses in my document are all in
simple text, without link.
How do I transform these addresses in hyper link addresses?
Thanks!

Graham Mayor ha scritto:

My next step would have been to direct you to the Italian Word
newsgroup -but I see that you have already found that one

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

I don't work for Microsoft - nor does anyone else answering queries
here. This is a user peer group. You have the answer at your
fingertips - the commands are explained in Word Help. The
principloes of wildcard searches are explained at
http://www.gmayor.com/replace_using_wildcards.htm

(e-mail address removed) wrote:
It doesn't work...
How can I know what is the Italian thing for "\"?
You work for Microsoft and you know anyone of your colleagues in
Italy that can pass you this information?
Thanks!

Graham Mayor ha scritto:

Doug

I suspect that your macro may run into the same language issues
that the search string is having problems with i.e. the escape
character \ before the @


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Doug Robbins - Word MVP wrote:
Run the following macro when the document containing the email
addresses is the active document
Macro to extract all of the email addresses from a document
Sub CopyAddressesToOtherDoc()

Dim Source As Document, Target As Document, myRange As Range
Set Source = ActiveDocument
Set Target = Documents.Add
Source.Activate
Selection.HomeKey Unit:=wdStory
Selection.Find.ClearFormatting
With Selection.Find
Do While .Execute(findText:="[+0-9A-z._-]{1,}\@[A-z.]{1,}", _
MatchWildcards:=True, Wrap:=wdFindStop, Forward:=True) =
True Set myRange = Selection.Range
Target.Range.InsertAfter myRange & vbCr
Loop
End With
Selection.HomeKey Unit:=wdStory
Target.Activate
End Sub


Hello,
I'm in trouble because I'm trying to find the way to extract
some e-mail addresses that are in a .doc document I have that I
also have in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word
document? Thanks!

 

[andreadambra]

Thanks, On the Italian NG they helped me greatily. Now that I have the
list of e-mails.
Would you please be able to tell me to which societes I can address my
self for sending newsletter to several addresses?
Thanks and Regards

Graham Mayor ha scritto:

I haved already told you repeatedly how to extract email addresses from a
document. This string works fine for English versions of Word. I am
hampered in modifying that for Italian Word by not knowing what the correct
escape character is for the Italian version. Ask your Italian correspondents
in the other group to fix the search string so that it works in your version
i.e. what needs to replace the '\' character.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Thanks. On the italian NG someone gave me the right macro to have all
the e-mails in a new document.
The problem is that the macro take all the "linked e-mails" that have
an hyper-link but the e-mail addresses in my document are all in
simple text, without link.
How do I transform these addresses in hyper link addresses?
Thanks!

Graham Mayor ha scritto:

My next step would have been to direct you to the Italian Word
newsgroup -but I see that you have already found that one

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Graham Mayor wrote:
I don't work for Microsoft - nor does anyone else answering queries
here. This is a user peer group. You have the answer at your
fingertips - the commands are explained in Word Help. The
principloes of wildcard searches are explained at
http://www.gmayor.com/replace_using_wildcards.htm

(e-mail address removed) wrote:
It doesn't work...
How can I know what is the Italian thing for "\"?
You work for Microsoft and you know anyone of your colleagues in
Italy that can pass you this information?
Thanks!

Graham Mayor ha scritto:

Doug

I suspect that your macro may run into the same language issues
that the search string is having problems with i.e. the escape
character \ before the @


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Doug Robbins - Word MVP wrote:
Run the following macro when the document containing the email
addresses is the active document
Macro to extract all of the email addresses from a document
Sub CopyAddressesToOtherDoc()

Dim Source As Document, Target As Document, myRange As Range
Set Source = ActiveDocument
Set Target = Documents.Add
Source.Activate
Selection.HomeKey Unit:=wdStory
Selection.Find.ClearFormatting
With Selection.Find
Do While .Execute(findText:="[+0-9A-z._-]{1,}\@[A-z.]{1,}", _
MatchWildcards:=True, Wrap:=wdFindStop, Forward:=True) =
True Set myRange = Selection.Range
Target.Range.InsertAfter myRange & vbCr
Loop
End With
Selection.HomeKey Unit:=wdStory
Target.Activate
End Sub


Hello,
I'm in trouble because I'm trying to find the way to extract
some e-mail addresses that are in a .doc document I have that I
also have in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search tool
because they are too much.
How do I do to extract all the email addresses from the word
document? Thanks!

 

[Graham Mayor]

Something may have got lost in your translation, but I think what you may be
looking for is
http://www.gmayor.com/MSNews.htm If not then maybe the Italian group can
help out once again?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Thanks, On the Italian NG they helped me greatily. Now that I have the
list of e-mails.
Would you please be able to tell me to which societes I can address my
self for sending newsletter to several addresses?
Thanks and Regards

Graham Mayor ha scritto:

I haved already told you repeatedly how to extract email addresses
from a document. This string works fine for English versions of
Word. I am hampered in modifying that for Italian Word by not
knowing what the correct escape character is for the Italian
version. Ask your Italian correspondents in the other group to fix
the search string so that it works in your version i.e. what needs
to replace the '\' character.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Thanks. On the italian NG someone gave me the right macro to have
all the e-mails in a new document.
The problem is that the macro take all the "linked e-mails" that
have an hyper-link but the e-mail addresses in my document are all
in simple text, without link.
How do I transform these addresses in hyper link addresses?
Thanks!

Graham Mayor ha scritto:

My next step would have been to direct you to the Italian Word
newsgroup -but I see that you have already found that one

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Graham Mayor wrote:
I don't work for Microsoft - nor does anyone else answering
queries here. This is a user peer group. You have the answer at
your fingertips - the commands are explained in Word Help. The
principloes of wildcard searches are explained at
http://www.gmayor.com/replace_using_wildcards.htm

(e-mail address removed) wrote:
It doesn't work...
How can I know what is the Italian thing for "\"?
You work for Microsoft and you know anyone of your colleagues in
Italy that can pass you this information?
Thanks!

Graham Mayor ha scritto:

Doug

I suspect that your macro may run into the same language issues
that the search string is having problems with i.e. the escape
character \ before the @


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Doug Robbins - Word MVP wrote:
Run the following macro when the document containing the email
addresses is the active document
Macro to extract all of the email addresses from a document
Sub CopyAddressesToOtherDoc()

Dim Source As Document, Target As Document, myRange As Range
Set Source = ActiveDocument
Set Target = Documents.Add
Source.Activate
Selection.HomeKey Unit:=wdStory
Selection.Find.ClearFormatting
With Selection.Find
Do While .Execute(findText:="[+0-9A-z._-]{1,}\@[A-z.]{1,}",
_ MatchWildcards:=True, Wrap:=wdFindStop,
Forward:=True) = True Set myRange = Selection.Range
Target.Range.InsertAfter myRange & vbCr
Loop
End With
Selection.HomeKey Unit:=wdStory
Target.Activate
End Sub


Hello,
I'm in trouble because I'm trying to find the way to extract
some e-mail addresses that are in a .doc document I have that
I also have in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search
tool because they are too much.
How do I do to extract all the email addresses from the word
document? Thanks!

 

[Suzanne S. Barnhill]

I think she's asking how to merge to email.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

Something may have got lost in your translation, but I think what you may be
looking for is
http://www.gmayor.com/MSNews.htm If not then maybe the Italian group can
help out once again?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Thanks, On the Italian NG they helped me greatily. Now that I have the
list of e-mails.
Would you please be able to tell me to which societes I can address my
self for sending newsletter to several addresses?
Thanks and Regards

Graham Mayor ha scritto:

I haved already told you repeatedly how to extract email addresses
from a document. This string works fine for English versions of
Word. I am hampered in modifying that for Italian Word by not
knowing what the correct escape character is for the Italian
version. Ask your Italian correspondents in the other group to fix
the search string so that it works in your version i.e. what needs
to replace the '\' character.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

(e-mail address removed) wrote:
Thanks. On the italian NG someone gave me the right macro to have
all the e-mails in a new document.
The problem is that the macro take all the "linked e-mails" that
have an hyper-link but the e-mail addresses in my document are all
in simple text, without link.
How do I transform these addresses in hyper link addresses?
Thanks!

Graham Mayor ha scritto:

My next step would have been to direct you to the Italian Word
newsgroup -but I see that you have already found that one

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Graham Mayor wrote:
I don't work for Microsoft - nor does anyone else answering
queries here. This is a user peer group. You have the answer at
your fingertips - the commands are explained in Word Help. The
principloes of wildcard searches are explained at
http://www.gmayor.com/replace_using_wildcards.htm

(e-mail address removed) wrote:
It doesn't work...
How can I know what is the Italian thing for "\"?
You work for Microsoft and you know anyone of your colleagues in
Italy that can pass you this information?
Thanks!

Graham Mayor ha scritto:

Doug

I suspect that your macro may run into the same language issues
that the search string is having problems with i.e. the escape
character \ before the @


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com

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

Doug Robbins - Word MVP wrote:
Run the following macro when the document containing the email
addresses is the active document
Macro to extract all of the email addresses from a document
Sub CopyAddressesToOtherDoc()

Dim Source As Document, Target As Document, myRange As Range
Set Source = ActiveDocument
Set Target = Documents.Add
Source.Activate
Selection.HomeKey Unit:=wdStory
Selection.Find.ClearFormatting
With Selection.Find
Do While .Execute(findText:="[+0-9A-z._-]{1,}\@[A-z.]{1,}",
_ MatchWildcards:=True, Wrap:=wdFindStop,
Forward:=True) = True Set myRange = Selection.Range
Target.Range.InsertAfter myRange & vbCr
Loop
End With
Selection.HomeKey Unit:=wdStory
Target.Activate
End Sub


Hello,
I'm in trouble because I'm trying to find the way to extract
some e-mail addresses that are in a .doc document I have that
I also have in txt format or .htm format
The word document is several pages and he has a lot of e-mail
addresses that I cannot just copy and past with the search
tool because they are too much.
How do I do to extract all the email addresses from the word
document? Thanks!