Using a code to generate a document/letter

[Conbaby]

I will have an excel spreadsheet which will have a column for recipients, a column with their address, a column with their account number and a code for a specific text that I would want in the body of the letter. The end results that I'm going for is that based on the letter code that is entered, a letter will be generated for that particular recipient, with their account number will also be populated.

I don't know if this can be create in a combination of Excel and Word or Access and Word. Any help is appreciated.

 

[mumps]

Perhaps you can do a little research on using "Mail Merge" in MS Word. It allows you to enter data stored in an Excel sheet on a letter document in Word.

 

[Conbaby]

Perhaps you can do a little research on using "Mail Merge" in MS Word. It allows you to enter data stored in an Excel sheet on a letter document in Word.

Yes I looked at mail merging. But I would have to open each word doc that correponded to the code entered into Excel, then select the recipients that have that code. I'm thinking to would be an access databases where I would like a particular letter with a unique code and execute the final product to generate several letters based on the code entered.