My database holds payment details for donations made by donors to our school. Once per year I need to send them an official receipt showing the total donated for the year, for tax purposes. This receipt is currently done via mail merge. I use a word template, laid out appropriately, and sourced to the table in access97. This works ok.
Now to the nitty gritty. I need to print a unique Receipt Number on the receipt. I assume this will need to be generated by the computer (access) at the time of mail merge, no dups etc.
How to go about this. I am still thinking it thru, but maybe the number assigned to the receipt needs to be captured in the database for reference.
And I am wondering how to go about this.
The solution will need to include the appropriate code.