How to export table from outlook into ms access table?

H

Hyen

Joined
Mar 26, 2022
Messages
1
Reaction score
0
I have a problem in writing vba code to import table receive via email into Ms Access table.

Email body is like this:

Monthly transfer for ABC.
FromaccountToaccountamountdatetotal
Alex123Ben345100
100		1/2/22
3/2/22		200
CandyC412Daniel D87650
50		2/3/22
2/3/22		100

How do i write vba code to import the above table from outlook body into ms access table? Access table to include email title for every record so i know this record is from ABC monthly transfer.

Anyone can assist? Highly appreciate that.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Import MS Outlook messages into MS Access - The Email Body Loses Formatting 0
How to Populate Data from a table to another 0
Access Access 2010 import/append data into table w/o overwriting existing records 0
Access How can i delete record from 7000 to 65000 in MS Access Table? 0
Access How can I join two columns from different table into one in MS Access? 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access "Un"concatenate a field to create multiple records in MS Access 4
Access Finding and deleting duplicate records. MS Access Help ASAP 0

Back
Top