vbaemailms-accessoutlookoutlook-2013

Moving Emails to specific Outlook folders Using Access VBA

I'm using Microsoft Office 2013 to set up an access database linked to an inbox in outlook. I'm having no issues setting up a linked table and manipulating the data within access.

What I want to do is move the email from one outlook folder/subfolder to another outlook folder/subfolder with VBA code within Access. In other words, I want to click on a button within Access and activate VBA coding that moves the email within Outlook.

Any tips on how to get started will be greatly appreciated.

Solution

  • Use MailItem.Move and pass the target MAPIFolder object as the parameter.