Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-01-2017, 03:29 AM
zebedee398 zebedee398 is offline Need to extract e-mail addresses from lots of word documents Windows XP Need to extract e-mail addresses from lots of word documents Office 2010 64bit
Novice
Need to extract e-mail addresses from lots of word documents
 
Join Date: Dec 2017
Posts: 1
zebedee398 is on a distinguished road
Default Need to extract e-mail addresses from lots of word documents

Morning - I hope someone can help me?


I have about 1500 word documents in separate folders (grouped into about 10 sub-folders) and I need to extract e-mail addresses from each one.

Could someone help me with how I can run a macro which will:

Open the first sub folder, open the .doc file, extract the e-mail address, copy and paste that e-mail address to a new word document, place a semi-colon after the address in the new word document, close the .doc file, then open the next sub-folder and perform the same operation until it has gone through all the sub-folders.

I would like to end up with one word document with all 1500 e-mail addresses in if possible.

Can anyone help me with this? I've got a macro which will open the folder and extract the e-mail address but I can't get it to cycle through all sub-folders and I also can't get it to paste the e-mail addresses into the same word document.

Any help much appreciated.

Thank you
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
batch extract all tables in multiple word documents ZaidaBa Word Tables 3 05-08-2017 10:22 PM
Extract Data from Word Documents hiwire03 Word VBA 3 01-29-2016 09:19 PM
Need to extract e-mail addresses from lots of word documents How do I extract all my email addresses into one file? JohnFurter Outlook 3 05-16-2015 04:32 AM
Need to extract e-mail addresses from lots of word documents need to extract email addresses from excel files dunndealpr Excel 3 06-07-2013 08:29 AM
Need Help w/Mail Merge - Multiple Lots & 1 Owner - Don't want to send Duplicates dfwman Mail Merge 3 03-28-2013 07:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:31 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft