merge "hanging" for a record,

[Tig]

When I merge my database into my form letter, the records seem to hang up
somehow. Although all the records are there in the original form doc, they
aren't there in the new file. Plus, when checking the "view merged data"
button, it seems to show 2 identical record numbers so I have to hit the next
record button twice to make it continue to the next number. That's where it
stops merging into the new file. Any suggestions? This is the only database
that I have that does this...all the others work fine.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?VGln?=,

Which version of Word are we considering, here? And what kind of database
(Excel, Access, other)?

When I merge my database into my form letter, the records seem to hang up
somehow. Although all the records are there in the original form doc, they
aren't there in the new file. Plus, when checking the "view merged data"
button, it seems to show 2 identical record numbers so I have to hit the next
record button twice to make it continue to the next number. That's where it
stops merging into the new file. Any suggestions? This is the only database
that I have that does this...all the others work fine.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Tig]

The version is Office 2000....Word 2000....and an Access database same version.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?VGln?=,

Hah. Every time I think that I've seen it all, Word proves me wrong. Can't recall
ever coming across this problem, before...

Do you still the see the problem if you do the following:
- Start Word in Safe Mode: Windows START button. Run.
Type: winword.exe /a
Press ENTER

- Link to the Access database table in the new document Word presents to you

- Set up a test merge using the same fields you use in the form letter where
you're seeing the problem

The version is Office 2000....Word 2000....and an Access database same version.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail

 

[Tig]

Hi, That didn't work either. It got all the way past opening the Access
database and then Word gave me the "waiting for Access to accept DDE
commands...." before it hung.

I think I need to delete Office and completely re-install....

 

[Graham Mayor]

Re-installing rarely achieves anything, so don't do that!
See instead http://word.mvps.org/FAQs/AppErrors/ProbsOpeningWord.htm and
work through the measures listed

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?VGln?=,

It got all the way past opening the Access
database and then Word gave me the "waiting for Access to accept DDE
commands...." before it hung.

OK, let's first check whether Access is allowing DDE connections: Open
the database, then Tools/Options/Advanced and make sure "Ignore DDE
requests" is NOT activated.

If it's not, then there's likely a problem with DDE on your system that
could only be corrected by reformatting your drive and reinstalling all
your software.

You don't HAVE to use DDE to connect, however; you can use ODBC. So,
try this: activate the "Select method" checkbox in the Open Data source
dialog box. Now, after you choose the Access file, you'll get a list of
connection methods; select ODBC.

If your data is in a query, you'll need to click "Options" and activate
"views" in order to add queries to the list of tables.

Does that change anything?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail

 

[Tig]

For some reason none of that helped...I ended up having to restore my HP back
to an earlier time since the ODBC wasn't found in the registry....now it
works with the exception of that one record....for some reason I can't get
the merge to view that one, and when I complete a query merge, it says there
are no records that match...any suggestions on how to get that one record
found and merged?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?VGln?=,

For some reason none of that helped...I ended up having to restore my HP back
to an earlier time since the ODBC wasn't found in the registry....now it
works with the exception of that one record....for some reason I can't get
the merge to view that one, and when I complete a query merge, it says there
are no records that match...any suggestions on how to get that one record
found and merged?

Hmmm. Try exporting the table (or query result) to an Excel spreadsheet and/or a
delimited text file, then see if Word will merge to that.

If it will, then you may need to compact and repair the Access database. If it
won't, then we have to investigate what's "off" about that record.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[Tig]

Ok, stupid question now....I've only used merge with Access and not with
Excel...how exactly do I export to Excel...then into Word...and do I use the
same merge file that I created originally, or do I need to create a new mail
merge doc?

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?VGln?=,

Ok, stupid question now....I've only used merge with Access and not with
Excel...how exactly do I export to Excel...then into Word...and do I use the
same merge file that I created originally, or do I need to create a new mail
merge doc?

You use File/Export in Access to export the database data to another file
format. No need to actually open it in Excel or Notepad, unless you want to see
how it looks (and how that problem record has exported).

Then you need to go over "Open Datasource" - just as you've done to select the
Access mdb - to choose that file. You can test this in a new document, or try
it directly from the main merge document you've already been working with.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail