You can create a message format to send an email to you or a specified email address when an onlineorder is placed for a specific customer.
...
Go to Maintenance > Message Formats. See Message Formats (Classic Operations App) or Message Formats for more information.
Click the New button in the toolbar.
Enter a Format ID and Description.
In the General tab, select “Customer On Demand“ for Message type and enter a Return Email Address.
In the Advanced tab, check the Execute SQL Statement checkbox then enter and edit the following SQL.
Code Block language sql DECLARE @ORDERID DECIMAL(19,2) SET @ORDERID = [OrderID] -- IF THIS ORDER WAS CREATED BY EITHER RAPIDSHIP OR XINTERNET IF EXISTS(SELECT * FROM dbo.tblOrder WHERE ORDERID = @ORDERID AND (CSR LIKE 'Rapidship%' OR CSR LIKE 'Inet%')) BEGIN EXEC dbo.spInsertMailOutbox @ReturnEmailAddress = 'email@address.com', -- REPLACE THIS WITH A VALID RETURN EMAIL ADDRESS @ReturnName = 'CXT Software', -- REPLACE THIS WITH A VALID RETURN USERNAME @ToEmail = 'email@address.com', -- REPLACE THIS WITH A VALID TO EMAIL ADDRESS @Subject = 'Online order created for customer [CustID]', -- REPLACE THIS WITH WHAT EVER SUBJECT YOU WANT TO USE @Body = 'An online order, order id [OrderID] was created', -- REPLACE THIS WITH WHATEVER BODY YOU WANT TO USE. CAN USE AVAILABLE FIELDS. @CCEmailAddress = '', @Attachment = NULL, @AttachmentFileName = '' END
Optional. To also send an email to the customer enter the following:
In the General tab, enter a Message Subject.
In the Format tab, enter a message in Message Format.
Click OK or Apply.
...