Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Getting email addresses out of a word document
Can anyone help me with getting email addresses out of a word document?
I just need to get the email addresses into Outlook, don't need names or anything, just the email addresses |
#2
|
|||
|
|||
G'day Dennis ,
Find and replace can be your friend here [A-Za-z0-9_.-]@\@[A-Za-z0-9_-]@.[A-Za-z0-9_-]@* will find simple email addresses, you may have to add to each cluster to get the effect you want. If your email addy's include a single space anywhere, this method will fail miserably. In chunks: [A-Za-z0-9_.-]@ any number of characters (the trailing @) from set of legal characters (between the sqaure brackets) A-Z, a-z, the numbers 0 through 9, and a few special characters. The period is used in this first section but not the others because we explicitly test for a period's presence in the domain name part of the address. This is the Mailbox id. \@ The \ denotes a literal, so we are looking for the @ symbol itself. [A-Za-z0-9_-]@.[A-Za-z0-9_-]* followed by something.something and whatever else (*) until the end of the word (). So a simple piece of VBA to find each one of them, read the range.text and do whatever with it. Now, I am not familiar with writing to the outlook contacts, so that would be best asked on an Outlook news group, and you can read the back issues of the free newsletter from www.editorium.com to achieve the necc code skeletons for a nice find and replace routine amongst other things. Steve Hudson - Word Heretic steve from wordheretic.com (Email replies require payment) Without prejudice Dennis reckoned: Can anyone help me with getting email addresses out of a word document? I just need to get the email addresses into Outlook, don't need names or anything, just the email addresses |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reveal Formating Code | Microsoft Word Help | |||
copying files from Wordperfect to Microsoft Word | New Users | |||
In typing dates in Word, i.e. "January 12" how do you keep the "1. | Microsoft Word Help | |||
Continuous breaks convert to next page breaks | Microsoft Word Help | |||
How to change merge forms from Word Perfect to Microsoft Word | Microsoft Word Help |