Mail merge problem

[Affendi]

Hi,

In need of help. I tried to do a mail merge from a query. I get " record 1 has too few fields " when I select the query to merge. My query has a parameter specifying a date.

Thanks

Affendi

[NTC]

let's start with the query. run that all by itself. does it work?

[Affendi]

I've run the query by itself, it works fine. Tried over again to do a mail- merge, I got the same message as before. Hoping that you can guide me.

Thanks.

[NTC]

Then it sounds like the Word doc/template - was originally built with a field insert (merge data from the query) that it is not finding in your query.

Possibly a typo, a change in the query, or something.

The easiest thing may be to re-make a new Word doc/template on your query.

[Affendi]

Hi,

I've tried creating a new document to link the data, run the query by itself, checked for any typos... still I get the response

" Record 1 has too few fields "
" Record 2 has too few fields "



Any other way I can get this done?

[NTC]

It doesn't seem to be an Access error message that I've seen.....so if no joy here - start a post at a Word forum where there will be alot of Word merge Q&A....

[thhui]

Try creating a new data from the query you generate into a table instead.
Let the word document link with this table to achieve the mail-merge.

It will then work.