I figured out part of this...

I changed

Documents.Open FileName:="\\JM\USERS\USERS\SHARED\WordDrop\Administration\Hotel Rates.doc"

to

Documents.Open FileName:="\\JM:USERS:USERS:SHARED:WordDrop:Administration:Hotel Rates.doc"

The error message that it can't find the file is gone and the macro doesn't go into debug... However, it doesn't open the file either...