Slightly off-topic.. I'm currently using Dynamics GP accounting software; as a bypass to purchasing 3rd party software I use the Macro tools available to update records in bulk. I have a set of Invoices that need to go out monthly/quarterly/annually and range in the hundreds. This is very time consuming to manually input all of the data and a recorded macro is a huge time saver. I've put together a database in Excel which takes the data from one table and vlookups to several other tables to populate/concatenate into the predefined field of the macro text (similar to mailmerge process). Excel has character limitations with the syntax and ultimately I'd like to move away from it, but it looks like my other option is to build the tool within Access. Thoughs?
