Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Ian R Ian R is offline
external usenet poster
 
Posts: 12
Default Mail merge form does not retain link to Excel data file

Hi

I'd be very grateful if anyone can shed some light on this error...

I have set up a mail merge form which gets its data from an excel sheet.

It all works fine except that I each time I open the mail merge form it
doesn't have a link to the data file - nearly all the buttons on the mail
merge toolbar, apart from two, are greyed out. So I have to click the "open
data source" button and navigate to the folder containing the Excel data
file and select it to recreate the link.

How do I get my form to retain the link?

Also I used to have a button on the mm toolbar which would allow me to edit
the data source but that is no longer there - even after the data source has
been manually linked as I described above.

Thanks for your time and invaluable assistance.

Ian



  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Cindy M. Cindy M. is offline
external usenet poster
 
Posts: 2,416
Default Mail merge form does not retain link to Excel data file

Hi Ian,

which VERSION of Word are you using, including SP number? If you're unsure,
check in Help/About.

And in which version of Word did you have the button that allowed you to edit
the data source?

I'd be very grateful if anyone can shed some light on this error...

I have set up a mail merge form which gets its data from an excel sheet.

It all works fine except that I each time I open the mail merge form it
doesn't have a link to the data file - nearly all the buttons on the mail
merge toolbar, apart from two, are greyed out. So I have to click the "open
data source" button and navigate to the folder containing the Excel data
file and select it to recreate the link.

How do I get my form to retain the link?

Also I used to have a button on the mm toolbar which would allow me to edit
the data source but that is no longer there - even after the data source has
been manually linked as I described above.


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
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
How do I mail merge to EMAIL from MS Word AND add a pdf attachment Lily@Insight Mailmerge 24 January 15th 07 09:33 PM
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
Word 2003 Mail Merge Problem when E-Mailing Data Source Karen Townsend Mailmerge 3 June 20th 06 08:21 AM
merge instructions from text file Steve Mailmerge 8 November 26th 05 03:31 AM
Using HTML file as data source for Mail Merge thenin Mailmerge 4 November 21st 05 08:03 AM


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