Prior to creating the macro prepare an excel file with a list of the Item Numbers, Unit of Measures and the Net Prices you want to import into the price sheet.
This illustration applies specifically to Price Sheet Details but can be applied to nearly any window and set of data in Dynamics GP. the ability to create a mail merge document in Wordīelow are the detailed steps on how to create a macro, create the mail merge document and run the macro.the macro (or script) that illustrates the entering and saving of one record in code format.You will need three things to successfully import records using a mail merge macro: A macro can import hundreds of records in minutes and thousands of records in less than an hour. Have you ever needed to import thousands of records that can’t be done using Integration Manager? And have you thought to yourself “how am I ever going to get all of this data into the system without manual entry or a SQL expert?” Well there is another option – a mail merge macro! A mail merge macro is nothing more than a script that mimics the manual entry of data repetitively until all records have been entered and saved.
