Want to parse 5,000 Emails from a Word doc and list them in Excel

[LikeThisName]

Can some one point me in the right direction.

 

[LikeThisName]

Let me break this down simpler.

i want to parse a document, seperating each email address found by using a new line as the deliminator.

i know how to open a file.
i know how to write to a file.

can someone explain or point me to a good reference on how to search and extract the email addresses using VBA.

thanks

 

[RobBroekhuis]

So your word doc does not contain "e-mails", it contains e-mail addresses? Why not just paste the contents of the word document right into Excel?
Rob

 

[LikeThisName]

yes rob, but to do it manually would be extremely tedious.

if u want to see what i wanted u can look at or download the trial of Extract Link 2.3

http://www.spadixbd.com/elink/

I purchased it for the $39. it did what i needed.

though my soultion is solved, it would be nice to know how the application i purchased does this.

It would be nice to add a button that does this for me on the menu bar. and just parses what ever document i have open.

let me know if you have suggestions. thanks

 

[LikeThisName]

its the parsing i need help with.

 

[RobBroekhuis]

I think we still need more information. Do you have a word document that consists solely of e-mail addresses, or a document with an address here and there, where you are trying to identify the format of a typical e-mail address?
If the former, it is as simple as copying and pasting the whole word document - and you can easily do this using VBA code. If it's the latter, you can still do it - but it would be helpful to know the expected structure of the word document.
Rob

 

[LikeThisName]

Thanks Rob, actually its a document that is really long with all sorts of information about people, members in fact.

What I'd like to do is to parse the email addresses, it could mean deleting anything thats not an email address, from the document or copying/writing the email address to another file.

what im trying to do may be fairly easy, im just to knew to this kind of thing, the parsing that is.

 

[RobBroekhuis]

Your original post suggested that e-mail addresses would be on lines by themselves ("newline as delimiter&quot. If this is true, then it would make things a lot easier. Let us know. Rob

 

[SkipVought]

Hey, we need a little help here LTN. What does your source data look like? Parsing can be quite simple of very complex, depending on the nature of the data and how consistant (or NOT) it is, what distinguishes the data groups etc. Skip,
Skip@theofficeexperts.com

 

[LikeThisName]

You guys are great. The reason my description was so vague was I was actually helping a friend solve a problem, i never saw the data, but we solved shortly after i posted here.

There is a great application I downloaded I think it was $25-$50, when I come across the link I'll post it. There is a trial version. Hopefully I can repost, a specific question when I get to see the data, even though I purchased a solution I'd like to be able to write something of my own.

You all are awesome though, and Im going to make a donation to this site, and I hope this site helps you as much as you guys help me from time to time. I love how people are eager to share knowledge and better / alternative ways of approaching things.