VBA
Macro to open a web URL from Outlook
Many of us spend most of our work time in a few applications such as Outlook (email) and a web browser. This example macro for Microsoft Outlook will let you add a button to the Outlook Ribbon that will open a specific website URL.
A simple mail filer for Microsoft Outlook (VBA)
Like many people I receive an unmanageable amount of email each day. Many days I get through only around 1/3 of the email I receive. However, the role I am in professionally requires me to retain a large proportion of correspondence. Some because it relates to ongoing projects, other because of security, audit or compliance reasons. In addition, I work across many projects. It isn’t unusual for me to be involved in two dozen projects at any one time on top of my day-to-day management work.
Nearest Postcode Search in Microsoft Excel
I need to find a load of addresses by proximity to a postcode. I have the addresses in a Microsoft Access database. Download Paul Jenkins’s UK Postcode csv and import into Access as a table Create a query on your own table adding the following calculated field: <pre>PCregion: Trim( Left( [My Table]![Postcode], InStr( [My Table]![Postcode], ” ” ) ) )</pre> Create a second query that joins the above query to the imported postcode table.
