BEGIN TRY
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 TRY
BEGIN CATCH
   DECLARE @ErrorMessage VARCHAR(MAX) = ERROR_MESSAGE();
   EXECUTE Common.actGotoField(CAPTION=@ErrorMessage);

END CATCH