Bill & Crystal - thanks for the pointers about checking what the ACTUAL data is. This has moved me on slightly in that I know the problem is not coming from how I link the Access db to Outlook. The wizard did work and established a good link. The problem came when I tried to look at two linked tables / folders. What I want to do is to create a view of these two tables and hence drive a form to show the contents. I thought that a Union query should do, hence this is my query:
SELECT "Ray" as [EmailSource],ALMS_Ray.Importance, ALMS_Ray.Subject, ALMS_Ray.From, ALMS_Ray.[Message Size], ALMS_Ray.Contents, ALMS_Ray.Created
FROM ALMS_Ray
UNION SELECT "Lyn" as [EmailSource],ALMS_Lyn.Importance, ALMS_Lyn.Subject, ALMS_Lyn.From, ALMS_Lyn.[Message Size], ALMS_Lyn.Contents, ALMS_Lyn.Created
FROM ALMS_Lyn;
FROM ALMS_Ray
UNION SELECT "Lyn" as [EmailSource],ALMS_Lyn.Importance, ALMS_Lyn.Subject, ALMS_Lyn.From, ALMS_Lyn.[Message Size], ALMS_Lyn.Contents, ALMS_Lyn.Created
FROM ALMS_Lyn;
This union query is definitely truncating the contents of the emails. I don't understand why.
If I select one table (Outlook folder) eg ALMS_Ray I get all of the email. As soon as I use the Union those same emails are truncated.
What am I missing?
Regards
Ray
---In MS_Access_Professionals@yahoogroups.com, <wrmosca@...> wrote :
Ray - According to MS Office support:
---In MS_Access_Professionals@yahoogroups.com, <rayfrew@...> wrote :
Text fields in desktop databases (.accdb)
Long Text In .accdb files, the Long Text field works the same as the Memo field of old. That is, it can store up to about a gigabyte of text, even though controls on forms and reports can only display the first 64,000 characters. You can set Long Text fields to display Rich Text, which includes formatting like bold and underline.
But that doesn't say anything about what you can see by viewing the field directly in the linked table. Have you tried opening the table and looking at the data?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <rayfrew@...> wrote :
Hi everyone
I'm trying to link my database to Outlook so that as emails arrive I can use them in Access. I followed the wizard (External Data / More / Outlook folder) and chose the option to "Link" and create a linked table. That worked fine. However, I noticed that the contents of the email is truncated. When I looked at the linked table created the data type is "Long Text" - is that significant?
If I had chosen the first option from the wizard which "Imports the source data" I get all of the email.
It seems as though I can have (1) linked tables showing up to date "partial" emails or (2) all of the email, just not up to date (I would have to refresh the table on a regular basis). Is there a way I can have all of the email and a true, up to date link to my Outlook system? I'm using Outlook 2013 and Access 2013.
Any ideas / pointers much appreciated.
Many thanks
Ray
__._,_.___
Posted by: rayfrew@gmail.com
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (7) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar