Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
  
Concatenate Data From Table to Existing Text
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?
ID
1004
Category
Other
Author

Steven O'Quinn
Date Created
4/23/2016 12:58:08 PM
Date Updated
4/23/2016 12:58:08 PM
Status
New Idea
Score
10
Promoted By
Steven O'Quinn
Feedback
 
Back to Search Results