Emails from Excel
Presented Excel file connects with another Excel workbook, which contains real time stock data. It sends an email alert via Outlook, when stock price reaches trigger value (can happen only once for each stock per day). User can customize recipient's email, title, body and use <results> tag in the body, so that they appear in desired place. My macros can also send many emails at once, based on email list in Excel. I can send emails from any email assigned to Outlook account on this PC, not only the main account. Requires Windows OS and Outlook installed. Outlook doesn't need to be open for the macro to work.
Mi perfil
My main areas of expertise are VBA macros (Excel, web scraping) and WordPress speed optimization, where I regularly achieve 95+ score in Google PageSpeed Insights / GTmetrix. I also develop WordPress plugins, mostly WooCommerce-related. In Excel VBA I like to work on big data sets, for example, stock market and Forex data, where code performance matters. I'm proficient in standard Excel tools: formulas, charts, graphs, pivot tables, conditional formatting, Solver, etc. VBA: - over 8 years of experience - Excel automation - web scraping - passing data between Excel, Word, text files, etc. - rearranging data structure - sending e-mails based on Excel data - operations on files and folders - UserForms - custom formulas - macro speed optimization WordPress (PHP, jQuery, JavaScript, HTML, CSS) - over 3 years of experience - website speed optimization (Google PageSpeed Insights, GTmetrix) - fixing websites, small customizations - plugin development, mostly for WooCommerce
