Saving email attachments in OUtlook using VBA

[Guest]

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

 

[Michael Bauer]

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.

 

[Guest]

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]

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.

 

[Guest]

Working fine now ...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.