Working on a project extract the contents of a message body (itm.subject) from an outlook email and place it in a separate access Database.
I've decided getting at the emails is easier from an Outlook Module.
So how do I Copy a template in the Access Database to create a Fresh formated File (Called JOP) (docmd doesn't seem to cut it.
And then reference the Database to append the extracted Data
Dim DB As Access.Application
Set DB = Access.Application
DB.Visible = True
DB.Application.OpenCurrentDatabase ("C:Upload DBs.mdb")
Set rs = DB.OpenRecordset("JPM")
The method above dosn't seem to work
Any help would be gratefully received. If I need References could you just confirm those aswell