View Single Post
  #4  
Old May 14th 08, 07:27 PM posted to microsoft.public.outlook.program_vba
Dmitry Streblechenko
external usenet poster
 
Posts: 2,116
Default Reconstructing Outlook emails with attachments from SQL Blobs

You could use Aplication.CreateItemFromTemplate, but it wipes out the sender
related data and the message is created in the unsent state. You could use
Redemption to import them (RDOFolder.Items.Add / RDOMail.Import).
What do you mean by "msg file already shows that the attachment is there,
except when you click on it, it really isn't there"?
On the low level, were the attachments left in place by PR_ATTACH_DATA_BIN
property removed (look at the MSG file with OutlookSpy - click Misc |
OpenIMsgOnIStg)?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"JW" wrote in message
...
"Dmitry Streblechenko" wrote:

Import the mesage to Outlook, then add attachments using
MailItem.Attachments.Add.
Are you simply saving the messages as MSG files so that users can open
them
from Windows Explorer or import them to Outlook?


The messages are blobs in the database so that they can be linked to other
database rows/objects. They are being exported from the database to msg
files so that they can be displayed in Outlook interface in their original
format. If we could "stream" them directly to the Outlook interface, that
would be even better that exporting them into msg files first. How to I
import the blob direcly into Outlook? In addition, the msg file already
shows that the attachment is there, except when you click on it, it really
isn't there. If I do an Attchment.Add, won't there now be two copies of
the
attachment showing, one that works and one that doesn't?



Ads