Solved

saving attachments in a specific folder in outlook 2010.

Posted on 2014-09-17
11
369 Views
Last Modified: 2014-09-26
Hi;

I have a folder in outlook 2010 in which I store specific mails and i want to extract those attachments which are pdf files having exact same names into a folder in my computer, Windows 7.

So, the idea is to rename the pdf, say 1,2,3..pdf to a folder.

What to do?

Regards.
0
Comment
Question by:jazzIIIlove
  • 4
  • 3
  • 2
  • +1
11 Comments
 
LVL 52

Expert Comment

by:Joe Winograd, EE MVE
ID: 40328564
I have Outlook 2013, but it's probably the same, or very similar in Outlook 2010. Right-click on the attachment and you should see two options in the context menu:

Save As
Save All Attachments...

Select one of those and then browse to the folder where you want the attachments stored on your W7 computer. Regards, Joe
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 40328580
Hi Joe,

Thanks for the reply but we are talking about around 200 mails, all having the same pdf naming, not one mail.

Regards.
0
 
LVL 52

Expert Comment

by:Joe Winograd, EE MVE
ID: 40328639
OK, didn't realize that from the original post. Here's one idea. I've been using a product called MessageSave from TechHit for a long time. It is fantastic! They offer another product called EZDetach:
http://www.techhit.com/ezdetach/outlook_attachments.html

I haven't used it, but based on my many years of success with MessageSave, I wouldn't hesitate to give it a spin — and there's a 30-day free trial, so you can see if it works for you before buying it. Regards, Joe
0
 
LVL 76

Expert Comment

by:David Lee
ID: 40330145
Hi, jazzIIIlove.

Does each email have just the one attachment?
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 40331446
Yes, one attachment and same name and extension, pdf

They are products of scanning.

Regards.
0
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
LVL 13

Expert Comment

by:Alexei Kuznetsov
ID: 40332862
Since Outlook can't do this out of the box, you have two options here:
1. Write a VBA script that does what you want to do.
2. Use a third-party product like Joe mentioned or another one. I personally can recommend (as one of its developers) our free Save Attachments utility. It does exactly what you need: you can specify *.pdf as a file mask and the utility will save all your attachments renaming ones with the same names by appending a counter.
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 40339931
Hi thims;

It seems it's not free but comes with ReliefJet Essentials for Microsoft Outlook. (Correct me for the download link if possible).

Once I downloaded the  ReliefJet Essentials for Microsoft Outlook and use Save Attachments tools. It does only for 10 attachment and it hangs, seen.

hangs
Any comment?

Regards.
0
 
LVL 76

Accepted Solution

by:
David Lee earned 250 total points
ID: 40340059
Hi, jazzIIIlove.

This macro will extract all the PDFs from all the items in the currently selected folder.  Follow these instructions to use this macro.

1.  Start Outlook
2.  Press ALT+F11 to open the Visual Basic Editor
3.  If not already expanded, expand Microsoft Office Outlook Objects
4.  If not already expanded, expand Modules
5.  Select an existing module (e.g. Module1) by double-clicking on it or create a new module by right-clicking Modules and selecting InsertModule
6.  Copy the code from the code snippet box and paste it into the right-hand pane of Outlook's VB Editor window
7.  Edit the code per the comments I included in it
8.  Click the diskette icon on the toolbar to save the changes
9.  Close the VB Editor
10. Select the folder with the messages containing the PDFs you want to export
11. Run the macro ExtractAllPDF

Sub ExtractAllPDF()
    'On the next line, edit the path to the folder you want to save the extracted PDFs in.  The path must end with a \
    Const SAVE_TO_FOLDER = "c:\users\david\documents\testarea\jazzIIIlove\"
    Const MACRO_NAME = "Extract All PDF Files"
    Dim olkFld As Outlook.Folder, olkMsg As Object, olkAtt As Outlook.Attachment, lngCnt As Long
    lngCnt = 1
    Set olkFld = Application.ActiveExplorer.CurrentFolder
    For Each olkMsg In olkFld.Items
        For Each olkAtt In olkMsg.Attachments
            If Right(LCase(olkAtt.Filename), 4) = ".pdf" Then
                olkAtt.SaveAsFile SAVE_TO_FOLDER & lngCnt & ".pdf"
                lngCnt = lngCnt + 1
            End If
        Next
    Next
    MsgBox "PDF extraction complete.", vbInformation + vbOKOnly, MACRO_NAME
End Sub

Open in new window

0
 
LVL 13

Expert Comment

by:Alexei Kuznetsov
ID: 40341616
jazzIIIlove, this error is the trial limitation. Free Save Attahments tool can be downloaded from the bottom of the page I mentioned (Download "Save Attachments" link).
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 40345696
Hi thims;

Thanks but I'd like to prefer to follow BlueDevilFan's path.

I couldn't find where I should run the macro for that given folder as in the attachment, where.jpg

Regards.
where.jpg
0
 
LVL 13

Assisted Solution

by:Alexei Kuznetsov
Alexei Kuznetsov earned 250 total points
ID: 40345700
Actually this macro uses the currently selected folder. So just select this folder in Outlook and run the macro. The easy way here is to enable "Developer" tab on the ribbon (right-click the ribbon, select Customize... and check the Developer in the right list). After that you'll be able to run macros right from the ribbon (Macros button).
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
MS Outlook is a world-class email client application that is mainly used for e-communication globally.  In this article, we will discuss the basic idea about MS Outlook, its advanced features, and types of MS Outlook File formats.
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.
Sometimes we receive PDF files that are in the wrong orientation. They may be sideways or even upside down. This most commonly happens with scanned or faxed documents. It is possible to rotate the view of these PDFs with the free Adobe Reader produc…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now