There is a excel file which we use as a checklist on a daily basis(sample attached). After all the fields are manually updated in the checklist, we send out email via outlook to certain fixed ID’s, the content to include in email depends on outcome of our checklist. There are only two possible scenarios that can happen – below are the situations
1. In Column “F” if all the cells show as “Completed”, then the message to include in the email body is as below in quotes
“Hi Team,
The monitor check has been completed and everything looks good in Prod and in INT environment”
2. Second possible situation would be, in column “F” if there are cells updated with anything other comment than “Completed” like “Stale”, “ Missing” then vba has to filter these types(Stale, Missing). In this situation there are two things to include in email body
a> message to include in email body is as below
“Hi Team,
The monitor check has been completed and everything looks good in Prod and in INT environment. Except the below exceptions for today”
b> ‘ then copy paste the filtered content from excel to email body below the above lines, as shown below
Iam new to VBA, can only understand few things, Please let me know if this much can be automated with the help of VBA? Also suggest me if there is any better way to do this. To: Jontyanand99@gmail.com
Sub Line : Daily monitors checklist
1. In Column “F” if all the cells show as “Completed”, then the message to include in the email body is as below in quotes
“Hi Team,
The monitor check has been completed and everything looks good in Prod and in INT environment”
2. Second possible situation would be, in column “F” if there are cells updated with anything other comment than “Completed” like “Stale”, “ Missing” then vba has to filter these types(Stale, Missing). In this situation there are two things to include in email body
a> message to include in email body is as below
“Hi Team,
The monitor check has been completed and everything looks good in Prod and in INT environment. Except the below exceptions for today”
b> ‘ then copy paste the filtered content from excel to email body below the above lines, as shown below
Iam new to VBA, can only understand few things, Please let me know if this much can be automated with the help of VBA? Also suggest me if there is any better way to do this. To: Jontyanand99@gmail.com
Sub Line : Daily monitors checklist
