Import From Email

You can save a readable file called a .mht
Not anything I can make head or tail of?
1707957863656.png
 
oops:mad:

my mistake - it create a file that is viewable in a web browser - I use it in my accounting apps and they are viewed (along with pdf's, pngs etc) in a web browser control on the form when the user selects a transaction.
 
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.
 

Users who are viewing this thread

Back
Top Bottom