Iam looking for VBA code help that performs the below steps .
1. In the attached workbook, in sheet 1 VBA should apply auto filter to column “F” and filter for anything apart from “Complete” items
2. After applying filter if there are any items other than “Complete” copy the data along with header and paste it to outlook email body. Screen shot below
3. If all the item are “complete” then no need to copy data from sheet1 to outlook email, but the body of the email must say the following lines below
“Hi Team,
The monitor check has been completed and everything looks good in Prod and in INT environment.”
4. If there are items other than complete, like in point 2 above - then the body of the email should consist of 2 parts – first being the statement as below in quotes
“Hi Team,
The monitor check has been completed and everything looks good in Prod and in INT environment. Except the below exceptions for today”
‘secondly copy paste the filtered data from sheet1 to outlook email, as shown below
Let me know in case of any questions, Also I can edit for including the TO : email address later.
1. In the attached workbook, in sheet 1 VBA should apply auto filter to column “F” and filter for anything apart from “Complete” items
2. After applying filter if there are any items other than “Complete” copy the data along with header and paste it to outlook email body. Screen shot below
3. If all the item are “complete” then no need to copy data from sheet1 to outlook email, but the body of the email must say the following lines below
“Hi Team,
The monitor check has been completed and everything looks good in Prod and in INT environment.”
4. If there are items other than complete, like in point 2 above - then the body of the email should consist of 2 parts – first being the statement as below in quotes
“Hi Team,
The monitor check has been completed and everything looks good in Prod and in INT environment. Except the below exceptions for today”
‘secondly copy paste the filtered data from sheet1 to outlook email, as shown below
Let me know in case of any questions, Also I can edit for including the TO : email address later.
