Printing mailmerge documents from excel using vba

Hi All

I have built a project with Excel as a frontend and Access as a backend. Now there is a Print button in a form and there is a letter written in word document so based on certain criteria I want to print mailmerge documents from Excel.

I have never done this thing before so I hope anyone can help me to figure out my problem.

Thanks

Can anyone please change the code to make it working? Similar type of code was working in Access but not in excel.

Please Login or Register  to view this content.

Thanks

Basically I am looking for a way to pass an access query from Excel to mail merge document.

Please help me to solve my problem.