Hello all,
I have an issue that I know has been beat to death but I can't seem to get anything to work.
Here is the current situation: I am working on a database for credit card disputes. I have 3 tables as follows - Customer, All Disputes, Dispute Details. They all have a one to many relationship (ex-one customer can have many cards (and in turn multiple disputes) and those disputes can involve multiple merchants (dispute details).
I have a form to enter new customer information. It contains a datasheet subform for their disputes and when you select a dispute, the bottom most subform displays the details of that dispute. (Entry form>All Disputes subform>Dispute Details subform).
My problem is that I want a button on the form that will pass the information to word as a mail merge. I currently have it setup that the button will open a saved mail merge doc, and run a macro that will go to the last record of the mail merge and print. Very simple, but inneffective if you want to print the current record the form is looking at.
I've been trying to use Albert D. Kallal's super simple mail merge; but it's innefective as it is only pulling the customer information from the form for the merge. Is there a way to 'tell' word what mail merge record I'm on for it to print? The mail merge is already set up and tied to the database via a query in Access.
(This is me right now = :banghead
Any thoughts??? Sorry for the book and thanks in advance....
I have an issue that I know has been beat to death but I can't seem to get anything to work.
Here is the current situation: I am working on a database for credit card disputes. I have 3 tables as follows - Customer, All Disputes, Dispute Details. They all have a one to many relationship (ex-one customer can have many cards (and in turn multiple disputes) and those disputes can involve multiple merchants (dispute details).
I have a form to enter new customer information. It contains a datasheet subform for their disputes and when you select a dispute, the bottom most subform displays the details of that dispute. (Entry form>All Disputes subform>Dispute Details subform).
My problem is that I want a button on the form that will pass the information to word as a mail merge. I currently have it setup that the button will open a saved mail merge doc, and run a macro that will go to the last record of the mail merge and print. Very simple, but inneffective if you want to print the current record the form is looking at.
I've been trying to use Albert D. Kallal's super simple mail merge; but it's innefective as it is only pulling the customer information from the form for the merge. Is there a way to 'tell' word what mail merge record I'm on for it to print? The mail merge is already set up and tied to the database via a query in Access.
(This is me right now = :banghead
Any thoughts??? Sorry for the book and thanks in advance....