Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers,"
|
|||
|
|||
Will pay for need help and occasional advise on using excel ....
"sorry if this is off post ...will be my last" Thx in advance for your help and interest. i am an independant oil and gas consultant and have a fair amount of computer experience but, am absolutely lost when it comes to data bases .... i found a database online (in .php format) that contains names, addresses, phone numbers, fax numbers and email addresses of companies and people within the oil and gas industry ... i want to be able to utilize this db in excel so i can sort certain companies or people and use excels "mail merge" system to send them emails. i WANT to show my appreciation by paying something for this service .... and i will. i have queried the online db for all entries located within the united states and received over 70,000 entries .... i then copied and pasted them to microsoft word ... it is now 174 pages (840KB) .. i have it saved to a file ... i can send a copy of this WORD attachment.... ( Update Note: i have found that my 840KB word document only contain around 560 entries ... well short of the 70,000 .... i assume that perhaps the server went down while downloading ..... i did get some messages about not having enough memory. ) Here is what the 1st three entries look like when copied and pasted from Word; "Company: PetroInvest LLC Map It from MapQuest! Map It from Google! What's the Weather Like? Phone to Google! Fax to Google! Industry: Web based exchange linking private placement drilling programs with securities broker-dealers and qualified institutional investors. Department: Division / Booth: Position: President Lastname, Firstname: King, Steven Phone: 713-667-5692 Fax: Email: Address Line 1: 2222 Maroneal Street Address Line 2: Suite 1517 City, State/Province Zipcode: Houston, TX 77030 Country: USA Website: www.petroinvest.com Company: B & B Resourses Map It from MapQuest! Map It from Google! What's the Weather Like? Phone to Google! Fax to Google! Industry: Investor opertor oil gas Department: Division / Booth: Position: Owner Lastname, Firstname: Barrow, Chuck Phone: 918-495-1128 Fax: 918-495-0537 Email: Address Line 1: 3637 east 67th Street Address Line 2: City, State/Province Zipcode: Tulsa, Ok 74136 Country: Website: Company: Thomas Family Trusts Map It from MapQuest! Map It from Google! What's the Weather Like? Phone to Google! Fax to Google! Industry: Private investor in royalties and working interests. Department: Division / Booth: Position: Trustee Lastname, Firstname: Thomas, Greg Phone: 904-287-7689 Fax: Email: Address Line 1: PO Box 600755 Address Line 2: City, State/Province Zipcode: Jacksonville, FL 32260 Country: USA Website: " What i'd like to be able to do; 1.) I would like all info put into excel. I would like each of the following categories in its own column so the db can be sorted by one or more of them; Company: Industry: Department: Division / Booth: Position: Lastname, Firstname: Phone: Fax: Email: Address Line 1: Address Line 2: City, State/Province Zipcode: Country: Website: 2.) I would like both the email addresses and the website addresses to remain as active links as they are in the WORD format as well as the online db. 3.) Please note "Lastname and Firstname" are in the same category (column) .. I would like to separate them into 2 different categories (columns). 4.) Please note "City, State/Providence Zipcode" are in the same category (column) .. I would like to separate them into 3 different categories (columns). It would be great to be able to sort the db with "City", "State", and "Zipcode". 5.) Also, i am enclosing the link to the website that contains the full db ...( http://eeea.org/subscribe.htm ) in order to view it or download it, you will need to sign up for a free 5 day trail which gives full access ..... i would really like to have the entire db which would include all countries other than the United States or in the alternative, all U.S. entries (70,000 plus) would be fine. 6.) You will note every entry contains a live link with the following; "Map It from MapQuest! Map It from Google! What's the Weather Like? Phone to Google! Fax to Google!" These would all need to be globally taken out of the db. In closing, I want to be able to open up the db in excel, sort by one or more categories and use excels "mail merge" feature to send the same email to all those queried. Please let me know if you might be interested in this project or require any further information. Thx, jerry |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Will pay for need help and occasional advise on using excel ....
Check your other posts.
Jerry in Oklahoma wrote: "sorry if this is off post ...will be my last" Thx in advance for your help and interest. i am an independant oil and gas consultant and have a fair amount of computer experience but, am absolutely lost when it comes to data bases .... i found a database online (in .php format) that contains names, addresses, phone numbers, fax numbers and email addresses of companies and people within the oil and gas industry ... i want to be able to utilize this db in excel so i can sort certain companies or people and use excels "mail merge" system to send them emails. i WANT to show my appreciation by paying something for this service .... and i will. i have queried the online db for all entries located within the united states and received over 70,000 entries .... i then copied and pasted them to microsoft word ... it is now 174 pages (840KB) .. i have it saved to a file ... i can send a copy of this WORD attachment.... ( Update Note: i have found that my 840KB word document only contain around 560 entries ... well short of the 70,000 .... i assume that perhaps the server went down while downloading .... i did get some messages about not having enough memory. ) Here is what the 1st three entries look like when copied and pasted from Word; "Company: PetroInvest LLC Map It from MapQuest! Map It from Google! What's the Weather Like? Phone to Google! Fax to Google! Industry: Web based exchange linking private placement drilling programs with securities broker-dealers and qualified institutional investors. Department: Division / Booth: Position: President Lastname, Firstname: King, Steven Phone: 713-667-5692 Fax: Email: Address Line 1: 2222 Maroneal Street Address Line 2: Suite 1517 City, State/Province Zipcode: Houston, TX 77030 Country: USA Website: www.petroinvest.com Company: B & B Resourses Map It from MapQuest! Map It from Google! What's the Weather Like? Phone to Google! Fax to Google! Industry: Investor opertor oil gas Department: Division / Booth: Position: Owner Lastname, Firstname: Barrow, Chuck Phone: 918-495-1128 Fax: 918-495-0537 Email: Address Line 1: 3637 east 67th Street Address Line 2: City, State/Province Zipcode: Tulsa, Ok 74136 Country: Website: Company: Thomas Family Trusts Map It from MapQuest! Map It from Google! What's the Weather Like? Phone to Google! Fax to Google! Industry: Private investor in royalties and working interests. Department: Division / Booth: Position: Trustee Lastname, Firstname: Thomas, Greg Phone: 904-287-7689 Fax: Email: Address Line 1: PO Box 600755 Address Line 2: City, State/Province Zipcode: Jacksonville, FL 32260 Country: USA Website: " What i'd like to be able to do; 1.) I would like all info put into excel. I would like each of the following categories in its own column so the db can be sorted by one or more of them; Company: Industry: Department: Division / Booth: Position: Lastname, Firstname: Phone: Fax: Email: Address Line 1: Address Line 2: City, State/Province Zipcode: Country: Website: 2.) I would like both the email addresses and the website addresses to remain as active links as they are in the WORD format as well as the online db. 3.) Please note "Lastname and Firstname" are in the same category (column) .. I would like to separate them into 2 different categories (columns). 4.) Please note "City, State/Providence Zipcode" are in the same category (column) .. I would like to separate them into 3 different categories (columns). It would be great to be able to sort the db with "City", "State", and "Zipcode". 5.) Also, i am enclosing the link to the website that contains the full db ...( http://eeea.org/subscribe.htm ) in order to view it or download it, you will need to sign up for a free 5 day trail which gives full access ..... i would really like to have the entire db which would include all countries other than the United States or in the alternative, all U.S. entries (70,000 plus) would be fine. 6.) You will note every entry contains a live link with the following; "Map It from MapQuest! Map It from Google! What's the Weather Like? Phone to Google! Fax to Google!" These would all need to be globally taken out of the db. In closing, I want to be able to open up the db in excel, sort by one or more categories and use excels "mail merge" feature to send the same email to all those queried. Please let me know if you might be interested in this project or require any further information. Thx, jerry -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Will pay for need help and occasional advise on using excel .... | Excel Discussion (Misc queries) | |||
Will pay for need help and occasional advise on using excel .... | Setting up and Configuration of Excel | |||
Will pay for need help and occasional advise on using excel .... | Excel Discussion (Misc queries) | |||
Protecting Excel Worksheets..Advise Please... | Excel Discussion (Misc queries) | |||
Summing a Range Omitting the Occasional #N/A | Excel Worksheet Functions |