Data Source issue

Hi all,

I am trying to create a mail merge from the contents of an excel database with a built in user form. Have got the fields sorted for the merge, have got the form feeding the database, which connects to the merge, and everything works fine when i test it.

I have set up a button in excel which opens the userform, and a button on the userform which opens the merge, but i can’t get the merge to automatically link up with the open database. Any ideas out there would be gratefully received!