Cross-Application Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top