Spreadsheet: 739922d1626087945-calculating-data-from-several-columns-based-on-separate-months-spreadsheet-bit
Sheet: 2021-MailMerge

Project Id | Project Last Published | Project Title | Project Town | Project Value | Role | Company Id | Company Name | Company Phone | Company Email | Person Id | Person Forename | Person Surname | Person Email | Tag | Month | Sent | Brouchure | Reaction | Email Address Used | [NAME] | Tender No.
12355328 | 2021-02-09 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 7299092 | Text | Text | [NAME] | 60521 | 5 | 2021-05-14 00:00:00 | Text |  | Personal
12542792 | 2021-05-07 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 7009793 | Text | Text | [NAME] | 130521 | 5 | 2021-05-14 00:00:00 | Text | Out of Office | Personal
12442890 | 2021-04-29 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] | 7299234 | Text | Text | [NAME] | 60521 | 5 | 2021-05-14 00:00:00 | Text |  | Personal
12567863 | 2021-05-14 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 6020001 | Text | Text | [NAME] | 27052021 | 5 | 2021-05-27 00:00:00 | Text |  | Personal
12256278 | 2021-05-07 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] | 6889277 | Text | Text | [NAME] | 60521 | 5 | 2021-05-14 00:00:00 | Text |  | Personal | [NAME] | T:7649
12517834 | 2021-03-11 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] | 6799151 | Text | Text | [NAME] | 60521 | 5 | 2021-05-14 00:00:00 | Text |  | Personal
12172741 | 2021-06-04 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 6902769 | Text | Text | [NAME] | 100621 | 6 | 2021-06-11 00:00:00 | Text |  | Personal
12172741 | 2021-06-04 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] | 7389685 | Text | Text | [NAME] | 100621 | 6 | 2021-06-11 00:00:00 | Text |  | Personal | Added to Tender List
12508936 | 2021-06-22 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] | 6943555 | Text | Text | [NAME] | 240621 | 6 | 2021-06-25 00:00:00 | Text |  | Company
12508936 | 2021-06-22 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 7064970 | Text | Text | [NAME] | 240621 | 6 | 2021-06-25 00:00:00 | Text |  | Personal
12510112 | 2021-06-21 00:00:00 | Text | Text | Figure | Project Manager | Figure | Text | Number | [NAME] |  | Text | Text | [NAME] | 240621 | 6 | 2021-06-25 00:00:00 | Text |  | Company | [NAME]
12510112 | 2021-06-21 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 7009793 | Text | Text | [NAME] | 240621 | 6 | 2021-06-25 00:00:00 | Text | Read | Personal
12510112 | 2021-06-21 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 7177798 | Text | Text | [NAME] | 240621 | 6 | 2021-06-25 00:00:00 | Text |  | Personal
12510112 | 2021-06-21 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] | 7315443 | Text | Text | [NAME] | 240621 | 6 | 2021-06-25 00:00:00 | Text |  | Personal
12513235 | 2021-06-03 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] |  | Text | Text | [NAME] | 100621 | 6 | 2021-06-15 00:00:00 | Text |  | Company
12516376 | 2021-06-15 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] | 7107968 | Text | Text | [NAME] | 170621 | 6 | 2021-06-21 00:00:00 | Text |  | Company
12516376 | 2021-06-15 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 6906579 | Text | Text | [NAME] | 170621 | 6 | 2021-06-21 00:00:00 | Text |  | Personal
12519828 | 2021-06-08 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] | 6543660 | Text | Text | [NAME] | 100621 | 6 | - | Text |  | None Found
12519828 | 2021-06-08 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] | 7490627 | Text | Text | [NAME] | 100621 | 6 | 2021-06-11 00:00:00 | Text |  | Personal
12519828 | 2021-06-08 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 7377726 | Text | Text | [NAME] | 100621 | 6 | 2021-06-11 00:00:00 | Text | Read | Personal
12519828 | 2021-06-08 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 6223284 | Text | Text | [NAME] | 100621 | 6 | 2021-06-11 00:00:00 | Text |  | Personal
12524169 | 2021-06-03 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] |  | Text | Text | [NAME] | 100621 | 6 | 2021-06-15 00:00:00 | Text | Read | Company
12524169 | 2021-06-03 00:00:00 | Text | Text | Figure | Structural engineer | Figure | Text | Number | [NAME] | 4699060 | Text | Text | [NAME] | 100621 | 6 | 2021-06-11 00:00:00 | Text |  | Personal
12525278 | 2021-06-23 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] |  | Text | Text | [NAME] | 240621 | 6 | 2021-06-25 00:00:00 | Text |  | Company
12525278 | 2021-06-23 00:00:00 | Text | Text | Figure | Project Manager | Figure | Text | Number | [NAME] | 6982627 | Text | Text | [NAME] | 240621 | 6 | 2021-06-25 00:00:00 | Text | Read | Company
12525278 | 2021-06-23 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 7383034 | Text | Text | [NAME] | 240621 | 6 | 2021-06-25 00:00:00 | Text | Read | Company
12525278 | 2021-06-23 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 7019199 | Text | Text | [NAME] | 240621 | 6 | 2021-06-25 00:00:00 | Text |  | Company
12527530 | 2021-06-09 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] | 7267998 | Text | Text | [NAME] | 100621 | 6 | 2021-06-11 00:00:00 | Text | Read | Personal
12528407 | 2021-06-03 00:00:00 | Text | Text | Figure | Architect | Figure | Text | Number | [NAME] |  | Text | Text | [NAME] | 100621 | 6 | 2021-06-15 00:00:00 | Text | Read | Company
12528407 | 2021-06-03 00:00:00 | Text | Text | Figure | Client | Figure | Text | Number | [NAME] | 7368703 | Text | Text | [NAME] | 100621 | 6 | 2021-06-11 00:00:00 | Text | Read | Personal | Added to Tender List
12528503 | 2021-06-17 00:00:00 | Text | Text | Figure | Project manager | Figure | Text | Number | [NAME] |  | Text | Text | [NAME] | 170621 | 6 | 2021-06-21 00:00:00 | Text |  | Company