VBA MS Outlook to MS Access (2007)
Posted on 2010-01-12
I'm looking for VBA that I can put in outlook 2007 that will grab the email sent date/time, email senders email address, email subject, and email body from an email and put it in an access 2007 form (or table). I would prefer that it put it in the form.
I can read and understand VBA to a certain extent so a basic example that I can make work will suffice. One other thing is that the senders are stored in a separate table in the database. A simple error handler to deal with instances where a contact is not set up would be appreciated - but is not required.
I am aware that I can create forms that are emailed - I am looking for VBA for outlook so that when I receive an email I can click the macro button in outlook and it will populate the open form in access (note both apps will be open and the form that I need outlook to fill will also be open).