Send Email subject line to MS Access table
Posted on 2015-01-05
Hi, I have a routine which processes emails from MS Outlook, moving PDF attachments, renaming them and then moving the emails to a 'processed' folder.
Due to some network restrictions I cannot link the inbox to the Access database but want to capture the subject line in an table, for reconciliation purposes (against the processed PDF files).
Is there a VBA method for capturing the subject line for each of the selected emails, and sending it to a table, possibly called tbl_email_reconciliation?
I've been struggling with this for some time and would appreciate any help you can offer.