Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
SK SK is offline
external usenet poster
 
Posts: 9
Default Mail Merge Data Source Issue

I want to use an Html file as Data Source for mail merge.
The documentation says :
(http://office.microsoft.com/en-us/wo...875951033.aspx)
You can use an HTMLfile that has a single table. The first row of the table
must contain column names and the other rows must contain data.
I tried using simple table like this:
html
body
table
tr
tdName/tdtdAddress/tdtdCity/td
/tr
tr
tdN/tdtdA/tdtdC/td
/tr
/table
/body
/html

I accessed it though a web URl like : http://localhost/web/test.html
if I give this URL as Data Source, it gives error:
Document name or path is invalid.
But if I browse it, I can see the file intact.

Can somebody please provide a simple sample for this?

Thanks.!
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
SK SK is offline
external usenet poster
 
Posts: 9
Default Mail Merge Data Source Issue

One more finding.
I found that giving the same Html file as data source works, when the file
is present locally.
It fails to work when a Web Url is given as Data Source.

Thanks

"SK" wrote:

I want to use an Html file as Data Source for mail merge.
The documentation says :
(http://office.microsoft.com/en-us/wo...875951033.aspx)
You can use an HTMLfile that has a single table. The first row of the table
must contain column names and the other rows must contain data.
I tried using simple table like this:
html
body
table
tr
tdName/tdtdAddress/tdtdCity/td
/tr
tr
tdN/tdtdA/tdtdC/td
/tr
/table
/body
/html

I accessed it though a web URl like : http://localhost/web/test.html
if I give this URL as Data Source, it gives error:
Document name or path is invalid.
But if I browse it, I can see the file intact.

Can somebody please provide a simple sample for this?

Thanks.!

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

1. You are right. Word, "out of the box", cannot use http:// or ftp//
URLs as data sources (I do not know why, since Word is quite capable of
opening Word documents at http: or ftp: URLs)

2. Yes, Word can open HTML format data sources. It just cannot do it via
HTTP :-(

http://tips.pjmsn.me.uk

SK wrote:
One more finding.
I found that giving the same Html file as data source works, when the file
is present locally.
It fails to work when a Web Url is given as Data Source.

Thanks

"SK" wrote:

I want to use an Html file as Data Source for mail merge.
The documentation says :
(http://office.microsoft.com/en-us/wo...875951033.aspx)
You can use an HTMLfile that has a single table. The first row of the table
must contain column names and the other rows must contain data.
I tried using simple table like this:
html
body
table
tr
tdName/tdtdAddress/tdtdCity/td
/tr
tr
tdN/tdtdA/tdtdC/td
/tr
/table
/body
/html

I accessed it though a web URl like : http://localhost/web/test.html
if I give this URL as Data Source, it gives error:
Document name or path is invalid.
But if I browse it, I can see the file intact.

Can somebody please provide a simple sample for this?

Thanks.!

  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
SK SK is offline
external usenet poster
 
Posts: 9
Default Mail Merge Data Source Issue

I am sorry to hear that it does not function.
If I put fiddler, I can watch that it does not issue a GET command, but only
a PROPFIND command.


"Peter Jamieson" wrote:

1. You are right. Word, "out of the box", cannot use http:// or ftp//
URLs as data sources (I do not know why, since Word is quite capable of
opening Word documents at http: or ftp: URLs)

2. Yes, Word can open HTML format data sources. It just cannot do it via
HTTP :-(

http://tips.pjmsn.me.uk

SK wrote:
One more finding.
I found that giving the same Html file as data source works, when the file
is present locally.
It fails to work when a Web Url is given as Data Source.

Thanks

"SK" wrote:

I want to use an Html file as Data Source for mail merge.
The documentation says :
(http://office.microsoft.com/en-us/wo...875951033.aspx)
You can use an HTMLfile that has a single table. The first row of the table
must contain column names and the other rows must contain data.
I tried using simple table like this:
html
body
table
tr
tdName/tdtdAddress/tdtdCity/td
/tr
tr
tdN/tdtdA/tdtdC/td
/tr
/table
/body
/html

I accessed it though a web URl like : http://localhost/web/test.html
if I give this URL as Data Source, it gives error:
Document name or path is invalid.
But if I browse it, I can see the file intact.

Can somebody please provide a simple sample for this?

Thanks.!


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
Mail merge DIRECTORY issue with Excel as data source repeats doc p bjm Mailmerge 4 May 12th 07 08:21 AM
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
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM


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