Application screenupdating does not work
We want to update this template using VBA code to create a static version and email it to a list of people.We will define the recipient list in a separate sheet. Code will automatically create necessary folders to save the output file. Email sheet to contain the list of people who are going to receive the report. Sending mail using Microsoft Outlook, primary target is corporate people who are using Outlook as their mail program.If you are checking the contents of a cell that can change, you may want to modify the macro a bit so that it will either hide or unhide a row, as necessary.The following variation will do the trick: Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author.
The following macro will examine a particular cell in the first 100 rows of a worksheet, and then hide the row if the value in the cell is less than 5.
We have assumed the data used to create the report is already available in the sheet called “raw Data”. We also create the body of the mail and specify the To, CC and BCC list. That is all the code we needed to create a copy of the report with selected few sheets and then send them out using VBA.
We have then updated the “raw Data” sheet with 2 new columns having the Date and Time. Finally we add the attachment to the email we have created and then using the Display method bring it on the screen. There are a lot of other methods using which you may be able to send out mails, however this specifically helps out to create report templates to use within your organization and send out mails. If you want to learn more about using VBA to automate reporting & email tasks, read these: If you want to learn how to develop applications like these and more, please consider joining our VBA Classes.
Please note that I am not able to share some of the files you emailed as they contained personal / sensitive data.
This page is broken in to 3 parts, click on any link to access those tips.