Print and delivery direct email

Answered

Comments

5 comments

  • Avatar
    Nadav Caridi

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

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

    Comment actions Permalink
  • Avatar
    Gpatellos

    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

     

    Comment actions Permalink
  • Avatar
    Nadav Caridi

    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 !

    Comment actions Permalink
  • Avatar
    Gpatellos

    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 

     

    Comment actions Permalink
  • Avatar
    Nadav Caridi

    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 

     

     

    Comment actions Permalink

Please sign in to leave a comment.