Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2006

Tip: Looking for answers? Try searching our database.

Modified Excel Data - Now unusable

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
C Brandt - 26 May 2006 04:18 GMT
I created a word document with 93 Merge Fields and a significant number of
word fields.

My data source is an excel spreadsheet.

I collected all the data onto the first sheet and then merged the two
documents. After a significant bit of juggling, I had almost exactly what I
wanted. The key word in that sentence was "almost".

I inserted several columns in the middle of the first sheet and now nothing
lines up. I created a new Word document and linked all the merge fields, but
it almost looks like the system remembered the headers form the first pass
and links in the wrong data.

Is there something I can do to reset all connections without redoing the
whole thing?

Any suggestions will be appreciated,

Craig
Doug Robbins - Word MVP - 26 May 2006 05:17 GMT
I would try changing the mailmerge main document type to a Normal Word
Document, then change it back to whatever type that it is now and then
re-attach the data source.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I created a word document with 93 Merge Fields and a significant number of
> word fields.
[quoted text clipped - 19 lines]
>
> Craig
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.