Mail merge

You need to change the code to make the path more generic. Since you haven't given any details about the paths in question, though, I can't be more specific.

Well, I have a word document and when I set up merged fields it references the data source path on my hard drive IE: C://my_computer_name/my_documents/my_excel_spreadsheet
so when we open it on another computer it's the wrong path. I have a button with a script that opens the word doc with the merged fields and also opens Outlook:

Sub APP_EMAIL_OUTLOOK()
Shell ("OUTLOOK")
Dim pdf As String

    On Error Resume Next

    'pdf file to open
    pdf = "MAIL_MERGE/word.docx"

    'open the pdf file
    ActiveWorkbook.FollowHyperlink pdf
    
End Sub

That works just fine. It's the data source for the merged fields that is not found on any computer but the one the merged fields were setup on.

For all the users concerned to access the data source, it would have to be stored in a network folder they all have access to - and the mailmerge main document configured to use that file. Simply giving them a copy of the data source won't work.