First of all please view the requirement video explanation
[login to view URL]
I am an online seller
I use skynet courier to ship out my items
We are currently manually adding/editing the skynet doket/waybill
using adobe acrobat XI 11.0.20 , to add the items that the buyer purchased to the waybill
What we currently do :
1) open up skynet doket /waybill
2) look in excel which contains the name of the buyer and product purchased and then manually editing by placing information of the items purchased for the specific buyer
I need a program/script that can automate this process.
Additional notes:
If the consignee name is not found in the excel – need to output error log at the end
If consignee name is found more than 1 times in the excel – do not process , need to output error log at the end
Download : the airwaybill and excel
[login to view URL]
Requirement of the automated program/script:
My operating system:
-Windows 10 pro
-Adobe acrobat XI 11.0.20
-Excel 2013