Mail Merge and Passwords on excel DB

Alison Flynn

Morning guys,


I've this excel database that is mail merged to a word document, both need to be password protected but the mail merge word document can't seem to access the excel DB once it's password protected, only when I remove the password on database.


Is there a reason for this or better still, a way around it to ensure both are password protected??


Thanks for helping, if you can!


Related Conversations
Matching date input to the formatted date display
Erikstg in Excel on
0 Replies
Can I use wildcards with the new FILTER function
StuLux23 in Excel on
9 Replies
Please guide
Amardeep1001 in Excel on
0 Replies
freeze panes, freezes more than I select
jhaynie in Excel on
1 Replies
Power Query/Pivot - Hours not in chronological order
Shahria3 in Excel on
1 Replies