Import From Email

[spaLOGICng]

Hi
I have a table called ImportEmailsTBL with id, SubjectMail, MSgBody.
at outlook: I save my emails to a folder called - TempEmail

I would like to scan the folder and import every email to my table (ImportEmailsTBL), the subject of the email will go SubjectMail Field and the body of the maill will go to MsgBody field
then move the email to another folder called "donEmails"

is there away to do it?

Why not just connect or link to your inbox in Access? If your email is in Outlook you can connect to Outlook as an access table, then you can import the contents from there. The only caveat about this solution is in a multi-user environment because only you can see your inbox and it would error out for any other user.

Alternatively, if you have a Microsoft 365 subscription, you can use power automate to send emails to a SharePoint list. Then you can connect to that SharePoint list in Access.

 

[spaLOGICng]

Not anything I can make head or tail of?
View attachment 112539

That is an encrypted email. You will need to get an email decryption tool.

 

[CJ_London]

Why not just connect or link to your inbox in Access?

already been suggested