Cross-Application Macro

[stevo]

I am trying to edit data in a MS Access database from a Visual Basic macro in
Outlook. Specifically, adding text from a message body to a field in Access.
Does anyone know how to open an Access Database for editing from a macro in a
different office application?

 

[Douglas J. Steele]

Typically, it involves setting a reference to DAO (or ADO), instantating a
Database (or Connection) object pointing to the database and either running
a SQL statement to do the update, or opening a recordset that you can then
update.