Do not change data source name in the main merge document.

[ARY]

If a data source has been used in a different mail merge, that other main
document somehow is added [in brackets] to the data source name. It is
chaotic and troubling because the data source has been changed since the
other use.

Please don't do it.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...ea3&dg=microsoft.public.word.mailmerge.fields

 

[Doug Robbins - Word MVP]

Added [in brackets] where? While the Mail Merge main document, if it is
saved, will retain information about the data source, there is NO
information inserted into the data source itself about a main document with
which it has been used as the data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[ARY]

Where it appears:
After i select the data source, there is a pop-up box
The blue heading is "Select Table"
Under the "Name" column should appear my datasource name; it doesn't.
Instead there is the name of something else. It will the correct datasource,
despite the goofy title.

If i convert my excel datasource to .csv then i don't see that stuff. But i
should not have to perform "work around" when using two otherwise-compatible
Microsoft products.

Added [in brackets] where? While the Mail Merge main document, if it is
saved, will retain information about the data source, there is NO
information inserted into the data source itself about a main document with
which it has been used as the data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

If a data source has been used in a different mail merge, that other main
document somehow is added [in brackets] to the data source name. It is
chaotic and troubling because the data source has been changed since the
other use.

Please don't do it.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...ea3&dg=microsoft.public.word.mailmerge.fields

 

[Peter Jamieson]

A single Excel workbook can contain multiple "data sources" because each
worksheet can be a data source, and each "named range" can be a data source.
If you happen to have used your workbook to open a data source from
elsewhere as a "database" there will be a fairly odd-looking range name
associated with that.

All of these are listed in the dialog box that appears when you try to open
the workbook as a data source for Word. Could that explain what you are
seeing?

If i convert my excel datasource to .csv then i don't see that stuff. But
i
should not have to perform "work around" when using two
otherwise-compatible
Microsoft products.

Broadly speaking I would agree with that, but there is another factor here,
which is that Word gets its data from Excel using a method which is intended
to be independent of any particular program or software suite. Sometimes
when suite designers use that kind of thing, "seamless" operation can get
lost in the wash.

Peter Jamieson

Where it appears:
After i select the data source, there is a pop-up box
The blue heading is "Select Table"
Under the "Name" column should appear my datasource name; it doesn't.
Instead there is the name of something else. It will the correct
datasource,
despite the goofy title.

If i convert my excel datasource to .csv then i don't see that stuff. But
i
should not have to perform "work around" when using two
otherwise-compatible
Microsoft products.

Added [in brackets] where? While the Mail Merge main document, if it is
saved, will retain information about the data source, there is NO
information inserted into the data source itself about a main document
with
which it has been used as the data source.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

If a data source has been used in a different mail merge, that other
main
document somehow is added [in brackets] to the data source name. It is
chaotic and troubling because the data source has been changed since
the
other use.

Please don't do it.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the
"I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and
then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...ea3&dg=microsoft.public.word.mailmerge.fields