Thanks. Here is the explanation
I have excel sheet as below. Suppose if there is no data in any sheet I do not want to load the blank sheet. All I need is excel should be in user email through automation. this is a challenge to me now as users are asking why do we need to use access point why can not we get excels to emails daily first thing in morning.
Main - have summary pivot table with dimension as Status and expressions is Count (ID) and graph chart resembling the pivot table
MainRawData - have straight table with all Status = 'Initial','Middle','Accountant','SubAccountant','Staff','PortalStaff','Manager','CustomercareStaff','ITStaff','Supplier','Market','Business'
SheetA - have data where Status='Initial'
SheetB - have data where Status='Middle'
SheetC - have data where Status='Accountant'
SheetD - have data where Status='SubAccountant'
SheetE - have data where Status='Staff'
SheetF - have data where Status='PortalStaff'
SheetG - have data where Status='Manager'
SheetH - have data where Status='CustomercareStaff'
SheetI - have data where Status='ITStaff'
SheetJ - have data where Status='Supplier'
SheetK - have data where Status='Market'
SheetL - have data where Status='Business'
Suppose for eg: today/tomorrow if there will be no data in SheetF where Status = 'PortalStaff' I do not want to load SheetF when there is no data because if there are blank sheets then my users needs to delete those blank sheets manually and that is not good daily. All users expecting excel file in their inbox first thing in the morning.
I have tried so many ways and I could able to add multiple emails to 'To' field but could not able to get right macro. this is very priority to me now as it has been outstanding so long.
Please any help would be appreciated.
