Hi

I'm new to Sage ERP 300.  I need to import shipments from another program daily.  I exported a shipment entry example and created a database in MS Access that reads the file from the other program and puts it into the correct fields in the csv file for import into sage.  All works perfectly but now I need to open these shipments, click create invoice and post it.  So this I want to do with a macrob.  I'm failry confident with VBA so I'm sure I'll figure it out.  

My question is how do I link an external list with the shipment numbers to use in the macro, so that I can tell the macro what Shipment numbers to open and post?