"Jerry in Oklahoma" <sterlingoil@cableone.net> wrote in message
news:12tbco2mboeio5a@corp.supernews.com...
>
>
> Will pay for need help and occasional advise on using excel
>
> database
>
> " 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 dont want you to do this for free ... while i certainly
>
> appreciate your willingness to do it for free, i WANT to show my
>
> appreciation by paying something for this service .... and i will.
>
>
> i have queried the db online 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.... Here is what the 1st three entries look like
>
> in 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: sking@petroinvest.com
> 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: tallguy525@comcast.net
> 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 an excel sheet. 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.
>
> 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 ..... i would really like to have the entire db which would
>
> include all countries other than the United States.
>
> 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.
> is this too much to ask??
>
> Let me know,
>
> Thx,
>
> jerry

"Jerry in Oklahoma" <sterlingoil@cableone.net> wrote in message
news:12ti9iecitusv76@corp.supernews.com...
> sir ..i well understand everything you just said ... however, you have
> made quite an absurd assumption that i am wanting to do any or all of the
> things you mentioned ... i have no plans for any of your accusations ...
> not everyone is a short sided idiot.
> jerry