Send an automatic email to business partner when i create a new service call

[Former Member]

HI,

I NEED TO SEND AN EMAIL TO BUSINESS PARTNER AN AUTOMATIC WHEN I CREATE A NEW SERVICE CALL

I USE SAP BUSINESS ONE 8.82 PL 15

THANKS..

[Former Member · Accepted solution]

Jorge,

Revisa este post estoy seguro que te ayudara con lo que necesitas

Saludos,

Iván Fernando Vanegas

[Former Member · Accepted solution]

Ivan muchas gracias, lo reviso!!

[Former Member · Accepted solution]

Ivan,

No lo tengo muy claro aun, podrias compartirme tu SP para revisarlo y adaptarlo a mi proceso por favor

Mil Gracias.

[Former Member · Accepted solution]

Ivan te adjunto mi código del SP me emite el msg de error:

" Msg 14607, Level 16, State 1, Procedure sysmail_verify_profile_sp, Line 42

profile name is not valid

(1 row(s) affected)"

Me arroja un valor 0.

Adjunto mi codigo del SP:

USE ["MiBase de Datos"]

GO

/****** Object:  StoredProcedure [dbo].[Emails_send]    Script Date: 04/14/2015 13:35:59 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[Emails_send]

AS BEGIN

EXEC msdb.dbo.sp_send_dbmail

@profile_name ='MyMailAccount', (Asi se llama el perfil en donde esta config mi mail)

@recipients ='jgonzalez@dominio.com.mx',

@subject ='Orden de Servicio',

@body ='Llamada de Servicio',

@query ='SELECT T0.[ItemCode], T0.[ItemName], T0.[FrgnName]FROM OITM T0 WHERE T0.[ItemCode]= ZF122SM02IDQ',

@attach_query_result_as_file = 1, @query_result_separator =';',

@query_result_no_padding = 1, @exclude_query_output = 1,

@query_result_header = 1,@query_attachment_filename ='LlamadaServicio.pdf'

END