If you do not have the Project Communicator module registered, the Requisition Information Agent (RQ.RIA.00) screen connects directly to the email client installed on the computer where you run the Requisition Information Agent (RQ.RIA.00) screen. This is commonly referred to as MAPI. The Requisition Information Agent (RQ.RIA.00) screen does not insert records into the PJCommun table.
- Sends the e-mail to the e-mail address defined in the User Maintenance (95.260.00) screen for the approver.
If you have the Project Communicator module registered, the Requisition Information Agent (RQ.RIA.00) screen inserts the e-mail requests into the PJCommun table. To send the e-mails from the PJCommun table, you have the following three options:
1. Communicator to Mail (CO.MAL.00) screen
- Uses Outlook on the computer where you run the Communicator to Mail (CO.MAL.00) screen.
- Sends the e-mail to the e-mail address defined in the User Maintenance (95.260.00) screen for the approver.
2. SQL Mail trigger
919276 How to configure the Communicator trigger in Microsoft Dynamics SL to send messages by using the SQL Mail feature in SQL Server 2005
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;919276
- Uses Outlook on the computer where you have the Microsoft SQL Server installed.
- Sends the e-mail to the e-mail address defined in the User Maintenance (95.260.00) screen for the approver.
3. Database Mail trigger
2008576 How to configure the Communicator trigger in Microsoft Dynamics SL to send messages by using the Database Mail feature in SQL Server 2005 or SQL Server 2008
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;EN-US;2008576
- does not rely on outlook
- uses SMTP server
- Sends the e-mail to the e-mail address defined in the User Maintenance (95.260.00) screen for the approver.
http://msdn.microsoft.com/en-us/library/ms190413(SQL.90).aspx