By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,829 Members | 673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,829 IT Pros & Developers. It's quick & easy.

emails to Access Table

P: 171
Hi All
I am trying to import MS Outlook emails to a an access table using the access menu item External Data-More-Outlook Folder option.The body of the email imported to memo field but some message body are imported half only. It is not truncated 255 characters because I checked the length of the records in the memo field and some of them are more than 1000 characters.
Is there any other possible way to import all the text in message body without losing?
I wish to import all emails from my sent items and need the fields "to","sent on","cc","subject","attachment","message body"
Please help
Apr 24 '17 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 15k+
P: 31,418
I'm afraid I can't be much help as my system complains that the wizard isn't correctly installed.

Let me start by clarifying for anyone else reading this though (and correct me if any of my comments are incorrect.) :
  1. You're using version 2010 or later.
  2. The actual command sequence is External Data -> Import & Link -> More -> Outlook Folder.

I would consider looking at the Linked Table option. Does it give you the same problem?
It would also help if you reported the largest length you see in your imported data. This is easily done by assigning the value to a string variable then printing Len(variable).
Apr 24 '17 #2

P: 171
Dear NeoPa
Thank you for the reply.Point 1 & 2 are correct. I have office 2010 and using the same command sequence.
I tried linked table also. But same result.
There is no consistency of truncating. That is not truncating after any specific length.
I have noticed the longest message is more than 3900 chr but that is truncated after 3900 chr. lesser length also truncates. I have searched for vba assistance, but couldnt find any suitable one. Please help
Apr 25 '17 #3

Expert Mod 15k+
P: 31,418
I don't believe I can any further Rajeev, I'm sorry to say. As I said, my system doesn't allow me even to test with my own messages, let alone with yours.

Maybe you could identify, for each message that's truncated, the character immediately after the last that was carried through. If, as I suspect, that is a Null (vbNullChar or Chr(0)) then that would at least explain the behaviour. If that is the case then I'm afraid I have no real idea how you'd go about getting past it. The only idea of any remote help that I have is perhaps to use Application Automation in some way, but that could be a long road in itself.

I expect your best bet at this stage is to hope that someone else, with access to a system properly configured in this respect, comes in and has some viable suggestions for you.

Sorry I can't be more help, but good luck anyway.
Apr 25 '17 #4

P: 171
Dear NeoPa
Thank you for the reply. The truncate is happening even middle of the word, but after truncate the message body, it shows the signature text. That is why I said there is no way I can identify the reason.
May be someone can help with VBA script which can read all the sent mail items and write to Excel work sheet or Access table. I need to extract Sent Date, To, CC, Subject and mail body.
I will wait with a hope that someone else will be able to help me which I am sure will happen.Thank you for your willingnes to help me.
Apr 25 '17 #5

Post your reply

Sign in to post your reply or Sign up for a free account.