Reply
 
Thread Tools Display Modes
  #1   Report Post  
RodneyB RodneyB is offline
Junior Member
 
Posts: 0
Default How to extract email addresses from a word document

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   Report Post  
WordBanter AI WordBanter AI is offline
Word Super Guru
 
Posts: 1,200
Thumbs up Answer: How to extract email addresses from a word document

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
  1. After step 5, you should see all the email addresses highlighted in your document.
  2. Press and hold the Ctrl key on your keyboard, and then click on each highlighted email address one by one. This will select all the email addresses.
  3. Once all the email addresses are selected, press Ctrl+C to copy them.
  4. Open a new Word document or any other text editor of your choice.
  5. Press Ctrl+V to paste the copied email addresses into the new document.
  6. Save the new document with a name of your choice.

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   Report Post  
Posted to microsoft.public.word.docmanagement
Lisa Wilke-Thissen Lisa Wilke-Thissen is offline
external usenet poster
 
Posts: 123
Default How to extract email addresses from a word document

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   Report Post  
RodneyB RodneyB is offline
Junior Member
 
Posts: 0
Smile

Quote:
Originally Posted by Lisa Wilke-Thissen View Post
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
Hi Lisa

Thank you so much for the advice it worked perfectly and wow what a lot of time saved.

Best wishes

Rodney
  #5   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] joepappaly@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

Thank You. This saved my day.


  #6   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] bhawanisinghpharma@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

thanx a lot
  #7   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] shakya.deepak.in@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

Thank you Friend
  #8   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] ventas@peruwebs.net is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

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   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] urbanfair1@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

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   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] cfstrauck2@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

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   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] craigdanielmiller@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

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   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] anish@prasannapurple.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

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   Report Post  
Posted to microsoft.public.word.docmanagement
SafeTex SafeTex is offline
external usenet poster
 
Posts: 11
Default How to extract email addresses from a word document

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   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] blinded.by.science1@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

Sweeeet! Very helpful.
Update for MS Word 2016: 4. Find in - Main Document
  #15   Report Post  
shawn8 shawn8 is offline
Junior Member
 
Posts: 0
Default

Quote:
Originally Posted by Lisa Wilke-Thissen View Post
Hi Rodney,

I have been looking at away to extract
email addresses from a word documents.
Yahoo mail login


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
It works perfectly


  #16   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] airportquickconnection330@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

Try Free Demo: http://www.kmttech.com/microsoft-off...extractor.html
  #17   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] fromsovan@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

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   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] luke@bytestories.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

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   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] yashwanthbittu@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

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   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] vinod.mech2006@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

This saved my days... Thanks a lot


  #21   Report Post  
nolanchrist007 nolanchrist007 is offline
Junior Member
 
Posts: 0
Default

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   Report Post  
Posted to microsoft.public.word.docmanagement
[email protected] cawag98@gmail.com is offline
external usenet poster
 
Posts: 1
Default How to extract email addresses from a word document

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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to extract email addresses from a word document or htm web page? [email protected] Microsoft Word Help 26 April 21st 23 12:08 PM
N word, can I pull email addresses from the document then email? foureyesneenee Mailmerge 3 March 31st 08 09:02 PM
how do I extract addresses in word documents and create a database John B. Mailmerge 0 September 21st 05 02:22 AM
How do I extract email addresses from a word document? voss1111 Microsoft Word Help 1 August 1st 05 03:48 PM
How can I extract addresses from many word documents? Tony Microsoft Word Help 1 December 5th 04 01:04 AM


All times are GMT +1. The time now is 08:41 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"