Need VBA to Re-Define Code the mail stuts and next reporting dt

Dear experts

I have different sheet with email popup data field, where as To,CC,Subject , Body and attachment, i want vba code re define

i want update email send status once send email i want update in sheet Index I8,I9,... instead of correspoding sheet F:F,

i want update of next reporting date in column J:J as per week,month,day in Col F:F

i want make changes in code at

Please Login or Register  to view this content.

find the attachment