I am adding a marketing function to my database and am having trouble with the mail merge function.
I have created a query that joins my Client table with a marketing documents table. I filter my database by using a criteria form. The resultant group of clients are then merged to the letter (a DB report) and printed and a list of clients to whom the letter has been sent is produced.
This all works fine but the problem is I can't retain a record of the letter sent in a table for future reference. I have done a similar thing with other letters that worked but they were sent individually and not as a result of a query.
If some one could just point me in the right direction I would really appreciate it.
I have created a query that joins my Client table with a marketing documents table. I filter my database by using a criteria form. The resultant group of clients are then merged to the letter (a DB report) and printed and a list of clients to whom the letter has been sent is produced.
This all works fine but the problem is I can't retain a record of the letter sent in a table for future reference. I have done a similar thing with other letters that worked but they were sent individually and not as a result of a query.
If some one could just point me in the right direction I would really appreciate it.
