![]() |
#1
|
|||
|
|||
![]()
I have over 7,000 e-mails in a WORD document. Most of them are seperated by commas but not all. Some of them are on seperate lines, but some of them are part of paragraphs of emails that I copied and pasted into the document.
My question: how do I separate the e-mails out so each one is on it's own line with out doing it manually? There must be some automated way to do this.... |
#2
|
||||
|
||||
![]()
I assume you are talking about email ADDRESSES rather than emails.
A basic rule of email addresses is they cannot contain spaces or commas so you can use this to do a search and replace. Find [space] and replace with ^p (the code for a return (aka new paragraph)) Find [comma] and replace with ^p Find ^p^p and replace with ^p (this will get rid of empty paragraphs) |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error: general mail failure. Quit excel restart mail system | MitchellDM | Outlook | 1 | 12-19-2008 02:05 AM |
![]() |
dpool2002 | Outlook | 1 | 06-21-2006 02:11 PM |
Add date and time stamp to new mail and incoming mail | cadsmarter | Outlook | 0 | 02-02-2006 08:50 AM |