Automatic email from database and back (XML?)

J

Jan VdR

Hi everbody!

I am doing a final thesis project fro research in the air cargo
industry. For this I have to evaluate thousands of "air
waybill-numbers" (= awb's). If I email suc a number to a specified
emailadress, they reply to me with more details of that number, see
herefor: http://www.ccx.com/ccsi/email.html#anchor-xml
Now is the problem that I want to make some program or macro or
xml-thing by which it is possible that it automatically send all my
numbers to that address and automatically receive the details and put
these details in the same database, for example:
I have in Excel, column A with 40000 lines of awb's, is it possible
that a program send automatically an email to a (already known)
emailaddress, which automatically replies and is it then possible that
this reply comes in for example column B, C, D of Exel?

Thank you to anyone who had time to help me, doing this manually is
impossible, as you all understand!

Thx,

Jan
 
Top