Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Will pay for need help and occasional advise on using excel ....


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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Will pay for need help and occasional advise on using excel ....

You have replies to your other last posts.

Jerry in Oklahoma wrote:

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


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default Will pay for need help and occasional advise on using excel ..

cut the man a break - he posted all over the place - where are YOU referring
to?

--
Regards,
Tom Ogilvy


"Dave Peterson" wrote:

You have replies to your other last posts.

Jerry in Oklahoma wrote:

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


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Will pay for need help and occasional advise on using excel ..

All over the place is right. IIRC, he's got at least 3 real responses that I've
seen.

I'm sure he'll find them when he goes back to check all his messages for
responses.

Or he (and you) could use google to search for his messages and replies.

Tom Ogilvy wrote:

cut the man a break - he posted all over the place - where are YOU referring
to?

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote:

You have replies to your other last posts.

Jerry in Oklahoma wrote:

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


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Will pay for need help and occasional advise on using excel ..

I suppose I could, but it would be nicer if you were specific <g

I wanted to read what your offering was, but maybe you were just being
helpful.

--
Regards,
Tom Ogilvy


"Dave Peterson" wrote in message
...
All over the place is right. IIRC, he's got at least 3 real responses
that I've
seen.

I'm sure he'll find them when he goes back to check all his messages for
responses.

Or he (and you) could use google to search for his messages and replies.

Tom Ogilvy wrote:

cut the man a break - he posted all over the place - where are YOU
referring
to?

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote:

You have replies to your other last posts.

Jerry in Oklahoma wrote:

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

--

Dave Peterson


--

Dave Peterson





  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Will pay for need help and occasional advise on using excel ..

I was trying to be helpful to others so they wouldn't take the time to offer the
same suggestions--I didn't offer any suggestions to the OP.

There were quite a few of those "last" posts, though.

Tom Ogilvy wrote:

I suppose I could, but it would be nicer if you were specific <g

I wanted to read what your offering was, but maybe you were just being
helpful.

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
All over the place is right. IIRC, he's got at least 3 real responses
that I've
seen.

I'm sure he'll find them when he goes back to check all his messages for
responses.

Or he (and you) could use google to search for his messages and replies.

Tom Ogilvy wrote:

cut the man a break - he posted all over the place - where are YOU
referring
to?

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote:

You have replies to your other last posts.

Jerry in Oklahoma wrote:

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

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Will pay for need help and occasional advise on using excel .... Jerry in Oklahoma Excel Discussion (Misc queries) 1 February 19th 07 06:23 PM
Will pay for need help and occasional advise on using excel .... Jerry in Oklahoma New Users to Excel 1 February 19th 07 02:45 PM
Will pay for need help and occasional advise on using excel .... Jerry in Oklahoma Excel Worksheet Functions 3 February 19th 07 02:41 PM
Will pay for need help and occasional advise on using excel .... Jerry in Oklahoma Setting up and Configuration of Excel 1 February 19th 07 02:22 PM
Will pay for need help and occasional advise on using excel .... Jerry in Oklahoma Excel Discussion (Misc queries) 1 February 19th 07 11:48 AM


All times are GMT +1. The time now is 10:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"