Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
harryedwards
 
Posts: n/a
Default Word 2002 cannot find its Excel data source for mail merge

Having recently got my computer back after a crash - and with no change in
the software being used - my mail merge documents have problems.

Now, when opening the document, I get a box saying: '[Word doc name] is a
mail merge main document. Word cannot find its data source, [Excel file
name].' Both Word and Excel file are in exactly the same place as they were
before. I use the 'Find Data Source' option to try and connect to the Excel
file again, but the box I get offers me options like '+ New SQL Server
Connection' rather than simply the file itself as before. I can browse to the
file from here and select it, but then I have to select a sheet from it -
something that has never happened before - and once I've done that the data
source is connected. However, this now means that I have to use US dates
rather than UK as query options, any zero value is now 12.00AM, and the
merged document won't include things like £ signs which appeared in the Excel
sheet. In short, it messes everything up. Oh, and even if I now save the
document with the newly connected data source, it won't be connected next
time I open it and I'll have to go through it all again.

As you may have worked out, all I want is for everything to be like it was
before! Why has it changed and what can I do about it?

Thanks in advance.
 
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
Unable to open excel data source for word mail merge Trisha Microsoft Word Help 0 October 18th 05 10:59 AM
insert Excel data into Word Mail Merge document RRemy Mailmerge 2 June 25th 05 04:52 PM
Underscore (_) will not always display in RTF files (Word 2002). David A Edge Microsoft Word Help 6 June 14th 05 10:39 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 09:02 AM


All times are GMT +1. The time now is 08:40 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"