A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Word cannot find data source problem



 
 
Thread Tools Display Modes
  #21  
Old July 30th, 2008, 06:45 AM posted to microsoft.public.word.mailmerge.fields
Jerry Garnett
external usenet poster
 
Posts: 1
Default Also having problem with Word Merge data source

I have been able to create a merge document and save the data source using paths such as T:\Data\s1prod\word_us or U:\, with the template document and the data source (a .dat file) in the same folder. Although asked to confirm the data sources's location, when I click on 'Yes' the document opens using the relevant data source.

However, when I use a path like \\Studep1.isd.ad.flinders.edu.au\t1\S1\Data\s1acce pt43\word_us I still get asked to confirm the data source when opening the template but it doesn't recognise this path and asks me to select a new data source. I can re-select the same data source and generate a document but when I save the template and re-open it, the same process occurs. It looks like Word doesn't like either the long path or not using a Drive letter.

Any ideas?

  #22  
Old July 30th, 2008, 08:06 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default Also having problem with Word Merge data source

Which version of Word in this case? Are you selecting a specific option in a
"Confirm Data Source" dialog box?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Jerry Garnett" wrote in message
...
I have been able to create a merge document and save the data source using
paths such as T:\Data\s1prod\word_us or U:\, with the template document and
the data source (a .dat file) in the same folder. Although asked to confirm
the data sources's location, when I click on 'Yes' the document opens using
the relevant data source.

However, when I use a path like
\\Studep1.isd.ad.flinders.edu.au\t1\S1\Data\s1acce pt43\word_us I still get
asked to confirm the data source when opening the template but it doesn't
recognise this path and asks me to select a new data source. I can
re-select the same data source and generate a document but when I save the
template and re-open it, the same process occurs. It looks like Word
doesn't like either the long path or not using a Drive letter.

Any ideas?


  #23  
Old August 1st, 2008, 02:55 AM posted to microsoft.public.word.mailmerge.fields
Jerry Garnett[_2_]
external usenet poster
 
Posts: 1
Default Also having problem with Word Merge data source

Word 2003. I never see the "Confirm Data Source" dialog box. Just the 'Select
Data souce' box.

"Peter Jamieson" wrote:

Which version of Word in this case? Are you selecting a specific option in a
"Confirm Data Source" dialog box?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Jerry Garnett" wrote in message
...
I have been able to create a merge document and save the data source using
paths such as T:\Data\s1prod\word_us or U:\, with the template document and
the data source (a .dat file) in the same folder. Although asked to confirm
the data sources's location, when I click on 'Yes' the document opens using
the relevant data source.

However, when I use a path like
\\Studep1.isd.ad.flinders.edu.au\t1\S1\Data\s1acce pt43\word_us I still get
asked to confirm the data source when opening the template but it doesn't
recognise this path and asks me to select a new data source. I can
re-select the same data source and generate a document but when I save the
template and re-open it, the same process occurs. It looks like Word
doesn't like either the long path or not using a Drive letter.

Any ideas?



  #24  
Old August 1st, 2008, 03:44 PM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default Also having problem with Word Merge data source

Experiments here have worked so far.

With the file and data source open, can you use the Visual Basic editor to
display the value of ActiveDocument.Mailmerge.DataSource.ConnectString ?

(Actually, I can only get Word 2003 to open .dat data sources using its
internal text converter: a blank result would confirm that this is what is
happening on your system too).

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Jerry Garnett" Jerry wrote in message
...
Word 2003. I never see the "Confirm Data Source" dialog box. Just the
'Select
Data souce' box.

"Peter Jamieson" wrote:

Which version of Word in this case? Are you selecting a specific option
in a
"Confirm Data Source" dialog box?

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Jerry Garnett" wrote in message
...
I have been able to create a merge document and save the data source
using
paths such as T:\Data\s1prod\word_us or U:\, with the template document
and
the data source (a .dat file) in the same folder. Although asked to
confirm
the data sources's location, when I click on 'Yes' the document opens
using
the relevant data source.

However, when I use a path like
\\Studep1.isd.ad.flinders.edu.au\t1\S1\Data\s1acce pt43\word_us I still
get
asked to confirm the data source when opening the template but it
doesn't
recognise this path and asks me to select a new data source. I can
re-select the same data source and generate a document but when I save
the
template and re-open it, the same process occurs. It looks like Word
doesn't like either the long path or not using a Drive letter.

Any ideas?




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.