Hi , You can use this macro set obj = ActiveDocument.GetSheetObject("CH01") obj.ExportBiff "C:\test.xls" What u can do is create a new Tab which contains a consolidated report of all tabs whatever data is there in these tabs. Then put this report in report editor. and set this report as document report. In the Report editor you can use loop over customer field option in Report settings---------->After this you will find selections tab at top.. And at the bottom you will find Banding Check box : Loop over possible values in the field. U can have this macro trigger action after post reload of the application. And then u can also use a macro to email this report to various customers to their email ID. For that also you will have to write macro and finally u can combine above macro and this macro along with your mail server settings.(outlook,exchnageserver,lotus notes) Regards Raj,
Sorry i cannot attach application as i am at client side.And network settings don't allow us to send any attachments. What i had done for one of our clients is they wanted customer wise reports to go to individual customers via email. This task had to be automated without any manual intervention.. Like a person generating a report and the emailing them. So i created a custom tab which would automatically generate customer wise product detail reports once our reload was complete and send a notification tothe clients automatically via email . So the customer had to just download the report and if any discrepancies where there he would revert.
