Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   How can I save an attachment that is an email to my inbox? (http://www.outlookbanter.com/outlook-vba/11257-how-can-i-save-attachment.html)

matt69 April 11th 06 06:24 PM

How can I save an attachment that is an email to my inbox?
 
I would like to automate a workaround, but have no idea where to start. The
workaround is needed due to the following scenario:

I am working on a site where I cannot access my corporate email account. I
set up a rule to redirect my mail to my client email address, but noticed
that I did not see who was also sent the email (either as To or CC). So I
changed to rule to forward the message as an attachment so that I can see all
recipients as well as having their email addresses (which you do not get if
you just forward the email).

I would like a now like a macro to run automatically when mail arrives that
has been forwarded from my corporate email address. The macro would copy the
email attachment to my inbox and then delete the forwarded message. All I
can see in the VBA help is to save attachments to the file system, but I know
that I can drag and drop the email attachment from the forwarded message into
my inbox manually.

Any help is much appreciated, as I have never written VBA in Outlook and
only a little in Excel.

Michael Bauer April 12th 06 07:17 AM

How can I save an attachment that is an email to my inbox?
 
Am Tue, 11 Apr 2006 09:24:53 -0700 schrieb matt69:

In fact, saving the attachment as a file is the first step. You then can
open that message via GetItemFromTemplate and copy it into any folder.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


I would like to automate a workaround, but have no idea where to start.

The
workaround is needed due to the following scenario:

I am working on a site where I cannot access my corporate email account.

I
set up a rule to redirect my mail to my client email address, but noticed
that I did not see who was also sent the email (either as To or CC). So I
changed to rule to forward the message as an attachment so that I can see

all
recipients as well as having their email addresses (which you do not get

if
you just forward the email).

I would like a now like a macro to run automatically when mail arrives

that
has been forwarded from my corporate email address. The macro would copy

the
email attachment to my inbox and then delete the forwarded message. All I
can see in the VBA help is to save attachments to the file system, but I

know
that I can drag and drop the email attachment from the forwarded message

into
my inbox manually.

Any help is much appreciated, as I have never written VBA in Outlook and
only a little in Excel.


Dmitry Streblechenko April 12th 06 09:10 PM

How can I save an attachment that is an email to my inbox?
 
Note however that Application.CreateItemFromTemplate will wipe out all the
sender related properties since CreateItemFromTemplate is meant to be used
as a template for sending a new message.

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

"Michael Bauer" wrote in message
...
Am Tue, 11 Apr 2006 09:24:53 -0700 schrieb matt69:

In fact, saving the attachment as a file is the first step. You then can
open that message via GetItemFromTemplate and copy it into any folder.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


I would like to automate a workaround, but have no idea where to start.

The
workaround is needed due to the following scenario:

I am working on a site where I cannot access my corporate email account.

I
set up a rule to redirect my mail to my client email address, but noticed
that I did not see who was also sent the email (either as To or CC). So
I
changed to rule to forward the message as an attachment so that I can see

all
recipients as well as having their email addresses (which you do not get

if
you just forward the email).

I would like a now like a macro to run automatically when mail arrives

that
has been forwarded from my corporate email address. The macro would copy

the
email attachment to my inbox and then delete the forwarded message. All
I
can see in the VBA help is to save attachments to the file system, but I

know
that I can drag and drop the email attachment from the forwarded message

into
my inbox manually.

Any help is much appreciated, as I have never written VBA in Outlook and
only a little in Excel.




Michael Bauer April 13th 06 06:58 AM

How can I save an attachment that is an email to my inbox?
 
Am Wed, 12 Apr 2006 12:10:15 -0700 schrieb Dmitry Streblechenko:

Oh, I never realized that...

Is it possible to add the attachment as an embedded item and open it with
Redemption using the PR_ATTACH_DATA_OBJ property?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Note however that Application.CreateItemFromTemplate will wipe out all the
sender related properties since CreateItemFromTemplate is meant to be used
as a template for sending a new message.

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

"Michael Bauer" wrote in message
...
Am Tue, 11 Apr 2006 09:24:53 -0700 schrieb matt69:

In fact, saving the attachment as a file is the first step. You then can
open that message via GetItemFromTemplate and copy it into any folder.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


I would like to automate a workaround, but have no idea where to start.

The
workaround is needed due to the following scenario:

I am working on a site where I cannot access my corporate email account.

I
set up a rule to redirect my mail to my client email address, but

noticed
that I did not see who was also sent the email (either as To or CC). So
I
changed to rule to forward the message as an attachment so that I can

see
all
recipients as well as having their email addresses (which you do not get

if
you just forward the email).

I would like a now like a macro to run automatically when mail arrives

that
has been forwarded from my corporate email address. The macro would

copy
the
email attachment to my inbox and then delete the forwarded message. All
I
can see in the VBA help is to save attachments to the file system, but I

know
that I can drag and drop the email attachment from the forwarded message

into
my inbox manually.

Any help is much appreciated, as I have never written VBA in Outlook and
only a little in Excel.


Dmitry Streblechenko April 13th 06 06:37 PM

How can I save an attachment that is an email to my inbox?
 
Sure, Attachment.EmbeddedMsg will return MessageItem in case of the
Safe*Item objects and RDOMail in case of an attachment from an RDOMail
object.
You can then copy that message to any folder.

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

"Michael Bauer" wrote in message
.. .
Am Wed, 12 Apr 2006 12:10:15 -0700 schrieb Dmitry Streblechenko:

Oh, I never realized that...

Is it possible to add the attachment as an embedded item and open it with
Redemption using the PR_ATTACH_DATA_OBJ property?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Note however that Application.CreateItemFromTemplate will wipe out all
the
sender related properties since CreateItemFromTemplate is meant to be
used
as a template for sending a new message.

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

"Michael Bauer" wrote in message
...
Am Tue, 11 Apr 2006 09:24:53 -0700 schrieb matt69:

In fact, saving the attachment as a file is the first step. You then can
open that message via GetItemFromTemplate and copy it into any folder.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


I would like to automate a workaround, but have no idea where to start.
The
workaround is needed due to the following scenario:

I am working on a site where I cannot access my corporate email
account.
I
set up a rule to redirect my mail to my client email address, but

noticed
that I did not see who was also sent the email (either as To or CC).
So
I
changed to rule to forward the message as an attachment so that I can

see
all
recipients as well as having their email addresses (which you do not
get
if
you just forward the email).

I would like a now like a macro to run automatically when mail arrives
that
has been forwarded from my corporate email address. The macro would

copy
the
email attachment to my inbox and then delete the forwarded message.
All
I
can see in the VBA help is to save attachments to the file system, but
I
know
that I can drag and drop the email attachment from the forwarded
message
into
my inbox manually.

Any help is much appreciated, as I have never written VBA in Outlook
and
only a little in Excel.




Michael Bauer April 14th 06 07:19 AM

How can I save an attachment that is an email to my inbox?
 
Am Thu, 13 Apr 2006 09:37:20 -0700 schrieb Dmitry Streblechenko:

Thanks Dmitry.

So Matt69, the Redemption from www.dimastr.com provides you with a solution.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Sure, Attachment.EmbeddedMsg will return MessageItem in case of the
Safe*Item objects and RDOMail in case of an attachment from an RDOMail
object.
You can then copy that message to any folder.

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

"Michael Bauer" wrote in message
.. .
Am Wed, 12 Apr 2006 12:10:15 -0700 schrieb Dmitry Streblechenko:

Oh, I never realized that...

Is it possible to add the attachment as an embedded item and open it with
Redemption using the PR_ATTACH_DATA_OBJ property?

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


Note however that Application.CreateItemFromTemplate will wipe out all
the
sender related properties since CreateItemFromTemplate is meant to be
used
as a template for sending a new message.

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

"Michael Bauer" wrote in message
...
Am Tue, 11 Apr 2006 09:24:53 -0700 schrieb matt69:

In fact, saving the attachment as a file is the first step. You then

can
open that message via GetItemFromTemplate and copy it into any folder.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.vbOffice.net --


I would like to automate a workaround, but have no idea where to

start.
The
workaround is needed due to the following scenario:

I am working on a site where I cannot access my corporate email
account.
I
set up a rule to redirect my mail to my client email address, but

noticed
that I did not see who was also sent the email (either as To or CC).
So
I
changed to rule to forward the message as an attachment so that I can

see
all
recipients as well as having their email addresses (which you do not
get
if
you just forward the email).

I would like a now like a macro to run automatically when mail arrives
that
has been forwarded from my corporate email address. The macro would

copy
the
email attachment to my inbox and then delete the forwarded message.
All
I
can see in the VBA help is to save attachments to the file system, but
I
know
that I can drag and drop the email attachment from the forwarded
message
into
my inbox manually.

Any help is much appreciated, as I have never written VBA in Outlook
and
only a little in Excel.



All times are GMT +1. The time now is 08:44 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com