Reply
 
Thread Tools Display Modes
  #1   Report Post  
Dennis Doughty
 
Posts: n/a
Default Help getting mail merge from web site to work

I have a successful mail merge setup that uses a local
Excel file as my address list. When I place this file
on a remote web site, so that it is addressed as
http://www.website.com/spreadsheet.xls rather than
c:\my documents\spreadsheet.xls, Word 2003 spends a
few seconds trying to retrieve the spreadsheet and then
reports the following error message:
"The document name or path is not valid"

I suspect that this is due to some security feature in
Office 2003 or Windows XP (Service Pack 2), but all the
ordinary solutions (such as placing the website.com into
my trusted sites list) do not appear to have any effect.

Does anyone know how to configure this?

Thanks.
  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi Dennis,

I have a successful mail merge setup that uses a local
Excel file as my address list. When I place this file
on a remote web site, so that it is addressed as
http://www.website.com/spreadsheet.xls rather than
c:\my documents\spreadsheet.xls, Word 2003 spends a
few seconds trying to retrieve the spreadsheet and then
reports the following error message:
"The document name or path is not valid"

Actually, this is due to the fact that Word's core mail
merge technology is some 15 or 20 years old. Before
internet addresses were commonplace. Word didn't learn to
recognize internet addresses at all until version 97, and
then only for opening files.

I'm afraid the data source has to be saved to a traditional
network or local path.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)

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 Word 2003 Issue S.Nicks Mailmerge 5 February 20th 09 02:55 AM
Why can't I use Mail Merge Wizard with Avery 2160 labels?. Andy39 Mailmerge 1 December 10th 04 03:19 AM
Mail merge toolbar unavailable after SP3 R Scott Lowden Mailmerge 1 December 1st 04 07:24 PM
Mail Merge Problem Cindy M -WordMVP- Mailmerge 0 November 30th 04 06:25 PM
Using Hyperlinks in Mail Merge IF...THEN...ELSE Statements Mark V Mailmerge 8 November 30th 04 02:31 PM


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