Vba


📖 Kb | 📎 Development, Microsoft, Software | 🔖 microsoft, office, outlook, 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.


📖 Posts | 📎 Microsoft, Software, Windows | 🔖 email, microsoft, outlook, vba

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.


📖 Posts | 📎 Development, Microsoft, Windows | 🔖 maps, office, vba

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. 1. Download Paul Jenkins’s UK Postcode csv and import into Access as a table 2. Create a query on your own table adding the following calculated field: <pre>PCregion: Trim( Left( [My Table]![Postcode], InStr( [My Table]![Postcode], &#8221; &#8221; ) ) )</pre> Create a second query that joins the above query to the imported postcode table.