Give a letter automaticly a letter-number and put it in an Access.

[challie]

If I make a letter I have to give it a documentnumber in a separate
Access-file. Is it possible to give automaticly a number to the outgoing
letter and automaticty put this number in a Access-database and in the same
record of that number should be automaticly take over from the Word document:
name, address, zip code, town, subject, date of sending. All this items are
allready typed in the Word document. Afterwards you can look for a document
in the Access database, click on it and enter your letter.

Perhaps something like this exists already?

 

[SusanV]

Hi Challie,

Use a Word Form as a template for your letter. Then you can send the
information entered into the Word form's fields directly into Access.
http://www.microsoft.com/technet/prodtechnol/office/office2000/tips/msw9741.mspx

This isn't a very good article, I wish I could find the one I used a few
years back, and to be honest I can't remember exactly how I did this. =/

 

[SusanV]

Ah, a bit more digging and I found the article I think you need:
http://cma.zdnet.com/guides/qa_access/Office_Integration,_Exchanging_Data/IMA_042001_014.html