Mac – way to view/edit Outlook for Mac’s SQLite database to edit the signature file

emailmacms officesoftware-recommendationsqlite

I am looking to edit the file or reference that is used in the SQLite database that Outlook uses on the Mac. Instead of having to copy and paste an HTML signature in the Outlook program, I would like to paste the HTML code into the database.
What programs and or resources would I need to view and edit this portion of the database that Outlook uses?

Database File

⁨Library⁩/Group Containers⁩/UBF8T346G9.Office⁩/Outlook⁩/Outlook 15 Profiles⁩/Main Profile⁩/Data⁩/Outlook.sqlite

Best Answer

You can access it using the built-in SQLite program. In Terminal run the command “sqlite3” with the your Outlook.sqlite file as the parameter.

From there you can use SELECT commands to view data and UPDATE to change them. Check the SQLite home page for documentation, if you do not already know SQL.