Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-23-2010, 09:16 AM
daryl daryl is offline Mass e-mail seperation Mac OS X Mass e-mail seperation Office 2003
Novice
Mass e-mail seperation
 
Join Date: Mar 2010
Posts: 1
daryl is on a distinguished road
Default Mass e-mail seperation


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....
Reply With Quote
  #2  
Old 03-23-2010, 03:45 PM
Guessed's Avatar
Guessed Guessed is offline Mass e-mail seperation Windows Vista Mass e-mail seperation Office 2007
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
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
Mass e-mail seperation Mass attachment downloads? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:07 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