Word 2007 Mail Merge to SQL 2005 error

D

DFarrer

Hello

I am trying to use a SQL view for mail merge. When I attempt to connect, I
get two error messages that says there are too few data fields, then the Mail
Merge Recipiant dialog box opens and displays the path to the .odc data
source file rather than using it to access SQL. It is like Word 2007 is
attempting to read the odc file as a source file rather than using it to
connect to SQL. Yet, interestingly it displays the path and the header says
'data source.'

Yet, when I use the exact same ODBC dataconnection in Excel 2007, it opens
with no problems.

Has anyone else attempted to use Mail Merge to SQL 2005? Microsoft can you
duplicate this bug and do you have a solution?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge skipping records/sending one at a time 0
Windows 2016- Unable to do mail merge with my secondary email accounts 1
Mail Merge query 1
Mail Merge - displaying a conditional number of decimals 5
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Mail Merge Word Doc over SSL VPN 0
Mail Merge Different Photos - Word 2013 Headache! 1
Error message with Publisher 2007 Catalog Merge to SQL 2005 2

Top