Erwin Craps - IT Helps
Erwin.Craps at ithelps.eu
Tue Jan 29 04:11:39 CST 2008
You could store them in HTML format, but you will lose attachments, unless you save them separately. Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps - IT Helps Sent: Tuesday, January 29, 2008 11:05 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] A2003: Dragging and Dropping from outlook I have code that runs trough Outlooks e-mails, store a unique id (from access) in the message, marks the subject as "ARCHIVED: & original subject", archives then the message to disk in .MSG format (including attachments). The filename and location (1000 files per folder) is given by access and stored in the accessdb together with the unique id and linked with the originators company. When I look up the company in Access I can see all e-mails I received from that company and by double clicking I open the .msg file from disk into Outlook. But I always need outlook for both saving and opening the .msg file. I am considering .EML files, I think, for broader support reasons and avoid using Outlook to archive on my server, but EML is not supported in Outlook, but is with Outlook Express. The main reason I would like to change to a more supported version is that I have customers opening these .msg (daily) files over the internet and some use Mac's... I need to archive all e-mails and faxes for this project on a daily basis (about 100 emails and faxes a day, 365 days a year), I'm doing this for more than 8 years now. And this is running smoothly. I had some request to convert the .msg to PDF, but the main problem is that Excel/word attachments are lost or no longer usable in their respective apps. So for the moment I stick with .MSG Erwin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: Tuesday, January 29, 2008 9:39 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] A2003: Dragging and Dropping from outlook Hi Darren That straw my be thin .. .msg files are for Outlook only: http://chilkatsoft.com/faq/OutlookMsgFormat.html /gustav >>> darren at activebilling.com.au 29-01-2008 06:15:03 >>> Hi all >From MS Outlook (Yes it has to be Outlook) I can drag an item from say*My Inbox - to the desktop (or any folder really) and I get to see a *.msg item I can double click this dot msg item and can then view it in MS Outlook * cool Anyone know of a control or OCX etc that I can use in MS Access where I do the same thing - Drag a Microsoft Outlook item and have it visible in my access app If not that then some kind of pointer with the Subject or such where a double click will open the item's OutlookID property I have tried an RTF OCX (RTF2.ocx that Lebans uses in his RTF demo) I have used in other apps but when I drag inbox items to it I get some thing like* >From Subject Received Size Dave SMITH Auto Upload and Download Script 20/11/2007 1 MB If this carried with it some sort of pointer * Even this would be enough then I could double click it Clutching at straws here Many thanks in advance DD -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com