I have a two-part question.
My data base is set up to track donations from individual members. One table collects relevant informaition on the donor (ie: name, address, etc..) then I have individual tables set up for each different donation event (ie: general donation, capital campaign, direct mail, etc..) everything is linked by the primary key (simple auto-generated number).
I already have queries that help me generate reports on who gave how much for what event. What I need assistance with is setting up an automatic method for printing thank you letters. Currently, when the user logs out, a pop up box reminds the user to print out thank you letters and. I would like that when the user clicks on the OK button on the pop up message box that the system looks for current entries, creates a temporary table with those entries and then merges the pertinent data with a specific thank you letter and mailing lables.
The second part is to auto check the "thank you sent" check box to true on the specific donation table to show that a thank you was sent to the donor.
Your assistance in this matter will be most appreciated.
My data base is set up to track donations from individual members. One table collects relevant informaition on the donor (ie: name, address, etc..) then I have individual tables set up for each different donation event (ie: general donation, capital campaign, direct mail, etc..) everything is linked by the primary key (simple auto-generated number).
I already have queries that help me generate reports on who gave how much for what event. What I need assistance with is setting up an automatic method for printing thank you letters. Currently, when the user logs out, a pop up box reminds the user to print out thank you letters and. I would like that when the user clicks on the OK button on the pop up message box that the system looks for current entries, creates a temporary table with those entries and then merges the pertinent data with a specific thank you letter and mailing lables.
The second part is to auto check the "thank you sent" check box to true on the specific donation table to show that a thank you was sent to the donor.
Your assistance in this matter will be most appreciated.
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
