Projects that involve both the construction or renovation of a structure or an alteration of part of the environment are considered part of civil engineering.
5 major civil engineering projects:
Water engineering.
Construction and management engineering.
Structural engineering.
Geotechnical engineering.
Transport engineering.
Macro 91: Saving Certain Attachments to a Folder In the previous procedure, we showed you how to use automation to search for all attachments in your inbox and save them to a specified folder. However, in most situations, you probably only want to save certain attachments; for example, those attachments attached to e-mails that contain […]
Macro 91: Saving Certain Attachments to a Folder Read More »
Macro 90: Saving All Attachments to a Folder You may often find that certain processes lend themselves to the exchange of data via e-mail. For example, you may send a budget template out for each branch manager to fill out and send back to you via e-mail. Well, if there are 150 branch members, it
Macro 90: Saving All Attachments to a Folder Read More »
Macro 89: Mailing All E-Mail Addresses in Our Contact List Ever need to send out a mass mailing such as a newsletter or a memo? Instead of manually entering each of our contacts’ e-mail address, we can run the following procedure. In this procedure, we send out one e-mail, automatically adding all the e-mail addresses
Macro 89: Mailing All E-Mail Addresses in Our Contact List Read More »
Macro 88: Send Mail with a Link to Our Workbook Sometimes, you don’t need to send an attachment at all. Instead, you simply want to send an auto- mated e-mail with a link to a file. This macro does just that. How it works Keep in mind that because this code will be run from
Macro 88: Send Mail with a Link to Our Workbook Read More »
Macro 87: Mailing a Single Sheet as an Attachment This example demonstrates how we would send a specific worksheet of data rather than the entire workbook. How it works Because this code is run from Excel, we need to set a reference to the Microsoft Outlook Object Library. We can set the reference by opening
Macro 87: Mailing a Single Sheet as an Attachment Read More »
Macro 86: Mailing a Specific Range as Attachment You may not always want to send your entire workbook through e-mail. This macro demonstrates how to send a specific range of data rather than the entire workbook. How it works Because this code is run from Excel, we need to set a reference to the Microsoft
Macro 86: Mailing a Specific Range as Attachment Read More »
Macro 85: Mailing the Active Workbook as an Attachment The most fundamental Outlook task you can perform through automation is sending an e-mail. In the sample code shown here, the active workbook is sent to two e-mail recipients as an attachment. How it works Because this code will be run from Excel, we need to
Macro 85: Mailing the Active Workbook as an Attachment Read More »
Macro 84: Color Chart Data Points to Match Source Cell Colors In the previous macro, we force each chart series to apply the same colors as their respective source data ranges. This macro works the same way, but with data points. You would use this macro if you wanted to force a pie chart to
Macro 84: Color Chart Data Points to Match Source Cell Colors Read More »
Macro 83: Color Chart Series to Match Source Cell Colors When you create a dashboard, you may have specific color schemes for various types of data. For example, you may want the North region to always appear in a certain color, or you may want certain products to have a trademark color. This gives your
Macro 83: Color Chart Series to Match Source Cell Colors Read More »
Macro 82: Label First and Last Chart Points One of the best practices for dashboard building is to avoid overwhelming your customers with too much data at one time — especially in a chart, where they can lose sight of the primary message if focusing on inconsequential data. One of the common ways dashboard designers
Macro 82: Label First and Last Chart Points Read More »
