Spreadsheet: 841816d1693970227-excel-formula-for-sending-email-excel-email
Sheet: Sheet1

 | Kindly asking for excel formula  with no macros to send about 550 academic student reports. Reports are not identical.
1 | BG High School
 | P.O. 1584, Bulawayo
 | ZIMBABWE
 | Tel:
 | ACADEMIC PROGRESS REPORT
 | BHA234 | Name | IBDO ALEX
 |  | [NAME] | [EMAIL]
 |  | Form | 1 A
 | School Fees Balance
 | END OF SECOND TERM 2023
 | Number of subjects recorded: | 9 | Passed : | 8
 | Subject | Class Average (%) | Actual Mark (%) | Grade | Teacher’s Comment | Signature
 | Mathmatics | 53 | 97 | A | Excellent performance | [NAME]
 | Accounting | 60 | 80 | A | This is good performance. | [NAME]
 | Agriculture | 66 | 49 | D | Work hard | [NAME]
 | Biology | 62 | 90 | A | This is a splendiferous performance | [NAME]
 | B.Studies | 54 | 70 | B | Work hard | A. Mpala
 | English | 66 | 86 | A | A hardworking student | [NAME]
 | Geography | 61 | 93 | A | Good work | A. Mpala
 | FRS | 70 | 98 | A | Excellent work | [NAME]
 | Woodwork | 50 | 80 | A | Best student | [NAME]
 | BG High School
 | THIS IS AN AUTHORIZED DIGITAL STAMP
 | DATE: 02/09/23
 | TEL:
 | Issued without alterations
2 | BG High School
 | P.O. 1584, Bulawayo
 | ZIMBABWE
 | Tel:
 | ACADEMIC PROGRESS REPORT
 | BHA234 | Name | POST MAN
 |  | [NAME] | [EMAIL]
 |  | Form | 1 A
 | School Fees Balance
 | END OF SECOND TERM 2023
 | Number of subjects recorded: | 5 | Passed : | 5
 | Subject | Class Average (%) | Actual Mark (%) | Grade | Teacher’s Comment | Signature
 | Mathmatics | 53 | 50 | C | Better | [NAME]
 | Accounting | 60 | 71 | B | This is good performance. | [NAME]
 | Agriculture | 66 | 49 | D | Bad | [NAME]
 | Biology | 62 | 90 | A | This is a splendiferous performance | [NAME]
 | B.Studies | 54 | 70 | B | Work hard | A. Mpala
 | BG High School
 | THIS IS AN AUTHORIZED DIGITAL STAMP
 | DATE: 02/09/23
 | TEL:
 | Issued without alterations
3 | BG High School
 | P.O. 1584, Bulawayo
 | ZIMBABWE
 | Tel:
 | ACADEMIC PROGRESS REPORT
 | BHA234 | Name | [NAME]
 |  | [NAME] | [EMAIL]
 |  | Form | 1 A
 | School Fees Balance
 | END OF SECOND TERM 2023
 | Number of subjects recorded: | 9 | Passed : | 8
 | Subject | Class Average (%) | Actual Mark (%) | Grade | Teacher’s Comment | Signature
 | Mathmatics | 53 | 77 | A | Good work | [NAME]
 | Accounting | 60 | 60 | B | Good work | [NAME]
 | Agriculture | 66 | 49 | D | Work hard | [NAME]
 | Biology | 62 | 90 | A | This is a splendiferous performance | [NAME]
 | B.Studies | 54 | 70 | B | Work hard | A. Mpala
 | English | 66 | 86 | A | A hardworking student | [NAME]
 | Geography | 61 | 93 | A | Good work | A. Mpala
 | FRS | 70 | 98 | A | Excellent work | [NAME]
 | Woodwork | 50 | 80 | A | Best student | [NAME]
 | BG High School
 | THIS IS AN AUTHORIZED DIGITAL STAMP
 | DATE: 02/09/23
 | TEL:
 | Issued without alterations
4 | BG High School
 | P.O. 1584, Bulawayo
 | ZIMBABWE
 | Tel:
 | ACADEMIC PROGRESS REPORT
 | BHA234 | Name | HAPPY EATER
 |  | [NAME] | [EMAIL]
 |  | Form | 1 A
 | School Fees Balance
 | END OF SECOND TERM 2023
 | Number of subjects recorded: | 3 | Passed : | 3
 | Subject | Class Average (%) | Actual Mark (%) | Grade | Teacher’s Comment | Signature
 | Mathmatics | 53 | 40 | D | BAD | [NAME]
 | Accounting | 60 | 45 | D | BAD | [NAME]
 | Agriculture | 66 | 49 | D | Work hard | [NAME]
 | BG High School
 | THIS IS AN AUTHORIZED DIGITAL STAMP
 | DATE: 02/09/23
 | TEL:
 | Issued without alterations