How to Import Email Addresses into Dynamics GP for the E-mail Suite
Create the data in excel and save the data as an xlsx as shown below:
Save the Excel file as a Comma Delimited (*.csv) file. You can use file names and locations of your choice.
Within Dynamics GP navigate to Tools > Integrate > Table Import
Create the Table Import Definition as shown below, and save it.
For Source File browse to the csv file you saved in the previous steps
When you are ready to load the data, click on the Import button.
If you would like to review the results in SQL, run the following select statement for the company database.
SELECT * FROM SY01200 WHERE Master_Type=”EMP”
You can also open the Employee Maintenance window and select the Internet Information option to view the email address attached to the employee.
Last Review: February 2, 2015 – Revision: 1.0
- Employee E-Mail Suite Microsoft Dynamics GP 2015
- Employee E-Mail Suite Microsoft Dynamics GP 2013
- Employee E-Mail Suite Microsoft Dynamics GP 2010