Saving email attachments in OUtlook using VBA

Can email attachments be saved WITHOUT opening the associated mail item using
VBA? There is an example in the VBA Help using the SaveAsFile Method but it
requires the Mail item to be open for it to work. If there is a way to save
the attachment without opening the email can someone please explain it to me.
Many thanks :-)

What do you mean with "without opening the email"? Do don´t need to
display the item but you will need a reference on it and for that it is
necessary, that OL is running.

--
Viele Grüße
Michael Bauer


"vbaffled" <vbaffled@discussions.microsoft.com> wrote in message
news2705C85-C244-4BFF-80DF-2E22E7BB4266@microsoft.com...
> Can email attachments be saved WITHOUT opening the associated mail
item using
> VBA? There is an example in the VBA Help using the SaveAsFile Method
but it
> requires the Mail item to be open for it to work. If there is a way to
save
> the attachment without opening the email can someone please explain it
to me.
> Many thanks :-)

The example given in Outlook VBA Help opens an email item and then carries
out the SaveAsFile method to save the attachment. However, it seems that this
only applies to emails that have been opened to be read.

I do have Outlook running and I have tried to reference the items with
attachment but given my earlier comment about being new to the language of
Outlook VBA, I have not been successful so far - hence my question.

Following on from my two earlier posts asking about (1) counting email items
in a folder and (2) counting the number of email items with attachments (for
which I thank you again for your input Michael), I have incorporated the help
you provided for those posts to allow me to count email items with
attachments.

My next step is to save those same emails with attachments without opening
them to be read (like the Outlook Help example).

Hope this clears up what I meant earlier. I appreciate your comments.

"Michael Bauer" wrote:

> What do you mean with "without opening the email"? Do don´t need to
> display the item but you will need a reference on it and for that it is
> necessary, that OL is running.
>
> --
> Viele Grüße
> Michael Bauer
>
>
> "vbaffled" <vbaffled@discussions.microsoft.com> wrote in message
> news2705C85-C244-4BFF-80DF-2E22E7BB4266@microsoft.com...
> > Can email attachments be saved WITHOUT opening the associated mail
> item using
> > VBA? There is an example in the VBA Help using the SaveAsFile Method
> but it
> > requires the Mail item to be open for it to work. If there is a way to
> save
> > the attachment without opening the email can someone please explain it
> to me.
> > Many thanks :-)
>
>

Ok thanks, now I understand.

If, e.g., your loop looks like this...

for each item in folder.items
' ... at this point you can call item.saveas already without having
to display it.

--
Viele Grüße
Michael Bauer


"vbaffled" <vbaffled@discussions.microsoft.com> wrote in message
news:B15F97E5-4A0A-4CB7-9961-1680B0770FC2@microsoft.com...
> The example given in Outlook VBA Help opens an email item and then
carries
> out the SaveAsFile method to save the attachment. However, it seems
that this
> only applies to emails that have been opened to be read.
>
> I do have Outlook running and I have tried to reference the items with
> attachment but given my earlier comment about being new to the
language of
> Outlook VBA, I have not been successful so far - hence my question.
>
> Following on from my two earlier posts asking about (1) counting email
items
> in a folder and (2) counting the number of email items with
attachments (for
> which I thank you again for your input Michael), I have incorporated
the help
> you provided for those posts to allow me to count email items with
> attachments.
>
> My next step is to save those same emails with attachments without
opening
> them to be read (like the Outlook Help example).
>
> Hope this clears up what I meant earlier. I appreciate your comments.
>
> "Michael Bauer" wrote:
>
> > What do you mean with "without opening the email"? Do don´t need to
> > display the item but you will need a reference on it and for that it
is
> > necessary, that OL is running.
> >
> > --
> > Viele Grüße
> > Michael Bauer
> >
> >
> > "vbaffled" <vbaffled@discussions.microsoft.com> wrote in message
> > news2705C85-C244-4BFF-80DF-2E22E7BB4266@microsoft.com...
> > > Can email attachments be saved WITHOUT opening the associated mail
> > item using
> > > VBA? There is an example in the VBA Help using the SaveAsFile
Method
> > but it
> > > requires the Mail item to be open for it to work. If there is a
way to
> > save
> > > the attachment without opening the email can someone please
explain it
> > to me.
> > > Many thanks :-)
> >
> >

Working fine now ...many thanks :-)


"Michael Bauer" wrote:

> Ok thanks, now I understand.
>
> If, e.g., your loop looks like this...
>
> for each item in folder.items
> ' ... at this point you can call item.saveas already without having
> to display it.
>
> --
> Viele Grüße
> Michael Bauer
>
>
> "vbaffled" <vbaffled@discussions.microsoft.com> wrote in message
> news:B15F97E5-4A0A-4CB7-9961-1680B0770FC2@microsoft.com...
> > The example given in Outlook VBA Help opens an email item and then
> carries
> > out the SaveAsFile method to save the attachment. However, it seems
> that this
> > only applies to emails that have been opened to be read.
> >
> > I do have Outlook running and I have tried to reference the items with
> > attachment but given my earlier comment about being new to the
> language of
> > Outlook VBA, I have not been successful so far - hence my question.
> >
> > Following on from my two earlier posts asking about (1) counting email
> items
> > in a folder and (2) counting the number of email items with
> attachments (for
> > which I thank you again for your input Michael), I have incorporated
> the help
> > you provided for those posts to allow me to count email items with
> > attachments.
> >
> > My next step is to save those same emails with attachments without
> opening
> > them to be read (like the Outlook Help example).
> >
> > Hope this clears up what I meant earlier. I appreciate your comments.
> >
> > "Michael Bauer" wrote:
> >
> > > What do you mean with "without opening the email"? Do don´t need to
> > > display the item but you will need a reference on it and for that it
> is
> > > necessary, that OL is running.
> > >
> > > --
> > > Viele Grüße
> > > Michael Bauer
> > >
> > >
> > > "vbaffled" <vbaffled@discussions.microsoft.com> wrote in message
> > > news2705C85-C244-4BFF-80DF-2E22E7BB4266@microsoft.com...
> > > > Can email attachments be saved WITHOUT opening the associated mail
> > > item using
> > > > VBA? There is an example in the VBA Help using the SaveAsFile
> Method
> > > but it
> > > > requires the Mail item to be open for it to work. If there is a
> way to
> > > save
> > > > the attachment without opening the email can someone please
> explain it
> > > to me.
> > > > Many thanks :-)
> > >
> > >
>
>