Google Answers Logo
View Question
 
Q: embassies/consulates in the US ( Answered 5 out of 5 stars,   7 Comments )
Question  
Subject: embassies/consulates in the US
Category: Reference, Education and News > General Reference
Asked by: headsetsdotcom-ga
List Price: $45.00
Posted: 04 Jun 2002 07:37 PDT
Expires: 11 Jun 2002 07:37 PDT
Question ID: 20629
Question available for NETCRAZY-ga only, up until Midnight Eastern 
tonight, 6/3/2002.  If he doesn't take it by then it's open. Thanks! 
I want a text list of all 
(or substantially all) embassies/consulates in the US with the embassy 
name and full mailing address.  I want this as 
a text file that I can import into a database. I dont know if it can 
be downloaded from somewhere, or if someone needs to copy and paste 
the addresses from the lists available. 
 
PLEASE:  I don't want to know where to get it, I want someone to get 
it.  PLEASE be sure that you get clarification if you need it. I want to 
end up with the file itself as a result of this.
Answer  
Subject: Re: embassies/consulates in the US
Answered By: rebeccam-ga on 04 Jun 2002 09:25 PDT
Rated:5 out of 5 stars
 
Hi!

There is an official way and a 'creative' way to get the information
you're looking for in a text file.

1 - The Official Way:

It is available for purchase through embassy.org 
( http://www.embassy.org/ibc/lists.html ):

"The embassy.org site sells a list of contact information for the
foreign embassies of Washington D.C. in database form, suitable for
use in mail merge, fax broadcast, and other applications. Price for
the list is $40 (e-mail delivery) or $50 (delivery on PC-compatible
diskette)."

(This information is also available free in electronic form at
http://www.embassy.org/embassies/ )


2 - The Creative Way:

I'd be happy to cut and paste the information from the electronic
database into a text file in the format of your choice, and email it
to you.  Assuming you prefer that option, please request clarification
and let me know how you'd like the file, and where I can send it.

If you'd like any additional information, let me know... I'm happy to
help!


Additional resources:

There is an Adobe file called the Key Officers List, compiled by the
Bureau of Administration, available through the US Department of
State's site.

From http://www.state.gov/www/about_state/contacts/keyofficer_index.html
:

"The Key Officers Guide provides the names of key officers at Foreign
Service posts with whom American business representatives would most
likely have contact.”


I searched for:

us embassies ( ://www.google.com/search?sourceid=navclient&querytime=g&q=us+embassies
)

embassies in us ( ://www.google.com/search?sourceid=navclient&querytime=_N&q=embassies+in+us
)

us embassies contact list (
://www.google.com/search?sourceid=navclient&q=us+embassies+contact+list
)

Request for Answer Clarification by headsetsdotcom-ga on 04 Jun 2002 17:44 PDT
Rebeccam, thanks for taking this. YES, I want to end up with the file
itself.  Name and full mailing address as a text file that I can
import into a database.

Clarification of Answer by rebeccam-ga on 04 Jun 2002 18:11 PDT
I'm on it (creating a Directory in Word) and am also including phone &
fax, URL,  and email when available. If you'd specifically like NOT to
have that information, let me know & I can easily make the appropriate
changes.

One note - some of the Embassies are in New York or Maryland outside
DC.  So far I have included them... let me know if you'd like them
removed.

Last but not least, what email address should I send it to?  I should
be done tomorrow, Thursday at the latest.

Thanks!
Rebecca

Clarification of Answer by rebeccam-ga on 04 Jun 2002 20:08 PDT
I've got the file ready to go, and saved as an Excel text file. (If
you prefer another format, let me know.)

Let me know your email address and I'll get it to you!

Best,
Rebecca

Request for Answer Clarification by headsetsdotcom-ga on 05 Jun 2002 07:10 PDT
Rebeccam, I posted my address and google removed it.  Problem huh.
They said it was to protect my privacy, my email address is everywhere
on the web anyway. I mean, it would take much to work it out from my
google name anyway, so i'm not sure what the deal is.

Clarification of Answer by rebeccam-ga on 05 Jun 2002 08:45 PDT
Interesting...  Well, I sent it this morning to the general contact
address at what I guessed is your site. If you don't get it, let me
know!

Request for Answer Clarification by headsetsdotcom-ga on 06 Jun 2002 04:51 PDT
Rebeccam,  thanks. What was the exact file name?  I'll need to have it
forwarded to me.  I usually use mikef@

Can't wait to get it :-)  thanks!

Clarification of Answer by rebeccam-ga on 06 Jun 2002 08:54 PDT
The file is called Embassy Excel.xls;  I've sent it to your address as
well.

Many thanks for the interesting question (I was a bit under-informed
on this subject before, I must admit :)

Of course, if the file doesn't meet your needs of if you have any
questions, let me know!

Best,
Rebeccam
headsetsdotcom-ga rated this answer:5 out of 5 stars
Yes. Thank you. Perfect. Appreciate the work and meeting my specific needs. :-)

Comments  
Subject: Re: embassies/consulates in the US
From: netcrazy-ga on 04 Jun 2002 09:28 PDT
 
Hi,
You posted me a question with an incorrect date and I lost it. You
posted this question today saying that the question expires yesterday.
Bit confusing. I searched the question for you yesterday and had the
answer ready with me but since you posted the incorrect date today, it
got locked and I was not able to answer it.
Thanks anyway. If you need any other info, I'm still willing to work
for you. Ofcourse for a price.

Thanks
netcrazy
Subject: Re: embassies/consulates in the US
From: rebeccam-ga on 04 Jun 2002 10:04 PDT
 
I apologize for my part in the confusion... Netcrazy, if you have
additional information, or headsetsdotcom-ga if you prefer to work
with netcrazy, I'm open to any solution that will not adversely affect
my standing as a Researcher.
Subject: Re: embassies/consulates in the US
From: webadept-ga on 04 Jun 2002 10:29 PDT
 
No need to appologize rebeccam-ga. You gave a good answer on the
question. This isn't a closed area. Someone posts a question,
according to everything I've read, any of us can answer it, no
appology is nessesary for a researcher to answer a question on
Google-Answers.

If you hadn't had the question locked I would have answered.

webadept-ga
Subject: Re: embassies/consulates in the US
From: netcrazy-ga on 04 Jun 2002 11:23 PDT
 
Hi rebeccam,
That's ok. Its not your mistake. I'd have also done the same thing if
I were you. We are here to answer to our best without hurting anyone'e
feelings and in a professional manner.
You did a great job.
Cheers.
netcrazy
Subject: Re: embassies/consulates in the US
From: rebeccam-ga on 04 Jun 2002 11:56 PDT
 
Thanks for the comments, webadept & netcrazy... what a great community of people.
Subject: Re: embassies/consulates in the US
From: webadept-ga on 04 Jun 2002 12:23 PDT
 
You should try the forum.. just search through here to find it.
Subject: Re: embassies/consulates in the US
From: headsetsdotcom-ga on 04 Jun 2002 17:46 PDT
 
NetCrazy, sorry i put the same day's date.  :-(. I wanted you to get
it as you'd done some work on the pre-question.  My error. Thanks for
being so understanding.  If rebeccam doesn't want to copy/paste or
whatever is needed to get the file (that is the critical element for
me), then i'll defer to you.  Thanks All.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy