Mail Merge to Word

[indyaries]

Mail Merge to Word

Here is my dilemma…

I have a MS Word form called Civilian Performance Plan, and I have a database in Access 97 that I wish to export into this Word form.

There is employee information and Performance Plan information in the Word form. In Access I am using two tables; t_Employees and t_Performance_Plan. These tables are linked One to One on the EmployeeID field.

The Word 97 form has fields that would use data from t_Employees (Name, Position, Grade, SSN, etc.) and Performance Plan fields (Job Elements, Critical element, Performance Standards, etc.)

Example: Job Element 1-Customer Support & Publications
Critical Element (CE) = Y
Performance Standards: This section of the Performance Plan can have several paragraphs.

There is only a finite amount of space on these forms for information.

How can I;

1. Force Access to place the Employee information only once on the Word form.
2. Have Access loop through the other fields to place onto the Word form.
3. Ensure that the text of the Performance Standards field does stays within the constraints of the Word form. The Performance Standards field is a MEMO field in Access.

Thank you for your assistance!!!!!

Bob

 

[vangogh228]

Bob:

I'm not sure exactly what you're trying to do. I don't understand the "How can I" points you made.

However, if you write a query in your Access database that properly pulls the information you need, you can write the merge document in Word and, in the merge dialog box, select the query as your data source. Then you just insert the merge fields where you need them. That ALWAYS works for me.