Re: Rebuild email messages

Generally speaking, you can't - OOM does not let you set all the Extended
MAPI properties that Outlook needs, e.g. it only exposes SenderName (read
only), while you need to set PR_SENDER_NAME, PR_SENDER_EMAIL_ADDRESS,
PR_SENDER_ENTRYID, PR_SENDER_ADDR_TYPE to display the sender correctly in
Outlook. You need to use Extended MAPI./CDO/Redemption for that.

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


"Jenny Tam" <yinjentam@hotmail.com> wrote in message
news:d6b9e062.0306301329.641420c1@posting.google.com...
> Hi
>
> We are working on creating an Outlook addin to allow user to export
> selected email messages to our SQL Server 2000 database table. We
> will extract the To, From, Subject, Body, etc to different table
> fields. However, is it possible that we can rebuild the email
> messages based on what we have in the DB table? We want to make it
> look like an existing outlook message as if the user opens it from
> Outlook (such that the user can reply/reply all/forward if s/he
> likes). We know that one way is to save the emails as .msg files to
> the database, but this causes inconsistency in our application because
> we have existing emails stored as plain text only and some other
> emails are in RFC format.
>
> We have been searching for an answer for a few days already and we
> have no luck so far. Any hints or suggestions are very much
> appreciated.
>
> Thanks in advance,
> Jenny

Yes I found that using OOM alone cannot do that, but I don't know
Extended MAPI/CDO enough to know whether this is possible either. Can
you give me more hints or suggestions? How can Redemption help me in
this case?

Also, any suggestions with our existing data (plain text or RFC822
format)?

Thanks!
Jenny



"Dmitry Streblechenko" <dmitry@dimastr.com> wrote in message news:<u9zqMV1PDHA.1584@TK2MSFTNGP11.phx.gbl>...
> Generally speaking, you can't - OOM does not let you set all the Extended
> MAPI properties that Outlook needs, e.g. it only exposes SenderName (read
> only), while you need to set PR_SENDER_NAME, PR_SENDER_EMAIL_ADDRESS,
> PR_SENDER_ENTRYID, PR_SENDER_ADDR_TYPE to display the sender correctly in
> Outlook. You need to use Extended MAPI./CDO/Redemption for that.
>
> Dmitry Streblechenko (MVP)
> http://www.dimastr.com/
> OutlookSpy - Outlook, CDO
> and MAPI Developer Tool
>
>
> "Jenny Tam" <yinjentam@hotmail.com> wrote in message
> news:d6b9e062.0306301329.641420c1@posting.google.com...
> > Hi
> >
> > We are working on creating an Outlook addin to allow user to export
> > selected email messages to our SQL Server 2000 database table. We
> > will extract the To, From, Subject, Body, etc to different table
> > fields. However, is it possible that we can rebuild the email
> > messages based on what we have in the DB table? We want to make it
> > look like an existing outlook message as if the user opens it from
> > Outlook (such that the user can reply/reply all/forward if s/he
> > likes). We know that one way is to save the emails as .msg files to
> > the database, but this causes inconsistency in our application because
> > we have existing emails stored as plain text only and some other
> > emails are in RFC format.
> >
> > We have been searching for an answer for a few days already and we
> > have no luck so far. Any hints or suggestions are very much
> > appreciated.
> >
> > Thanks in advance,
> > Jenny

I don't have any ready to run samples, in CDO or Redemption you will need to
use the Fields collection on the message to set these properties.
As for the RFC822 messages, you can either import/export the messages
property by property, or you can use Redemption (see SaveAs() and Import()
with olRFC822 format)

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


"Jenny Tam" <yinjentam@hotmail.com> wrote in message
news:d6b9e062.0307021210.3dfa8e43@posting.google.com...
> Yes I found that using OOM alone cannot do that, but I don't know
> Extended MAPI/CDO enough to know whether this is possible either. Can
> you give me more hints or suggestions? How can Redemption help me in
> this case?
>
> Also, any suggestions with our existing data (plain text or RFC822
> format)?
>
> Thanks!
> Jenny
>
>
>
> "Dmitry Streblechenko" <dmitry@dimastr.com> wrote in message
news:<u9zqMV1PDHA.1584@TK2MSFTNGP11.phx.gbl>...
> > Generally speaking, you can't - OOM does not let you set all the
Extended
> > MAPI properties that Outlook needs, e.g. it only exposes SenderName
(read
> > only), while you need to set PR_SENDER_NAME, PR_SENDER_EMAIL_ADDRESS,
> > PR_SENDER_ENTRYID, PR_SENDER_ADDR_TYPE to display the sender correctly
in
> > Outlook. You need to use Extended MAPI./CDO/Redemption for that.
> >
> > Dmitry Streblechenko (MVP)
> > http://www.dimastr.com/
> > OutlookSpy - Outlook, CDO
> > and MAPI Developer Tool
> >
> >
> > "Jenny Tam" <yinjentam@hotmail.com> wrote in message
> > news:d6b9e062.0306301329.641420c1@posting.google.com...
> > > Hi
> > >
> > > We are working on creating an Outlook addin to allow user to export
> > > selected email messages to our SQL Server 2000 database table. We
> > > will extract the To, From, Subject, Body, etc to different table
> > > fields. However, is it possible that we can rebuild the email
> > > messages based on what we have in the DB table? We want to make it
> > > look like an existing outlook message as if the user opens it from
> > > Outlook (such that the user can reply/reply all/forward if s/he
> > > likes). We know that one way is to save the emails as .msg files to
> > > the database, but this causes inconsistency in our application because
> > > we have existing emails stored as plain text only and some other
> > > emails are in RFC format.
> > >
> > > We have been searching for an answer for a few days already and we
> > > have no luck so far. Any hints or suggestions are very much
> > > appreciated.
> > >
> > > Thanks in advance,
> > > Jenny