Informe aqui as instruções para a visualização do e-mail pelo destinatário.

Exemplo:

SELECT NTA.NTA_FILIAL,

NTA.NTA_COD,

CONVERT(VARCHAR(10),CONVERT(DATETIME,NTA.NTA_DTFLWP,112),103) NTA_DTFLWP,

NTA.NTA_USUINC,

NQS.NQS_DESC,

CONVERT(VARCHAR(4000), NTA.NTA_DESC) NTA_DESC,

CONVERT(VARCHAR(4000), NSZ.NSZ_DETALH) NSZ_DETALH,

NTA.NTA_CAJURI,

NSZ.NSZ_CCLIEN,

NSZ.NSZ_LCLIEN,

SA1.A1_NOME

FROM

NTAT10 NTA LEFT JOIN NQNT10

NQN ON (NTA.NTA_CRESUL = NQN.NQN_COD)

AND NQN.NQN_TIPO = '1'

AND NQN.D_E_L_E_T_ = ''

LEFT JOIN NQST10

NQS ON (NTA.NTA_CTIPO = NQS.NQS_COD)

AND NQS.D_E_L_E_T_ = '',

NSZT10 NSZ LEFT JOIN SA1T10

SA1 ON (NSZ.NSZ_CCLIEN = SA1.A1_COD

AND NSZ.NSZ_LCLIEN = SA1.A1_LOJA)

AND SA1.D_E_L_E_T_ = ''

WHERE NTA.NTA_FLAG01 = '1'

and NSZ.NSZ_FILIAL = NTA.NTA_FILIAL

and NSZ.NSZ_COD = NTA.NTA_CAJURI

and NSZ.NSZ_TIPOAS = '006'

and NTA.D_E_L_E_T_ = ' '

Informe a regra para destino.

Exemplo:

select NTA_COD,

RD0_NOME,

RD0_EMAIL

from NTAT10 NTA,

NTET10 NTE,

NSZT10 NSZ,

RD0T10 RD0

where NTA.NTA_FLAG01 = '1'

and NSZ.NSZ_FILIAL = NTA.NTA_FILIAL

and NSZ.NSZ_COD = NTA.NTA_CAJURI

and NSZ.NSZ_TIPOAS = '006'

and NTA.NTA_COD = NTE_CFLWP

and NTA.NTA_FILIAL = NTE_FILIAL

and NTE.NTE_CPART = RD0_CODIGO

and NTA.D_E_L_E_T_ = ''

and NTE.D_E_L_E_T_ = ''

and RD0.D_E_L_E_T_ = ''