Creating and saving correspondence

[Rats]

Hi I have a customer contact db (A2K).I need to regularly send out letters to clients based on a standard set of form letters. The letters are held in a table with a memo field being used to store the contents. A report is used to create the letter from the contents of the letters table and the clients table. This part I don't have any problems with. The problem occurs when I want to edit the contents of the letter and save the letter that I send in a correspondence sent table. I have tried all sorts of queries but every time I amend the letter I am actually amending the form letter.

How can I create a copy of the form letter, amend it and save it as a history of docos sent to the client.

Any help would be appreciated. Thankyou

Peter

 

[neileg]

I have an application that also uses standard letters. However, the way I have tackled this is to use Word templates and mailmerge the data with the template. The user can then edit the resulting Word document. I save the template reference in a diary table ( Sent type 'A' letter, 18 May 2005) but don't hold the actual document text in the application(not a user requirement). The user is responsible for saving the Word file in their client folder.

 

[Rats]

Hi Neil

Thanks for your reply. I had looked at that but was attempting to keep it all within Access. I suppose if I can't work this out I will end up going that way. Your help is appreciated.

Peter

 

[Rats]

Still working with this one without much luck. Has anyone any idea of how I can maintain a table of standard correspondence that can be selected but then have the contents edited for the current client and saved as a correspondence sent record but not alter the underlying table. I can do it by creating another memo field and copying and pasting the data but this is clumsy and I can't find VB code for duplicating the process.