Print and delivery direct email

Answered

George Patellos (END CUSTOMER)

• March 11, 2020 02:04

Need the dynamic syntax on assigning the document;s owener's email to the Direct email option.

Basically we need to be able to email the Sales Order document to the  owner of the sales order 

 

Vote

0

• 

  Nadav Caridi

  • March 11, 2020 20:34

  assuming you're sending directly from the sales order document :

  SQL:SELECT t0.email from OHEM t0 WHERE t0.empID=$[$222.0.0]
• 

  George Patellos (END CUSTOMER)

  • March 13, 2020 15:40

  I tried that I entered to the direct mail as stated above. To confirm the $[$222,0,0] refers to the ownercode field on the SO document. The line entered is as below. using smtp server that works if I enter an email on the direct email field

  

  but when I apply the SQL statement i get error

   

  
• 

  Nadav Caridi

  • March 13, 2020 23:44

  Oh my bad :)

  you're probably getting the actual owner name this way, try to supply the table syntax instead 

  e.g. 

  $[ORDR.OwnerCode]

   

  Good luck !
• 

  George Patellos (END CUSTOMER)

  • March 16, 2020 15:21

  Thank you for the feedback. It worked. On another note do you happen to know how I can select a different layout to print based on type ? ex: PO have a item type and service type and have different layouts 

   
• 

  Nadav Caridi

  • March 16, 2020 20:11

  Sorry never played with that. 

  you can try to use the UI to click the different menus , again no experience with that . (with the Activate(522) methods)

  another option I'm using for something completely different (if you're using crystal report layouts) : you can set up a a button that select a proper crystal report according to your filter . and prints it (?) 

  Good luck 

   

   

Please sign in to leave a comment.