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.
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.
Email body is like this:
Monthly transfer for ABC.
| From | account | To | account | amount | date | total |
| Alex | 123 | Ben | 345 | 100 100 | 1/2/22 3/2/22 | 200 |
| Candy | C412 | Daniel | D876 | 50 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.