Reply
 
Thread Tools Display Modes
  #1   Report Post  
Matt Thorley
 
Posts: n/a
Default Mail Merge Issue With Office 97 - Excel Data Source

I have a user that has created a mail merge document using an excel
spreadsheet as the data source. Until recently he has been using the document
with no problems, unfortunately when he now opens the document it causes a
number of issues.

Firstly when the user loads the mail merge document in word 97 it takes a
long time to bring up an error message stating "word is taking a long time to
open this document, do you wish to continue waiting? Yes / No"
Either choice gives no response and the user is left with the egg timer on
screen. It is not possible to switch between word and excel and both programs
have to be closed by ending the task. Its also noted that when bringing up
task manager it states that excel is not responding.

Also until I reinstalled excel onto the users machine it was noted that
excel was unable to load fully after end task was performed, and after a full
system restart. Excel would simply wait with the egg timer when loading and
hang.

On the odd occassion I have managed to open the mail merge document but it
is not possible to switch between word and excel, excel just stays minimized
and is seen in the taskbar.

I have though been able to open the mail merge document on a different
workstation with office 2003 with no errors. I have yet had chance to try the
mail merge on a similar machine to the one which the user is having errors
with.

The user is running office 97 pro sr2b full installation on windows 98se
accessing a mail merge document via a mapped network drive. The network
client is novel netware 3.2 The workstation is roughly 3 years old and is a
celeron 900 with 256mb of sdram. User has had no other problems with the pc.
Also note that i have copied the database from the network drive to the local
machine to see if the issue was to do with the network but brings up the same
issues.

Sorry for the long post but I was trying to put in as much information as
possible so that this could be troubleshooted easier.

Any help would be appreciated, it maybe the case of me rebuilding the
machine which to be honest i would prefer not to do.

Thanks again

Matt Thorley
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

You might have to get a bit brutal and open the mailmerge main document in
Word 2003 and convert it back into an ordinary Word document, then save it
and then open that version of the document back 97 and reattach the
datasource

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"Matt Thorley" Matt wrote in message
...
I have a user that has created a mail merge document using an excel
spreadsheet as the data source. Until recently he has been using the
document
with no problems, unfortunately when he now opens the document it causes a
number of issues.

Firstly when the user loads the mail merge document in word 97 it takes a
long time to bring up an error message stating "word is taking a long time
to
open this document, do you wish to continue waiting? Yes / No"
Either choice gives no response and the user is left with the egg timer on
screen. It is not possible to switch between word and excel and both
programs
have to be closed by ending the task. Its also noted that when bringing up
task manager it states that excel is not responding.

Also until I reinstalled excel onto the users machine it was noted that
excel was unable to load fully after end task was performed, and after a
full
system restart. Excel would simply wait with the egg timer when loading
and
hang.

On the odd occassion I have managed to open the mail merge document but it
is not possible to switch between word and excel, excel just stays
minimized
and is seen in the taskbar.

I have though been able to open the mail merge document on a different
workstation with office 2003 with no errors. I have yet had chance to try
the
mail merge on a similar machine to the one which the user is having errors
with.

The user is running office 97 pro sr2b full installation on windows 98se
accessing a mail merge document via a mapped network drive. The network
client is novel netware 3.2 The workstation is roughly 3 years old and is
a
celeron 900 with 256mb of sdram. User has had no other problems with the
pc.
Also note that i have copied the database from the network drive to the
local
machine to see if the issue was to do with the network but brings up the
same
issues.

Sorry for the long post but I was trying to put in as much information as
possible so that this could be troubleshooted easier.

Any help would be appreciated, it maybe the case of me rebuilding the
machine which to be honest i would prefer not to do.

Thanks again

Matt Thorley



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
Printing Labels using Mail Merge with data from Excel Michael Mailmerge 2 January 27th 05 12:41 PM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 11:46 PM
how do i create a mail merge for email using excel as a data sourc AnnA Mailmerge 1 December 1st 04 01:57 AM
Mail Merge with no header row in the Excel Data Pam Mailmerge 1 December 1st 04 12:56 AM


All times are GMT +1. The time now is 05:25 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"