Create a macro to create Temporary Data and Mail on sheet

  • I want to mail branch data to all mail id mention for branch by creating a temp file with Branch Name and Delete Automatically after mail sent.Please help to correct the error occurred during run a macro. Subject and Body Text also mention in Mail Sheet so need to be take from there.

  • Try this. I haven't had time to test it


  • What error is occurring?


    Try this