A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Record 1 contains too few data fields



 
 
Thread Tools Display Modes
  #1  
Old July 5th 06, 04:50 PM posted to microsoft.public.word.mailmerge.fields
KingKaos
external usenet poster
 
Posts: 2
Default Record 1 contains too few data fields

I've got Office 2003 Pro - trying to merge a query into word - I've had
not problems with it before (with other querys) but now - I keep getting
this error message - I've loaded all the hotfix files and patches and
attempted to follow one web site that had me change some of the registry
items - but nothing works - does anyone know if there is any way around
this - I can't even set up my mail merge doc with the query fields.

Thanks

Keith

Ads
  #2  
Old July 5th 06, 05:46 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default Record 1 contains too few data fields

What is the data source? (by "query", do you mean "Access Query" or
something else?)

Peter Jamieson

"KingKaos" wrote in message
...
I've got Office 2003 Pro - trying to merge a query into word - I've had
not problems with it before (with other querys) but now - I keep getting
this error message - I've loaded all the hotfix files and patches and
attempted to follow one web site that had me change some of the registry
items - but nothing works - does anyone know if there is any way around
this - I can't even set up my mail merge doc with the query fields.

Thanks

Keith



  #3  
Old July 5th 06, 08:43 PM posted to microsoft.public.word.mailmerge.fields
KingKaos
external usenet poster
 
Posts: 2
Default Record 1 contains too few data fields

Yes - by a query in Access

This is really strange - but it I added a field to my Query that was
spaced - eg. If I used Client Name, instead of ClientName - Word would
give me the "Record 1 contains too few data field" message and not let
me use mail merge - I would still like to fix this problems - I have
several table and a few querys that I would completely have to redo to
make this work correnctly (without the spaces)

does any of this make any sense?

Thanks
Keith
Peter Jamieson wrote:
What is the data source? (by "query", do you mean "Access Query" or
something else?)

Peter Jamieson

"KingKaos" wrote in message
...

I've got Office 2003 Pro - trying to merge a query into word - I've had
not problems with it before (with other querys) but now - I keep getting
this error message - I've loaded all the hotfix files and patches and
attempted to follow one web site that had me change some of the registry
items - but nothing works - does anyone know if there is any way around
this - I can't even set up my mail merge doc with the query fields.

Thanks

Keith




  #4  
Old July 6th 06, 12:25 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,832
Default Record 1 contains too few data fields

If you have a field in the Access query with the name Client Name as two
words, Word is seeing that as two fields when in fact the data for is
containined in just one field.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"KingKaos" wrote in message
...
Yes - by a query in Access

This is really strange - but it I added a field to my Query that was
spaced - eg. If I used Client Name, instead of ClientName - Word would
give me the "Record 1 contains too few data field" message and not let me
use mail merge - I would still like to fix this problems - I have several
table and a few querys that I would completely have to redo to make this
work correnctly (without the spaces)

does any of this make any sense?

Thanks
Keith
Peter Jamieson wrote:
What is the data source? (by "query", do you mean "Access Query" or
something else?)

Peter Jamieson

"KingKaos" wrote in message
...

I've got Office 2003 Pro - trying to merge a query into word - I've had
not problems with it before (with other querys) but now - I keep getting
this error message - I've loaded all the hotfix files and patches and
attempted to follow one web site that had me change some of the registry
items - but nothing works - does anyone know if there is any way around
this - I can't even set up my mail merge doc with the query fields.

Thanks

Keith




  #5  
Old July 6th 06, 07:48 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,583
Default Record 1 contains too few data fields

Can you post the SQL version of the query here please?

Peter Jamieson

"KingKaos" wrote in message
...
Yes - by a query in Access

This is really strange - but it I added a field to my Query that was
spaced - eg. If I used Client Name, instead of ClientName - Word would
give me the "Record 1 contains too few data field" message and not let me
use mail merge - I would still like to fix this problems - I have several
table and a few querys that I would completely have to redo to make this
work correnctly (without the spaces)

does any of this make any sense?

Thanks
Keith
Peter Jamieson wrote:
What is the data source? (by "query", do you mean "Access Query" or
something else?)

Peter Jamieson

"KingKaos" wrote in message
...

I've got Office 2003 Pro - trying to merge a query into word - I've had
not problems with it before (with other querys) but now - I keep getting
this error message - I've loaded all the hotfix files and patches and
attempted to follow one web site that had me change some of the registry
items - but nothing works - does anyone know if there is any way around
this - I can't even set up my mail merge doc with the query fields.

Thanks

Keith




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
No of fields in a Data Source syfam Mailmerge 1 February 23rd 06 05:04 PM
Merge data fields Valerie Mailmerge 3 January 19th 06 09:16 PM
Populate Merge Fields via VB.NET ben Mailmerge 5 June 21st 05 05:43 PM
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 06:10 AM
posting data from text input fields to fields later in document BOB Microsoft Word Help 1 November 23rd 04 07:19 PM


All times are GMT +1. The time now is 12:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.