batch importing of mailing lists to Excel

  • Thread starter Thread starter bgsignal
  • Start date Start date
B

bgsignal

I've got a mailing list of around 1000 names, stored in both Word and
Entourage like this: First Name Last Name <e-mail address>
Once I’ve eliminated the < >, do I then have to individually copy & paste
(or type) all the info in three Excel columns? Or is there a simpler solution
for batch importing of mailing lists to the Excel spreadsheet?
 
bgsignal said:
I've got a mailing list of around 1000 names, stored in both Word and
Entourage like this: First Name Last Name <e-mail address>
Once I’ve eliminated the < >, do I then have to individually copy & paste
(or type) all the info in three Excel columns? Or is there a simpler solution
for batch importing of mailing lists to the Excel spreadsheet?
Click to expand...
 
You can paste the whole list into excel and then use Data->Text to Column
option to break it into columns.. There are a number of posts here - just
search for them if you need more information.
 
Back
Top