Print and delivery direct email Answered
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
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
Comments
5 comments
assuming you're sending directly from the sales order document :
SQL:SELECT t0.email from OHEM t0 WHERE t0.empID=$[$222.0.0]
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
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 !
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
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.