Re: Office 2007 & ODBC

Tech-Archive recommends: Speed Up your PC by fixing your registry

1. The data source is w/in sage (our finance program).

2. Word 2007 w/ SP2

3. Windows Vista, 32-bit

If I pull the data into either Excel or Access, and then create the mail
merge in word using that as the data source it works no troubles. Just can't
seem to get it to work with the ODBC.

"Peter Jamieson" wrote:

1. What is the data source?

2. Do you have Word 2007 SP2, or an earlier version of Word 2007?

3. Are you using Vista-64 bit, or perhaps another 64-bit version of Windows?

As far as point (2) is concerned, currently I only have Word 2007 Sp2 to
experiment with, and when I attempted an ODBC connection with Excel,
although the connection appeared to work fine, subsequent investigation
suggests that although it is an ODBC connection, Word is not going to
tell us what the connection string is.

Peter Jamieson

http://tips.pjmsn.me.uk

JWhitehead wrote:
I am trying to do a mail merge in MS Word 2007 from an ODBC source. I am able
to find the option to do so. I go through this, but when I get the end, it
tells me there is errors with the merge, and no data is showing from the
merge.

If I import the data from ODBC to Access, for example, it shows all 450
records correctly. I can then do the mail merge in Word from there. The only
thing is, if the data that I've imported into Access changes in the original
table(s), other than re-importing, how would I get it to show the updated
data?

I guess what I'm asking here...
Is there a way to do a mail merge in MS Word 2007 to an ODBC source, and
actually be able to view the records?

.

Relevant Pages

  • RE: Cannot Import data from Excel Through ODBC with Data Connection Wi
    ... I suggest that implement clientside ODBC tracing an look at the ... Close the Excel client application. ... The data source is given the name UserDB. ... On the Welcome page of the Data Connection Wizard I select ODBC DNS and ...
    (microsoft.public.access.externaldata)
  • RE: Cannot access German Excel file through ODBC
    ... Try ODBC trace to see how crystal report ... I work on an app that creates an Excel file through automation. ... generate some reports using the generated file as a data source. ...
    (microsoft.public.data.oledb)
  • Re: How to specify Excel sheet name as mail merge source
    ... (If you can set up the merge data source using VBA and OpenDataSource it may ... >> Excel data source: DDE, Converter, and ODBC. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Mail Merge problem with Word 2000
    ... To add to what Cindy has said, you need to be sure there are no blank rows ... Word 2000 uses a different default connection method to Excel, ... in Excel to use as my data source. ... IF you apply a named range to the data source, then you can use ODBC to ...
    (microsoft.public.word.newusers)
  • Re: If then else containing value not at the end or in the beginni
    ... ODBC, and you have the necessary bits of the Jet database engine on ... b.open your mail merge main document and disconnect from the data source. ... Now you either need some VBA, or you need a DATABASE field. ... Sub MyConnect() ...
    (microsoft.public.word.mailmerge.fields)