Community
Showing results for 
Search instead for 
Do you mean 
Reply

Record 1 contains too few data fields

Copper Contributor
Posts: 48
Country: USA

Record 1 contains too few data fields

I have ACT! 2010 Premium, hot fixed through 3.  I'm relatively new here and not in charge of okaying the cost of updating software. 

 

We are using Office 2010.

 

I have designed a label and want to do a mail merge of our contact data into some labels for our salesman.  I build the connection through Word's Use an Existing List function.  The database connects, no problem. I'm only offered the main tables.

 

I should mention that I can connect to this database through Access 2003 and Excel 2010, no problem.  But when I go through Word, I get an error message (repeating) that says "Record 1 contains too few data fields" and "Record 2 contains too few data fields".  The only "fields that show up are M_____ and M1______.

 

Does anyone have any idea of what's going wrong? Should I try creating a machine datasource and connecting to that? Help appreciated.  I'm running out of hair.  Thanks.

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Record 1 contains too few data fields

Your main problem is that ACT! 2010 doesn't work with office 2010.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Contributor
Posts: 48
Country: USA

Re: Record 1 contains too few data fields

Yes, but Excel and I don't have problems.  I guess it's too much to expect Microsoft's suite of products to actually work the same way.

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Record 1 contains too few data fields

You need ACT! 2011 or later for compatibility with Word 2010.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Bronze Elite Contributor
Posts: 1,410
Country: United_Kingdom

Re: Record 1 contains too few data fields

All you need is a patch which costs around $20.00 from the company linked below.

 

http://www.designr1.com/shop/act-word-2010/