Saving Outlook attachments and links to attachments with VBA

Not open for further replies.

Chris Hewitt

New Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
Hello to all, I am a captain of a fairly large and active volunteer Ambulance corps just outside of a major metropolitan area.

Every few days I receive intelligence documents (as do - or should - almost all fire chiefs and peer ambulance captains in the US).

Informational ones come as PDF attachments but the really important ones come as URLs to the PDF file that expire and disappear in a few days (and some in hours).

The problem is that my day job often is so time consuming that I miss the critical PDF documents pointed to by the links.

What I could use help with is a SUB where I can pass a sender email address, Windows folder for documents to be saved in (and maybe a folder (with an option to search subfolders) or just default to the current INBOX). Then the macro will look for every email sent by that email address and save all the PDF attachments and if there is a link to a PDF file save that as well - maybe only look at unread messages to improve efficiency and speed.

Anyone able to help me out here?


PS. have lots of technical experience - started with VisiCalc way back when ... and now the gun for hire on Excel macro issue at a global investment bank. BUT I have no Outlook VBA experience and need this solution ASAP as I am missing too many important documents.
The macro here - Open All Hyperlinks in an Outlook Email Message - will open all links in a message. The run a script version works in a rule - put the sender address in it.

I have other macros that can save attachments off of email - you can put them together in to one.

That will open the link and as long as you don't need to do anything else, will download the file. If you are unable to set a default for downloads, you could use clickyes to respond to the dialog.
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
N Saving And Deleting Outlook Attachments with Unknown Error Message Outlook VBA and Custom Forms 1
T Saving Outlook 2010 email with attachments but read the email without Outlook Using Outlook 2
D Saving outlook emails in html and attachments Using Outlook 4
T Outlook 2007 alters date when saving attachments, windows 7. Using Outlook 5
Rupert Dragwater Background colors not saving in Outlook 365 Using Outlook 15
D Outlook 2016 Outlook not saving Sent Items Using Outlook 4
I Error saving screenshots in a custom form in outlook 2016, outlook 365 - ok in outlook 2013, outlook 2010 Outlook VBA and Custom Forms 5
V Saving attachment from outlook in My Documents Outlook VBA and Custom Forms 14
R Outlook 2010 Modify Style "Do not check spelling or grammar" not saving Outlook VBA and Custom Forms 0
R Outlook Office 365 not saving addresses Using Outlook 0
e_a_g_l_e_p_i question about saving my .pst so I can import it to my Outlook after I build a new system Using Outlook 10
J Outlook 2013 crashes saving VBA & clicking tools | digital signature Outlook VBA and Custom Forms 1
L Outlook DST (Daylight Saving Time) problem Using Outlook 0
F Using Outlook 2007 as an IMAP Mail Station Without Saving Data Locally Using Outlook 2
D File Lock issue when saving message from Outlook to new folder Using Outlook 1
K Printing & Saving Outlook Contacts Using Outlook 3
S trouble with Outlook 2010 saving sent emails Using Outlook 2
R Outlook 2007 QAT buttons not saving Using Outlook 2
C Exchange 2003 - Outlook 2003 - Calendar entries saving over each other Using Outlook 2
J Saving Published Outlook Form as msg Using Outlook 1
J Saving Incoming & Outgoing Outlook 2010 Email Locally with IMAP Using Outlook 2
R Saving Outlook Email As Text File Extract Outlook VBA and Custom Forms 2
D Outlook 2003 Saving into a textbox when form closes Outlook VBA and Custom Forms 3
T Saving Embedded Images in Outlook 2007 Outlook VBA and Custom Forms 3
D Outlook 2003 saving option button Outlook VBA and Custom Forms 1
R Saving Emails and Attachments as .msg file Using Outlook 3
CWM330 Saving Data: Don't check certain folders Using Outlook 2
M Saving emails using Visual Basic - Selecting folder with msoFileDialogFolderPicker Outlook VBA and Custom Forms 6
I Saving attachments from multiple emails and updating file name Outlook VBA and Custom Forms 0
M Adding Subject to this Link-Saving VBA Outlook VBA and Custom Forms 5
L Attachment saving and tracking - PLEASE help! Outlook VBA and Custom Forms 5
D Saving Selected Emails as PDF and saving Attachments Outlook VBA and Custom Forms 6
B Saving items under a folder Using Outlook 3
R Quick Access view in File Explorer when saving attachments Using Outlook 0
M Dialog called up multiple times when saving emails from macro Outlook VBA and Custom Forms 2
A saving attachement to folder named the same as rule name Outlook VBA and Custom Forms 0
T Saving all email to file folder in Windows Using Outlook 2
J Saving attachments from specific sender (phone number) to specific folder on hard drive Using Outlook 3
Kevin H Remotely saving emails Using Outlook 1
A Keep color categories when saving vCards Using Outlook 1
P Saving All Messages to the Hard Drive Using VBA Outlook VBA and Custom Forms 5
S Editing an email with notes and saving it for record using Macro Outlook VBA and Custom Forms 3
O Saving Attachments to folder on disk and adding Initials to end of file name Outlook VBA and Custom Forms 9
bifjamod Saving sent email to specific folder based on category with wildcard Outlook VBA and Custom Forms 1
N Saving .msg as sent item on send Outlook VBA and Custom Forms 1
erichamion Changes to meeting body not properly saving Outlook VBA and Custom Forms 4
A ItemAdd on Imap Folder get endless loop after saving item Using Outlook 5
T From Field Blank when saving to folder other than Sent items Using Outlook 2
E Saving Changes To Edited E-Mail Received Message Using Outlook 0
D Remove extension while saving attachments Using Outlook 1

Similar threads