Do you often use the attachment name as the email subject in Outlook? If so, you must hope that Outlook can automatically complete it. This article will introduce a handy method to make it realized with Outlook VBA.
Many users are accustomed to manually typing the attachment name in the email subject line. In such a scenario, if Outlook can auto accomplish it, it’ll be far more convenient. Also, some users often forget to fill the subject line. So, when hitting “Send” button, they will...
Read more »
This exercise shows how to read data from a website, in this case up-to-the-minute currency exchange rates from Yahoo.com.
It is assumed the reader has the Developer ribbon displayed and is familiar with the VBA Editor. If not, please Google "Excel Developer Tab" or "Excel Code Window".
Prerequisites include a knowledge of populating combo-boxes and defining names.
The workbook consists of two sheets:
The User Interface:
The Buy and Sell combo boxes reference the local data sheet...
Read more »
Do you often need to attach specific files when sending specific emails in Outlook? If so, you may feel it tedious to add them manually every times. This article will teach you a quick method to achieve it with Outlook VBA.
In my daily works, I am frequently required to attach specific files when sending specific emails. For instance, every week, I have to send an email to my superiors so as to report my weekly work. In this email, I will need to attach some specific files, including work...
Read more »
