#1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mary Mary is offline
external usenet poster
 
Posts: 138
Default Data Source

I have 4 different mail merge letters with 4 different data sources. The
first one comes out fine. The next one defaults back to the first data
source, and I can't get it to stop doing that. I know I have selected the
correct file, so it's not a user error. Any suggestions?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Data Source

Which version of Word?

What type of file is the data source?

Does Word display a message when you open the mail merge main document,
and if so, in that message, can you see the full path name of the file
it says it is trying to open?


Peter Jamieson

http://tips.pjmsn.me.uk

Mary wrote:
I have 4 different mail merge letters with 4 different data sources. The
first one comes out fine. The next one defaults back to the first data
source, and I can't get it to stop doing that. I know I have selected the
correct file, so it's not a user error. Any suggestions?

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mary Mary is offline
external usenet poster
 
Posts: 138
Default Data Source

I'm using Word 2003. The data source is an Excel spread sheet with just
first and last names. I see the file name and path it is supposed to open,
but it opens a file I used yesterday, and I can't get it to stop doing that.

"Peter Jamieson" wrote:

Which version of Word?

What type of file is the data source?

Does Word display a message when you open the mail merge main document,
and if so, in that message, can you see the full path name of the file
it says it is trying to open?


Peter Jamieson

http://tips.pjmsn.me.uk

Mary wrote:
I have 4 different mail merge letters with 4 different data sources. The
first one comes out fine. The next one defaults back to the first data
source, and I can't get it to stop doing that. I know I have selected the
correct file, so it's not a user error. Any suggestions?


  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Data Source

Try the following:
a. do what you need to let the document open
b. enable the mailmerge toolbar (View-Toolbars)
c. click the first button and select the "Normal Word document"
option. This disconnects any data source from the mail merge main document.
d. If you want, save, close and re-open the mail merge main document
at this point.
e. now go through the process of connecting to your data source again.
f. save and close the document.
g. re-open, and see if that has fixed the problem.

(One problem with word is that once it has decided that the data source
is invalid, if you try to change it, Word seems to forget the new data
source when you save the file. Whether that is the problem in this case
I cannot tell).

Peter Jamieson

http://tips.pjmsn.me.uk

Mary wrote:
I'm using Word 2003. The data source is an Excel spread sheet with just
first and last names. I see the file name and path it is supposed to open,
but it opens a file I used yesterday, and I can't get it to stop doing that.

"Peter Jamieson" wrote:

Which version of Word?

What type of file is the data source?

Does Word display a message when you open the mail merge main document,
and if so, in that message, can you see the full path name of the file
it says it is trying to open?


Peter Jamieson

http://tips.pjmsn.me.uk

Mary wrote:
I have 4 different mail merge letters with 4 different data sources. The
first one comes out fine. The next one defaults back to the first data
source, and I can't get it to stop doing that. I know I have selected the
correct file, so it's not a user error. Any suggestions?

  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mary Mary is offline
external usenet poster
 
Posts: 138
Default Data Source

I was really hoping that would work, but unfortunately, it did not.

"Peter Jamieson" wrote:

Try the following:
a. do what you need to let the document open
b. enable the mailmerge toolbar (View-Toolbars)
c. click the first button and select the "Normal Word document"
option. This disconnects any data source from the mail merge main document.
d. If you want, save, close and re-open the mail merge main document
at this point.
e. now go through the process of connecting to your data source again.
f. save and close the document.
g. re-open, and see if that has fixed the problem.

(One problem with word is that once it has decided that the data source
is invalid, if you try to change it, Word seems to forget the new data
source when you save the file. Whether that is the problem in this case
I cannot tell).

Peter Jamieson

http://tips.pjmsn.me.uk

Mary wrote:
I'm using Word 2003. The data source is an Excel spread sheet with just
first and last names. I see the file name and path it is supposed to open,
but it opens a file I used yesterday, and I can't get it to stop doing that.

"Peter Jamieson" wrote:

Which version of Word?

What type of file is the data source?

Does Word display a message when you open the mail merge main document,
and if so, in that message, can you see the full path name of the file
it says it is trying to open?


Peter Jamieson

http://tips.pjmsn.me.uk

Mary wrote:
I have 4 different mail merge letters with 4 different data sources. The
first one comes out fine. The next one defaults back to the first data
source, and I can't get it to stop doing that. I know I have selected the
correct file, so it's not a user error. Any suggestions?




  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Data Source

Oh well.

What happens if you create a completely new word document, then try to
connect it to this data source?

Peter Jamieson

http://tips.pjmsn.me.uk

Mary wrote:
I was really hoping that would work, but unfortunately, it did not.

"Peter Jamieson" wrote:

Try the following:
a. do what you need to let the document open
b. enable the mailmerge toolbar (View-Toolbars)
c. click the first button and select the "Normal Word document"
option. This disconnects any data source from the mail merge main document.
d. If you want, save, close and re-open the mail merge main document
at this point.
e. now go through the process of connecting to your data source again.
f. save and close the document.
g. re-open, and see if that has fixed the problem.

(One problem with word is that once it has decided that the data source
is invalid, if you try to change it, Word seems to forget the new data
source when you save the file. Whether that is the problem in this case
I cannot tell).

Peter Jamieson

http://tips.pjmsn.me.uk

Mary wrote:
I'm using Word 2003. The data source is an Excel spread sheet with just
first and last names. I see the file name and path it is supposed to open,
but it opens a file I used yesterday, and I can't get it to stop doing that.

"Peter Jamieson" wrote:

Which version of Word?

What type of file is the data source?

Does Word display a message when you open the mail merge main document,
and if so, in that message, can you see the full path name of the file
it says it is trying to open?


Peter Jamieson

http://tips.pjmsn.me.uk

Mary wrote:
I have 4 different mail merge letters with 4 different data sources. The
first one comes out fine. The next one defaults back to the first data
source, and I can't get it to stop doing that. I know I have selected the
correct file, so it's not a user error. Any suggestions?

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
How to link a different Mailmerge header source and data source? Eleni_Malli Mailmerge 1 May 3rd 06 02:08 PM
data form button greyed out in word 97 data source Busylady Mailmerge 0 September 15th 05 10:00 PM
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM
How do I move data Colums within the data source of a mail merge hf Microsoft Word Help 1 July 5th 05 09:57 PM
data in mail merge letter being cut off - data source field size? tgone Mailmerge 1 May 20th 05 02:10 PM


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