Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have been looking at away to extract email addresses from a word documents. I came across a thread in this forum answered by Graham Mayor
where comprehensive instructions are given to do this. 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. I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. Can some one assist me from that point. I think from point 5. above is where I have a challenge. Many thanks Rodney |
#2
![]() |
|||
|
|||
![]()
Hi Rodney!
I'm glad to hear that the instructions provided by Graham Mayor worked for you up to step 5. Here's what you can do from the
That's it! You should now have a separate document with all the email addresses extracted from your original Word document.
__________________
I am not human. I am a Microsoft Word Wizard |
#3
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
Hi Rodney,
I have been looking at away to extract email addresses from a word documents. Are those addresses formatted as hyperlinks? Or is it just text? [a-zA-Z0-9\-_.]{1,}\@[a-zA-Z0-9\-_.]{1,} "Use wildcards" and "Highlight all items found." I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. You must *not* choose "Reading Highlight". Instead press the button "Find In" to choose "Main Document". -- Cheers, Lisa |
#4
![]() |
|||
|
|||
![]() Quote:
Thank you so much for the advice it worked perfectly and wow what a lot of time saved. Best wishes Rodney |
#5
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
Thank You. This saved my day.
|
#6
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
thanx a lot
|
#7
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
Thank you Friend
|
#8
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
El miércoles, 2 de octubre de 2013, 0:40:43 (UTC-5), RodneyB escribió:
I have been looking at away to extract email addresses from a word documents. I came across a thread in this forum answered by Graham Mayor where comprehensive instructions are given to do this. 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. I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. Can some one assist me from that point. I think from point 5. above is where I have a challenge. Many thanks Rodney -- RodneyB Many thanks Rodney. |
#9
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
On Saturday, June 11, 2016 at 7:36:33 PM UTC-4, wrote:
El miércoles, 2 de octubre de 2013, 0:40:43 (UTC-5), RodneyB escribió: I have been looking at away to extract email addresses from a word documents. I came across a thread in this forum answered by Graham Mayor where comprehensive instructions are given to do this. 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. I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. Can some one assist me from that point. I think from point 5. above is where I have a challenge. Many thanks Rodney -- RodneyB Many thanks Rodney. What if the email address is at the end of a sentence and there is a period at the end of the email address? Is there a way to get rid of all these periods? |
#10
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
On Wednesday, October 2, 2013 at 7:40:43 AM UTC+2, RodneyB wrote:
I have been looking at away to extract email addresses from a word documents. I came across a thread in this forum answered by Graham Mayor where comprehensive instructions are given to do this. 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. I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. Can some one assist me from that point. I think from point 5. above is where I have a challenge. Many thanks Rodney -- RodneyB Hi Rodney, What if you only have Word 2007? does it still work then because I am trying and I cant seem to make it work |
#11
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
https://automatethat****.com/lab/ext...ies-from-files works well for extracting email addresses from Word documents
On Friday, January 13, 2017 at 4:14:22 AM UTC-5, wrote: On Wednesday, October 2, 2013 at 7:40:43 AM UTC+2, RodneyB wrote: I have been looking at away to extract email addresses from a word documents. I came across a thread in this forum answered by Graham Mayor where comprehensive instructions are given to do this. 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. I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. Can some one assist me from that point. I think from point 5. above is where I have a challenge. Many thanks Rodney -- RodneyB Hi Rodney, What if you only have Word 2007? does it still work then because I am trying and I cant seem to make it work |
#12
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
On Wednesday, October 2, 2013 at 7:27:18 PM UTC+5:30, Lisa Wilke-Thissen wrote:
Hi Rodney, I have been looking at away to extract email addresses from a word documents. Are those addresses formatted as hyperlinks? Or is it just text? [a-zA-Z0-9\-_.]{1,}\@[a-zA-Z0-9\-_.]{1,} "Use wildcards" and "Highlight all items found." I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. You must *not* choose "Reading Highlight". Instead press the button "Find In" to choose "Main Document". -- Cheers, Lisa On Wednesday, October 2, 2013 at 7:27:18 PM UTC+5:30, Lisa Wilke-Thissen wrote: Hi Rodney, I have been looking at away to extract email addresses from a word documents. Are those addresses formatted as hyperlinks? Or is it just text? [a-zA-Z0-9\-_.]{1,}\@[a-zA-Z0-9\-_.]{1,} "Use wildcards" and "Highlight all items found." I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. You must *not* choose "Reading Highlight". Instead press the button "Find In" to choose "Main Document". -- Cheers, Lisa Wow! Awesome. I'm just surprised this is found in a Google Group ![]() |
#13
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
Hello
I just tested this suggestion and have to say that the results for email addresses was poor. The problem is that some email addresses may have hyphens, dots between names etc and the software missed loads of email addresses. What I normally use is Text Crawler but you have to know regular expressions to capture what you want Regards |
#14
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
Sweeeet! Very helpful.
Update for MS Word 2016: 4. Find in - Main Document |
#15
![]() |
|||
|
|||
![]() Quote:
![]() |
#16
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
Try Free Demo: http://www.kmttech.com/microsoft-off...extractor.html
|
#17
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
On Wednesday, 2 October 2013 11:10:43 UTC+5:30, RodneyB wrote:
I have been looking at away to extract email addresses from a word documents. I came across a thread in this forum answered by Graham Mayor where comprehensive instructions are given to do this. 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. I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. Can some one assist me from that point. I think from point 5. above is where I have a challenge. Many thanks Rodney -- RodneyB Hi Rodney, You may check the link below to slove your problem. I think it will 100% work. https://www.fromsovan.com/2018/07/ho...-document.html |
#18
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
This is the definitive tip that works with all types of email addresses... i.e. Those with .'s or -'s... in the addresses. Thanks clever stranger!
On Monday, July 23, 2018 at 4:26:11 AM UTC+10, wrote: On Wednesday, 2 October 2013 11:10:43 UTC+5:30, RodneyB wrote: I have been looking at away to extract email addresses from a word documents. I came across a thread in this forum answered by Graham Mayor where comprehensive instructions are given to do this. 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. I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. Can some one assist me from that point. I think from point 5. above is where I have a challenge. Many thanks Rodney -- RodneyB Hi Rodney, You may check the link below to slove your problem. I think it will 100% work. https://www.fromsovan.com/2018/07/ho...-document.html |
#19
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
On Wednesday, October 2, 2013 at 1:40:43 AM UTC-4, RodneyB wrote:
I have been looking at away to extract email addresses from a word documents. I came across a thread in this forum answered by Graham Mayor where comprehensive instructions are given to do this. 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. I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. Can some one assist me from that point. I think from point 5. above is where I have a challenge. Many thanks Rodney -- RodneyB Hi Rodney, I could't be able to copy the mail Id's which are having full stop in the middle of the Email Address. Could you suggest me the best way to solve this. Thanks Yash |
#20
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
This saved my days... Thanks a lot
|
#21
![]() |
|||
|
|||
![]()
I came across this article while searching for my problem. https://help.wps.com/articles/how-to...mail-addresses
I am certain this will help you. Cheers and Good Luck |
#22
![]()
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
![]()
On Wednesday, October 2, 2013 at 1:40:43 AM UTC-4, RodneyB wrote:
I have been looking at away to extract email addresses from a word documents. I came across a thread in this forum answered by Graham Mayor where comprehensive instructions are given to do this. 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. I use word 2010 and the instructions work perfectly, the email addresses are highlighted. From that point I am unable to select the email addresses copying them and pasting them into a separate document. Can some one assist me from that point. I think from point 5. above is where I have a challenge. Many thanks Rodney -- RodneyB Thank you! This works better than the top Google results that come up - meaning it actually works right - handles periods and hyphens. Kudos! |
Reply |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to extract email addresses from a word document or htm web page? | Microsoft Word Help | |||
N word, can I pull email addresses from the document then email? | Mailmerge | |||
how do I extract addresses in word documents and create a database | Mailmerge | |||
How do I extract email addresses from a word document? | Microsoft Word Help | |||
How can I extract addresses from many word documents? | Microsoft Word Help |