Mail merge error

Question

Notes on problem with mail merge:

1. I click on the mail merge doc I want (i.e., Aut-Labels mail merge)
2. I get message: “Opening this document wil run the following SQL command: SELECT *FROM ‘Office Address List’

Data from your database will be place in the document.  Do you want to continue? Yes or No

1. I click YES and I get:  Error has occurred: No value given for one or more required parameters.
2. I click OK and I get: ___ is a mail merge main document.  Word cannot find its data source, i.e., C...|MM Patty Aut List.mdband it gives me two options:
   1. Find Data Source, or
   2. Options
   3. I usually click on Find Data Source, which takes me to:
   4. All Data Sources, and I choose the one I want.

So, I normally wouldn’t go through all this but if I’ve moved a column or deleted one in Access, it starts giving me this trouble.

Also, when I open the Edit the Recipient List to choose a particular person(s) for a particular letter, the box puts my columns out of the order I created them in.

Answer 1

Deleting database fields/tables used for the merge is bound to cause problems. If you've done that, answer 'no' at the SQL prompt and re-do the mailmerge setup.