I am currently in the process of moving our database over from MS Works 4.5 to Access 2003. The old system, designed some 11 years ago, is completely incompatible with office as you well know. My problem is the old system allowed the user to select a client row off of the spreadsheet in works, and it auto input their information into a document in works. For example, the spread sheet contained such fields as FirstName, LastName, Suffix, Address, CityStateZip. Then the various documents would look like the following:
To: <<FirstName>> <<LastName>> <<Suffix>>
Dear <<FirstName>>, we are pleased to inform you that you have finished <<Coursename>> on <<coursedate>>.
So on and so forth, you get the idea. The problem is when I've tried to do it using mail merge, it just wants to put in an entire table, or have to select each table each time. Is there any way to let it auto input certain fields from certain tables based on selected unique user id's i have created? I'd like to be able to select the user ID within the word docs I have that mimic the old works docs, but only put in that user's data. Also, it will be broken up throughout the document as one might figure. I can e-mail a blank copy of the database and some dummy letters to anyone who has a solution. Thanks much.