Outlook emails pulling attachments from Sharepoint

Hello all,
I have a script I built a couple years ago which creates emails in MS Outlook with predefined subject lines, addressees, and attachments. The end user can either run it to display or send. For 2 years it worked fine as I was referencing a simple shared folder for the required attachments. However, when my organization rolled out Sharepoint and upgraded the Office version we were on, the attachments started displaying as failed. I did of course update the file path to reference the Sharepoint Library the attachments were contained in. I do have permissions to that library and when I manually try to navigate to those locations, I have no problem doing so. The email still generates, but the file attachments display as "Download Failed" When I double click on them, it gives me a Retry option and when I select that the download actually succeeds.

My code is below for your reference, and I'm attaching a screenprint of the email output.

Please Login or Register  to view this content.

Yes, the values of those rngAttach1 and 2 are those links starting with "https://.

How would the code look to save the sharepoint file to a local temp drive?

Alternative is to use urlmon code found in link below.
https://stackoverflow.com/questions/...point-with-vba

Note that you'll need to make it 64bit compatible, if you have 64bit Excel installed.

Thanks, I'll see if I can get these working here. May be a couple days, but I'll get back to you on results.

Sorry for the delay; I did finally get it working, although I used slightly different code than your example above. Thanks for the help!

Thanks for the update. Glad you got it solved.

Could you please share the code you used for your problem? Thanks a lot for sharing

My vba sripts bugs in the line whttp.send
I do not know how to proceed
Thanks

Sure thing! Here's the code I have right now. I just manually run it each month from Outlook.

Please Login or Register  to view this content.

Thanks a lot! I have solved my problem