Mail Merge VBA and One Drive Path Issue

  • The below code is from a mail merge VBA and the files (excel and word) are stored on my One Drive. The work the StrWorkbookName is a URL (per the below) which has to be and use a local path, as other users need to access the file outside of my network. The code cannot find the file if I use the URL, however, if I put the local C:Users/ path address rather than the URL, it works for me but not other users (as they do not have direct access). Anyone know of a fix? Thank you.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!