View Single Post
  #2  
Old May 14th 08, 05:47 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

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?

--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"JW" wrote in message
news
I have a SQL database with the Outlook message saved to a blob without the
attachments. The attachments are saved to separate rows in another table.
I
would like to reconstruct the message with the attachments. If I extract
the
message to a .msg file, the attachments are missing. They were somehow
stripped off. I can also extract the attachments separately. I would like
to
be able to reconstruct the whole message, including attachments, to be
able
to display it in Outlook so the user can click on the attachment icons in
the
email and display it. Anybody got any ideas as to how to code this (C#
preferred). - Thanks in advance



Ads