BEGIN TRY
IF
(@button = 'ùìç èåôñ áéøåø öøëéí ìì÷åç') and (inserted.cancel_flag = 0)

and
(
inserted.INTRESTEDTODEPOSIT <> ''
and
inserted.CONTACT <> ''
and
inserted.GOREMIDKUN <> ''
and
inserted.OFENBIZUASICHA <> ''
and
inserted.EXPLAIN <> ''
and
inserted.AGREE_ADD_FRIENDS <> ''
and
inserted.HALSHINUI1 <> ''
and
inserted.HALSHINUI2 <> ''
and
inserted.HALSHINUI3 <> ''
and
inserted.HALSHINUI4 <> ''
and
inserted.HALSHINUI5 <> ''
and
inserted.HALSHINUI6 <> ''
and
inserted.ISSENT <> ''
and
inserted.HAMLAZA <> ''
and
inserted.SUTISFACTIONLEVEL <> ''
)

begin
BEGIN
    EXECUTE actMIViewRefresh;

    DECLARE @Merged_File_Name VARCHAR(128) = ISNULL(inserted.Contact,'') + '_' + REPLACE(CONVERT(VARCHAR, GETDATE(), 103), '/', '') + '_' + LEFT(REPLACE(NEWID(), '-', ''), 10);
    DECLARE @Merged_File_Path VARCHAR(2048) = '\\talent-srv\Talent\âåìãôìåñ\îñîëéí îîåæâéí\'
    DECLARE @Merged_Full_Path VARCHAR(2048) = @Merged_File_Path + @Merged_File_Name;
    DECLARE @Current_DATETIME DATETIME = GETDATE();

    DECLARE @Targeted_Mail_Address VARCHAR(256) =
                                                 CASE WHEN inserted.email_flag = 1
                                                        THEN (SELECT ISNULL(EMAIL,'office@talent-invest.co.il') FROM CONTACT1 WHERE CONTACT1.accountno = inserted.ACCOUNTNO)
                                                      ELSE 'office@talent-invest.co.il'
                                                 END;

    EXECUTE Common.actMailMerge(
                 TEMPLATENAME='\\talent-srv\GoldPlus\Reports\Templates\èåôñ òãëåï öøëéí ùðúé.doc'
                ,SAVELINK=1
                ,MERGEONLY=0
                ,SAVEDIRECTORY=@Merged_File_Path
                ,SAVEFILENAME=@Merged_File_Name
                ,PRINTING=0
                ,MAILSUBJECT='èåôñ òãëåï öøëéí ùðúé'
                ,MAILBODYEMPTY=1
                ,PRINTTOPDF=0
                ,REFRESHDATA=1
                ,MAILADDRESS=@Targeted_Mail_Address);


  END
  end

END TRY
BEGIN CATCH
   DECLARE @ErrorMessage VARCHAR(MAX) = ERROR_MESSAGE();
   EXECUTE Common.actGotoField(CAPTION=@ErrorMessage);

END CATCH