| Author |
Message |
judyp
Forums Member
Joined: 14 Jul 2008
Posts: 25
|
#1 · Posted: 24 Aug 2008 17:47
Can somebody tell me what to do with a text file of leads that is formatted like this:
"Susan","Somebody","xxx@xxx.com","136 Maple St","Anytown","US","00000","","7/26/2008 8:37","","","","","157.42.667","","","","","","","","",
What do I need to get the email addresses out of the text file and into my email list?
__________________
|
Vishal P. Rao
Joined: 23 Jun 2005
Posts: 1322
|
#2 · Posted: 25 Aug 2008 09:06
You can easily import the data into a spreadsheet application like MS Excel.
Data > Import External Data > Import Data
I'm not sure but you might be able to do it using Open Office too (free).
__________________
|
Newbie Shield
Joined: 22 Sep 2007
Posts: 2226
|
#3 · Posted: 25 Aug 2008 10:33
Hi Judy,
It looks like one of two things to me:
1. A generic sample rather than information about an individual.
2. An encrypted file.
If it is a generic sample file, it's worthless.
If it is an encrypted file, you may have to port to a program that can read and translate encrypted information. You'll have to do a Google search to see what serves your budget and technical expertise.
Sounds to me like something no one should be messing with. I recommend against tampering.
Careful what you crack (media thinks it's "hack") as there may be legal consequences.
~Newbie Shield~
|
pcwork
Forums Member
Joined: 12 Aug 2006
Posts: 1650
|
#4 · Posted: 26 Aug 2008 03:05
Contact the company providing the leads, they should be able to help
__________________
|
judyp
Forums Member
Joined: 14 Jul 2008
Posts: 25
|
#5 · Posted: 26 Aug 2008 03:11
I don't have a spreadsheet but I found out somewhat by accident that I can import the file into Outlook Express. Thanks for all the responses!
__________________
|
Newbie Shield
Joined: 22 Sep 2007
Posts: 2226
|
#6 · Posted: 30 Aug 2008 13:50 · Edited by: Newbie Shield
Judy,
You can download Open Office for free and use their spreadsheet program. It's similar to MS Excel. Your file could very well be a CSV file. In that case, it will open in a spreadsheet program.
It would be more useful in a spreadsheet program than in MS Outlook Express. You can play around with it quite a bit in the spreadsheet program.
Let us know if it works and good luck,
~Newbie Shield~
|
