Import From Email (1 Viewer)

Gasman

Enthusiastic Amateur
Local time
Today, 06:41
Joined
Sep 21, 2011
Messages
14,447
You can save a readable file called a .mht
Not anything I can make head or tail of?
1707957863656.png
 

CJ_London

Super Moderator
Staff member
Local time
Today, 06:41
Joined
Feb 19, 2013
Messages
16,668
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.
 

spaLOGICng

Member
Local time
Yesterday, 22:41
Joined
Jul 27, 2012
Messages
154
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

Top Bottom