Importing Fedex Tracking Numbers

  • Thread starter Thread starter Dan Dan the OTTR Man
  • Start date Start date
D

Dan Dan the OTTR Man

Has anyone automated the importing of Fedex tracking numbers before?
How did you do it?
 
Dan Dan the OTTR Man said:
Has anyone automated the importing of Fedex tracking numbers before?
How did you do it?
Click to expand...

Where would you be importing them from? Once they are in Access, it is
relatively easy to get to the website, just by adding them to the URL
string. Here's one for UPS tracking:

"http://wwwapps.ups.com/etracking/tr...quiryNumber=T&HTMLVersion=4.0&InquiryNumber1="
& txtUPS

Where txtUPS is the tracking number. I usually copy and paste the tracking
number from an email. If the structure of FedEX is like that of UPS, you
could probably ready the emails looking for an 18 digit number:

Len("the string")=18

where the second letter is "Z"

Mid("the string",2,1) = "Z"
 
Back
Top