Skip to content
logo Knowledgebase

Parameters - Notification - Test Email

Created on  | Last modified on 

Summary

Test Email on Sage 300 People

Description

 Test Email

Resolution

Step 1:

Log into Sage 300 People application with a Admin account.

Step 2:

Expand Parameters | Notifications | Mail server and then on the right complete SMTP details

Image

Step 3:

Under Mail definition type make sure the default from matches the default from mail server settings for all codes 

cid:image004.png@01D5C56F.8BA3D7B0

 

Step 4:

Then send a test email to an employee in the organization

Step 5:

Then log into SQL Management Studio and on the People Database right click and select New Query

Image 

The login credentials for SQL can be obtained from the IT department. 

Step 6:

In the New Query window copy and execute below and send us results

-------------------------SCRIPT---------------------------------

 

SELECT TOP 1000 [MailID]

      ,[MailFrom]

      ,[MailTo]

      ,[MailCC]

      ,[MailBCC]

      ,[MailSubject]

      ,[MailBody]

      ,[IsBodyHTML]

      ,[Status]

      ,[StartDate]

      ,[DateCreated]

      ,[Comment]

      ,[UserID]

      ,[LastChanged]

      ,[TMStamp]

  FROM [People].[Notification].[Mail]

 

  order by DateCreated desc 

 

-------------END OF SCRIPT TO BE COPIED-------------

Image