Obsidian For Business
A combination of a template vault with initial structure and some Microsoft Office VBA Macros to facilitate a powerful, extensible, and flexible plain text workflow using Microsoft Office and Obsidian For Business.
If you enjoy this product and want to support it's development consider GitHub Sponsor ship:
👉
Sponsor this Work
👈
Table of Contents
Features
- A template business vault to get you started using
Obsidian For Business
- Easy Johnny Decimal tagging and refactorting of emails en-masse
- Select email(s) and run the
JDAdd
macro and you type in a tag like:12.04
and all your email subject lines will get a[12.04]
tag added to the end of the subject line for easy searching described more in detail HERE - To easily remove an entire tag from email(s) select them all and run
JDRemove
and 1 tag will be removed from the end of the subject line - Conversation view groups will not display the tag only the individual email items
- Select email(s) and run the
- Extract emails and calendar meetings to plain text straight to your vault
- Select any number of emails in the interface and run the
SaveEmail
utility and each email will be extracted to the designated vault file path set in USER_CONFIG
- Select any number of emails in the interface and run the
- Extract meeting attdendees and details by selecting a single meeting at a time in the calendar interface and running
SaveMeeting
and the detailes will be extracted to the designated vault file path set in USER_CONFIG - Several facets of this system are configured and documented in USER_CONFIG
Requirements
- For the VBA Tools
- Microsoft Windows
- Microsoft Office
- Microsoft Office VBA libraries activated
- Microsoft Forms 2.0 Object Library
- Microsoft VBScript Regular Expressions 5.5
- For the TEMPLATE_VAULT
- Obsidian
Recommended
- Latest Versions of Obsidian and Recommended Community Plugins
Installation
- Download the repo through any means
- GitHub CLI
- SSH
- HTTPS
- a
.zip
etc.
- Take the
TEMPLATE_VAULT/
directory and rename it to what ever you want your business vault to be named - Open that folder in Obsidian as a new vault
- Explore, play, find out what works and doesn't and change what ever you'd like
Getting the Outlook Utilities Installed
- Open Outlook
- press & hold Alt then press f11
- The Visual Basic Editor will open and you'll see something that looks like this:
- The first thing we need to do is activate some library references
- Go to
Tools > References
- and you'll see this dialog box open.
- Ensure all these items are selected if they are not, find them and select them. Namely the 2 necessary ones are
- Microsoft Forms 2.0 Object Library
- Microsoft VBScript Regular Expressions 5.5
If you cant find things like Microsoft Office 16.0 Object Library
don't worry, you might not have the latest versions. IF you encounter any issues please file a bug report but It is unlikely you'll encounter many issues if any with these tools.
- Next we need to get the code into the Outlook Application. This is sadly a manual process given how antiquated the toolset is so apologies but you'll need to copy/paste and rename the macros you decide to use in Outlook.
- To start click the depicted button and select
Module
for every.vb
file you want to use in this workflow:
- Name the files exactly as you see listed below. To change the name of a new module you'll use the
Properties
window as shown below. It should automatically be visible when you open the Editor with the hotkey combo from earlier
By itself these steps allow you to use the macros but it's not a very userfriendly experience. To see my recommended setup for these macros see Usage.
Users
There should be no administrative privledges required for any of these tools at any time for any reason. As well as no requirement for any passwords, credentials or any user information what so ever.
See Usage
Contributors
None yet! But PR's welcome!
See CONTRIBUTING
Usage
Now that you've finished installing the code from Installation We need to make a more friendly experience for their usage.
We will do this using the Quick Access Toolbar in Outlook
.
- At the top of your Outlook application there will be a little down arrow icon and some other icons in the top left of the application.
- Click the down arrow and select the
More Commands
option
- You'll get a screen that looks similar to this, under the
Choose commands from
drop down selectMacros
and you'll see a list of the code files we added. - because of the way VBA works you cant name the functions the same as the modules so thats why the names differ but it should be fairly obvious which are which.
- Select the macro items and click the
Add >>
button to move them to the Quick Access Toolbar menu (<Separators>
are useful for visually separating groups of commands)
- Now we can get a little more aesthetic and select a Macro on the right hand side of the dialog box then click
Modify...
- This will let you select a custom icon to display on the Quick Access Toolbar for the macro so they are a little more intuitive to view
- When finished click
Ok
until all menus and windows are closed
With that all done you'll have some icons on your Quick Access Toolbar to click for your automated actions but to take it a step further, if you simply press Alt the Quick Access Toolbar will highlight the icons with numbers so you can simply press a number afterwards to run the action for an entirely keyboard-centric workflow:
Example
<++>
Documentation
- See The Wiki
Resources
Development
- Development should take place on a Windows machine.
- Given that VBA was made in '93 legacy'd in '08 little has changed so you can still easily use older code and machines.
- Only thing is that the newer versions of MS Office might be recommended because of the additions to the Object Library for VBA and i'm not sure if there would be anything missing from what versions of the libraries.
- Helpful tools with VBA that I have yet ot implement well with this project are:
See CONTRIBUTING
Security
- There are no required credentials or escalation of privledges and no data being dealt with outside of the local machine. There shouldn't be any security issues but if you think of anything please:
See SECURITY
Future
- Ideally i'd like to further improve upon the code base using the additional VBA dev tools listed under Development to batter manage the code.
- For now i'd like to squash bugs, expand the regex options for email formats that appear so the extractors work as intended and after reaching a level of stability, just expand feature requests.
See ROADMAP
History
- 2021-04-04 Codebase Is Opensourced!
See RELEASES
Community
See CODE OF CONDUCT
Credits
- Thank you to everyone who contributes to this project.
- If you contribute to this project do add a PR for AUTHORS as well!
See AUTHORS
License
See LICENSE