Option Explicit
Private Declare Function URLDownloadToFile _
Lib "urlmon" Alias "URLDownloadToFileA" _
(ByVal pCaller As Long, ByVal szURL As String, ByVal szFileName As String, _
ByVal dwReserved As Long, ByVal lpfnCB As Long) As Long
Sub GetMsg()
Dim olMsg As MailItem
On Error Resume Next
Set olMsg = ActiveExplorer.Selection.item(1)
DownloadLinkedFile olMsg
lbl_Exit:
Exit Sub
End Sub
Sub DownloadLinkedFile(olItem As MailItem)
Dim olEmail As Outlook.MailItem
Dim olInsp As Outlook.Inspector
Dim wdDoc As Object
Dim oRng As Object
Dim oLink As Object
Dim vAddr As Variant
Dim strFName As String
Dim strURL As String
Dim strLocal As String
Const strPath As String = "C:\ xxxxxx"
On Error Resume Next
With olItem
Set olInsp = .GetInspector
Set wdDoc = olInsp.WordEditor
Set oRng = wdDoc.Range
For Each oLink In oRng.hyperlinks
If Right(LCase(oLink.Address), 3) = "pdf" And _
Left(LCase(oLink.Address), 4) = "http" Then
vAddr = Split(oLink.Address, "/")
strFName = vAddr(UBound(vAddr))
strURL = oLink.Address
End If
Next oLink
End With
strLocal = strPath & strFName
If URLDownloadToFile(0, strURL, strLocal, 0, 0) = 0 Then
MsgBox strFName & " - downloaded"
Else
MsgBox strFName & " - download failed"
End If
lbl_Exit:
Set olInsp = Nothing
Set oRng = Nothing
Set oLink = Nothing
Exit Sub
End Sub