I have set up a linked table in access to link with a folder in my inbox to read in those messages. I am trying now to read the body of the message in the linked table to split it into Forename, Surname, Address and read this into a contact table with those three fields.
To look through the message I have :
intCount = intCount + 1
when I run the module I get error 6 overflow and it goes to the incount = incount + 1 line.
I only have one email read in the linked table to test so don't see how can be having overflow with too large bytes being read, so confused how to solve this, any suggestions would be appreciated.