Hi,

I have a mail merge in a Word document up and running, linking to my Excel spreadsheet. It worked fine until I password protected my spreadsheet. Clearly the word doc can not merge the data from the spreadsheet as it is denying it access now that it is protected. Is there a work around this? Can I enter the password anywhere in the source information in Word?

Many thanks,

Matt