 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / July 2006Record 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 KingKaos@hotmail.com What is the data source? (by "query", do you mean "Access Query" or something else?) Peter Jamieson > 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 [quoted text clipped - 7 lines] > Keith > KingKaos@hotmail.com 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 > What is the data source? (by "query", do you mean "Access Query" or > something else?) [quoted text clipped - 12 lines] >>Keith >>KingKaos@hotmail.com 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.  SignatureHope 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 > Yes - by a query in Access > [quoted text clipped - 25 lines] >>>Keith >>>KingKaos@hotmail.com Can you post the SQL version of the query here please? Peter Jamieson > Yes - by a query in Access > [quoted text clipped - 25 lines] >>>Keith >>>KingKaos@hotmail.com |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.