How can Mail Merge and Macro save your time and enhance the speed of your working.
Answers
Answer:
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. A macro can import hundreds of records in minutes and thousands of records in less than an hour. You will need three things to successfully import records using a mail merge macro:
the import file (generally in Excel)
the macro (or script) that illustrates the entering and saving of one record in code format
the ability to create a mail merge document in Word
Below are the detailed steps on how to create a macro, create the mail merge document and run the macro. This illustration applies specifically to Price Sheet Details but can be applied to nearly any window and set of data in Dynamics GP.
Open the window where you would manually input the data (in this case Inventory > Cards > Extended Pricing > Price Sheets > Price Sheet Detail Maintenance. When you are ready to start the macro go to Tools > Macro > Record > name the macro and save it to a folder where you can retrieve it. Manually enter one record into the window and Save. When you are have completed entering and saving one record go to Tools > Macro > Stop. This records the steps of processing one record and will be the foundation for the mail merge macro.
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. Unless you’ve downloaded this list directly from Dynamics GP validate that every item number in the list exists in Dynamics Dynamics GP (the macro will stop when it encounters an item that does not exist).
The price should be formatted to show dollars and cents WITHOUT the decimal.
The item numbers must match exactly to those in Dynamics GP
Sort the items by item number
Delete any unused rows at the end of the document
plz mark me as the brainlist