send an email attachment with mail merge to filtered records

[notconfident]

I want to run various filters on an Access Form then click a Command Button to send an email to all the Filtered Records. The email needs an attachment which is a mail merge document. The fields in the document come from the Form (or its underlying table) that you are viewing.
I have used a similar button to generate a standard email using the SendObject Method but I need the code to make each email unique in the attachment which will be a pre filled in application form with the members detail filled in from Mail Merge (or something similar).

 

[MazeWorX]

so .... whatcha got so far?

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>