How to automatically send customized emails with attachments using excel macros via Outlook #officeautomation #outlook #excel #email_reminders #customized_emails #excel_tips www.mindstorm.gr

EXAMPLE OF PIVOT TABLE 1. Select any cell in the data dump > Select Insert > Select Table Then, create a PivotTable from that table: 2. In the Insert tab, select Recommended PivotTables Choose from one of Excel’s Recommended PivotTables. In this example, we have chosen to summarize Sum of Sales (in thousands) by Region, Month and Product. If you change your data dump, choose Analyze and then Refresh All, to refresh data in pivot table. #softexperia #excel_tips_softexperia #pivot_tables_softexperia

The AutoSum shortcut, ALT+= (ALT and = at the same time), allows you to automatically sum rows and/or columns. Select Region Before AutoSum If the current cell is in the column you want to sum i.e. B5, press CTRL+A to select all of the numbers in the columns, then press ALT = OR Use your mouse to select the columns and rows – A5:E18 – you want to sum, making sure the last column and row are empty as this is where the autosum will go. #excel_tips_softexperia #softexperia #excel_functions.

This is a result of vba code. You can see the table Calendar on Sheet1 and how it is when you copy the HTML created code to a wordpress post. The table will adjust well both on desktop and mobile devices. Excel to HTML Responsive table Excel table HTML table Period Weekly Options Booked May 12 – May 19 2000 Row 1, Col 1 Row 1, Col 2 2 Text2_2 3 Text3_2 4 5 – – – – – metavliti – – – – – – – HTML created code <style>table {   width: 100%;   table-layout: fixed;}th, td {   padding: 5px;   text-align: center;   overflow-wrap: break-word;   word-wrap: break-word;   hyphens: auto;}@media only screen and (max-width: 600px) {   th, td {       width: auto !important;   }}</style><table border=’1′ cellspacing=’0′ cellpadding=’5′><tr><td>Period</td><td>Weekly</td><td>Options</td><td>Booked</td></tr><tr><td>May 12 – May 19</td><td>2000</td><td>Row 1, Col 1</td><td>Row 1, Col 2</td></tr><tr><td>2</td><td></td><td></td><td>Text2_2</td></tr><tr><td>3</td><td></td><td></td><td>Text3_2</td></tr><tr><td>4</td><td></td><td></td><td></td></tr><tr><td>5</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>metavliti</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr><tr><td>-</td><td></td><td></td><td></td></tr></table>