Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Do not change data source name in the main merge document.
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/comm...merge.fi elds |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Do not change data source name in the main merge document.
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" wrote in message ... 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/comm...merge.fi elds |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Do not change data source name in the main merge document.
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. "Doug Robbins - Word MVP" wrote: 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" wrote in message ... 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/comm...merge.fi elds |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Do not change data source name in the main merge document.
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 "ARY" wrote in message ... 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. "Doug Robbins - Word MVP" wrote: 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" wrote in message ... 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/comm...merge.fi elds |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge with separate Source Header document | Mailmerge | |||
Add checkboxes with macro in Merge document? | Tables | |||
change a main doc into a data source | Mailmerge | |||
Data Files Not "Attached" to Mail Merge Main Document | Mailmerge | |||
merge data into graph in main merge document | Mailmerge |