Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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! |
#2
|
|||
|
|||
Answer: How to extract email addresses from a word document or htm web page?
Extracting Email Addresses from a Word Document or HTML Web Page
I hope this helps you extract the email addresses you need. If you have any questions, feel free to ask. PHP Code:
__________________
I am not human. I am a Microsoft Word Wizard |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP web site http://word.mvps.org 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! |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP web site http://word.mvps.org 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! |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. wrote in message ups.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 Word MVP web site http://word.mvps.org 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! |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. wrote in message ups.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 Word MVP web site http://word.mvps.org 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! |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. wrote in message ups.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 Word MVP web site http://word.mvps.org 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! |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. wrote in message ps.com... 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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. wrote in message ups.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 Word MVP web site http://word.mvps.org 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! |
#10
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. wrote in message ps.com... 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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. wrote in message ups.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 Word MVP web site http://word.mvps.org 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! |
#11
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 wrote in message oups.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! |
#12
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP web site http://word.mvps.org wrote: 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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. wrote in message ps.com... 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 Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. wrote in message ups.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 Word MVP web site http://word.mvps.org 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! |
#13
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP web site http://word.mvps.org 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 wrote in message oups.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! |
#14
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP web site http://word.mvps.org 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 wrote in message oups.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! |
#15
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP web site http://word.mvps.org 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 Word MVP web site http://word.mvps.org 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 wrote in message oups.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! |
#16
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP web site http://word.mvps.org 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 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 Word MVP web site http://word.mvps.org 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 wrote in message oups.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! |
#17
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP web site http://word.mvps.org 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 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 Word MVP web site http://word.mvps.org 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 wrote in message oups.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! |
#18
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP web site http://word.mvps.org 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 Word MVP web site http://word.mvps.org 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 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 Word MVP web site http://word.mvps.org 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 wrote in message oups.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! |
#19
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP web site http://word.mvps.org 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 Word MVP web site http://word.mvps.org 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 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 Word MVP web site http://word.mvps.org 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 wrote in message oups.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! |
#20
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
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 Word MVP web site http://word.mvps.org wrote: 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 Word MVP web site http://word.mvps.org 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 Word MVP web site http://word.mvps.org 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 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 Word MVP web site http://word.mvps.org 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 wrote in message oups.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! |
#21
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
I think she's asking how to merge to email.
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Graham Mayor" wrote in message ... 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 Word MVP web site http://word.mvps.org wrote: 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 Word MVP web site http://word.mvps.org 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 Word MVP web site http://word.mvps.org 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 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 Word MVP web site http://word.mvps.org 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 wrote in message oups.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! |
#22
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
I'm asking (i'm a man) which e-mail marketing company is the best.
Thanks Suzanne S. Barnhill ha scritto: I think she's asking how to merge to email. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Graham Mayor" wrote in message ... 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 Word MVP web site http://word.mvps.org wrote: 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 Word MVP web site http://word.mvps.org 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 Word MVP web site http://word.mvps.org 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 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 Word MVP web site http://word.mvps.org 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 wrote in message oups.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! |
#23
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
How to extract email addresses from a word document or htm web page?
This would not be the best forum in which to expect an answer to that. I
suggest that you Google for it. -- 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 wrote in message ups.com... I'm asking (i'm a man) which e-mail marketing company is the best. Thanks Suzanne S. Barnhill ha scritto: I think she's asking how to merge to email. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Graham Mayor" wrote in message ... 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 Word MVP web site http://word.mvps.org wrote: 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 Word MVP web site http://word.mvps.org 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 Word MVP web site http://word.mvps.org 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 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 Word MVP web site http://word.mvps.org 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 wrote in message oups.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! |
#24
|
|||
|
|||
Can anyone help?
This doenst work with word 2007 thank you behansi Quote:
|
#25
|
|||
|
|||
I realise this Thread is very old but i'm using this macro to date and it's V.usefull.
Only problem is, It seems to have an issue with some emails that contain a hyphen "-" Is there anything that can be done about this? Many thanks!! Quote:
|
#26
|
|||
|
|||
Hello! The solution [a-zA-Z0-9\-_.]{1,}\@[a-zA-Z0-9\-_.]{1,} worked great for me in a similar situation. I am faced with another similar challenge. I have a document that has a multitude of the following:
*lastname,firstname throughout the text (with real last and first names of clients.) I need to highlight and cut all the above from the document. what is the formula to search *firstname,lastname? Thanks! Quote:
|
#27
|
|||
|
|||
Wow, Graham your help with the find problem really saved me hours of cut and pasting. Not sure if this is where I post this. I now have the list of emails in doc. Can I merge them into a new contact form for each one?
Quote:
|
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Ending page numbering | Microsoft Word Help | |||
Macro for Letter Settings Help | New Users | |||
page number positioning and format | Page Layout | |||
How do I extract email addresses from a word document? | Microsoft Word Help |