Re: search email list to extract data in spreadsheet

2013-01-19 Thread Dave Watts
Why can't you just contact the college for the information? The main reason why I need to extract the information onto a spreadsheet is to save time (instead of doing it manually) - we work with several universities in the UK and store their information in our database - to promote our

Re: search email list to extract data in spreadsheet

2013-01-18 Thread Tom Small
Hi Attila, Thanks for your email and I should of been much clearer in my previous email. Hi John, Another questions - what if I wanted to extract information from a list of emails found on web (http://rg.kcl.ac.uk/staffprofiles/?by=A) and run some code that can extract details from each

Re: search email list to extract data in spreadsheet

2013-01-18 Thread Tom Small
Sorry about the first part of my previous email... ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: search email list to extract data in spreadsheet

2013-01-18 Thread J.J. Merrick
Tom, You would use CFHTTP to get the HTML and then parse the data from there. I will say that the website you sent is trying its best for you not to do what you are doing. If you look in the HTML it clearly has the email address javascript protected which doesn't mean you can't do it, it just

Re: search email list to extract data in spreadsheet

2013-01-18 Thread Tom Small
J.J, Thanks for your replay. The main reason why I need to extract the information onto a spreadsheet is to save time (instead of doing it manually) - we work with several universities in the UK and store their information in our database - to promote our product/services. You mentioned

search email list to extract data in spreadsheet

2013-01-17 Thread Tom Small
Hi, Can someone advise me on the following.. I want to know the best way to search through a list of emails and extract the information (e.g. first, address, position, address, etc) into an excel spreadsheet. Appreciate any advice on this issue. Tom

Re: search email list to extract data in spreadsheet

2013-01-17 Thread John M Bliss
Assuming you can get to the list via POP, this should do what you need: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f96.html On Thu, Jan 17, 2013 at 2:19 PM, Tom Small t...@re-base.net wrote: Hi, Can someone advise me on the following.. I

Re: search email list to extract data in spreadsheet

2013-01-17 Thread Tom Small
Hi John, Thanks for the link. Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: