Creating Macro in Dynamics GP

Creating Macro in Microsoft Dynamics GP

1. Open which screen you would to insert data and don’t insert any char [Example: HR-

--> Position]

2. Start Recording the Macro

3. Name your Macro

4. Start insertion of the data

5- Stop Macro Recording

2- Fill the Macro file with all required data for upload.

a- Open Macro created file with Microsoft Word

b- From Mailing Tab --- Select Recipients --> Use Existing List

c-Select Data Source [Pre- prepared File .XLS contains all required Data for each record]

d- if the excel sheet contains multiple sheets, select which tab contains the data

e- the Macro file code will be like below:

f- Highlight each screen filed and map it with data file sheet column form

g- Make the previous step for each filed of the screen.

h- At the End choose merge all form

Note: - the main Macro file pages will increased by number of XLs file data records.

i- Finally save that file as .TXT file the replace file extinction from .txt ---> .mac

3- Play the prepared Macro file to insert all data required.

a- Open Dynamics GP and close all windows

b- Open which screen you would to insert data and don’t insert any char [Example: HR-

--> Position]

d- Start Playing the Macro

The Macro will run with all the data inserted in the excel sheet till it finishes

Kindly Regards,

Dynamics GP