KB02-001

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:

Import Email Image 1
Save the Excel file as a Comma Delimited (*.csv) file. You can use file names and locations of your choice.

Import Email Image 2


Within Dynamics GP navigate to Tools > Integrate > Table Import

Import Email Image 3

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.

Import Email Image 4

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”

Import Email Image 5

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

Applies To:         

  • Employee E-Mail Suite Microsoft Dynamics GP 2015
  • Employee E-Mail Suite Microsoft Dynamics GP 2013
  • Employee E-Mail Suite Microsoft Dynamics GP 2010