The dialog box appears once you save the document after changing the text datasource in a mailmerge ddocument and again re-opening the document.
The mentioned way didnot work for me. Do you have any other way of doing the same.
Peter Jamieson wrote:
Is this the dialog box titled "Text File Connection Parameters", whereyou get
08-Jan-10
Is this the dialog box titled "Text File Connection Parameters", where
you get to choose between Tab, Comma, or Other?
If not. please can you describe the dialog box you are seeing.
If it is, the only explanation I know is that Word sets up the
connection differently depending on whether or not it asked you to
"Confirm Data Source" after you originally selected the data source. The
two known reasons that Word would display the "Confirm Data Source"
dialog a
a. you checked Word Office Button-WOrd
Options-Advanced-General-Confirm File Format Conversion on Open
b. Word did not recognise the file type and format of the file you
were trying to use (it might do that if the file had an extension you
did not recognise)
If you did not do (a), and Word recognises the file type, then when you
set up the data source the first time, Word does not display the Confirm
Data Source dialog box and does not prompt for a delimiter. When you
close and re-open the file, Word only displays the "SQL warning" (and in
this case, it will probably show the real data source file path). It
does not ask for the delimiter.
If you did 9a) or Word odes not recognise the file format, after you
select the file when you set up the data source, you will see the
Confirm Data Source dialog. The chances are that here will only be one
option, namely "OLE DB Databases". You cannot avoid selecting it, click
OK, then see the "Text File Connection Parameters" box (twice, usually).
Then, when you save and re-open the document, you see the "SQL warning"
(probably showing a temp pathname rather than the real file path),
followed by the "Text File Connection Parameters" box.
So to fix that, you can try:
a. open your mail merge main document and go through all the
connection stuff.
b. select Mailings tab-Start Mailmerge-Normal Word Document
c. save and close the document
d. Uncheck Word Office Button-Word
Options-Advanced-General-Confirm File Format Conversion on Open
e. re-open your mail merge main document
f. re-connect to your data source
g. save and close your document.
(steps (a) to (c) may not be needed but are here just in case).
I would not be surprised if that was not enough to fix the problem but
a. it is what I'd try first
b. it would be useful to know whether it does or does not do the
trick, so please post back either way.
c. if it does not work, there are one or two other possibilities.
Peter Jamieson
http://tips.pjmsn.me.uk
On 08/01/2010 12:34, Subhasis wrote:
Previous Posts In This Thread:
On Friday, January 08, 2010 7:34 AM
Subhasis wrote:
Mail Merge Data source
Hi,
I am using text file as a datasource for mail merge in Word 2007. When I
changed the location of the file to another directory and at the time of
reassigning that path to the mail merge document a Dialog box is being show
asking for the Tab delimited value option. Even after saving and agian
opening the same document the dialog box still shows.
Please help me how can that dialog box will be avoided once after changing
the datasource and saving it ?
Thanks in advance
On Friday, January 08, 2010 11:31 AM
Peter Jamieson wrote:
Is this the dialog box titled "Text File Connection Parameters", whereyou get
Is this the dialog box titled "Text File Connection Parameters", where
you get to choose between Tab, Comma, or Other?
If not. please can you describe the dialog box you are seeing.
If it is, the only explanation I know is that Word sets up the
connection differently depending on whether or not it asked you to
"Confirm Data Source" after you originally selected the data source. The
two known reasons that Word would display the "Confirm Data Source"
dialog a
a. you checked Word Office Button-WOrd
Options-Advanced-General-Confirm File Format Conversion on Open
b. Word did not recognise the file type and format of the file you
were trying to use (it might do that if the file had an extension you
did not recognise)
If you did not do (a), and Word recognises the file type, then when you
set up the data source the first time, Word does not display the Confirm
Data Source dialog box and does not prompt for a delimiter. When you
close and re-open the file, Word only displays the "SQL warning" (and in
this case, it will probably show the real data source file path). It
does not ask for the delimiter.
If you did 9a) or Word odes not recognise the file format, after you
select the file when you set up the data source, you will see the
Confirm Data Source dialog. The chances are that here will only be one
option, namely "OLE DB Databases". You cannot avoid selecting it, click
OK, then see the "Text File Connection Parameters" box (twice, usually).
Then, when you save and re-open the document, you see the "SQL warning"
(probably showing a temp pathname rather than the real file path),
followed by the "Text File Connection Parameters" box.
So to fix that, you can try:
a. open your mail merge main document and go through all the
connection stuff.
b. select Mailings tab-Start Mailmerge-Normal Word Document
c. save and close the document
d. Uncheck Word Office Button-Word
Options-Advanced-General-Confirm File Format Conversion on Open
e. re-open your mail merge main document
f. re-connect to your data source
g. save and close your document.
(steps (a) to (c) may not be needed but are here just in case).
I would not be surprised if that was not enough to fix the problem but
a. it is what I'd try first
b. it would be useful to know whether it does or does not do the
trick, so please post back either way.
c. if it does not work, there are one or two other possibilities.
Peter Jamieson
http://tips.pjmsn.me.uk
On 08/01/2010 12:34, Subhasis wrote:
Submitted via EggHeadCafe - Software Developer Portal of Choice
XML/XPath Query On Attributes
http://www.eggheadcafe.com/tutorials...on-attrib.aspx