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 / July 2005

Tip: Looking for answers? Try searching our database.

Data appears in my letter which is NOT in the data source, why?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
minidriverpip - 30 Jun 2005 15:37 GMT
I hold data in an excel spreadsheet and am merging to word. I'm using windows
Xp if that matters! Info is appearing in my form letters which shouldn't be
there, and is not in the corresponding cells in the exce data source. I have
tried deleting the merge fields and doing it again but it keeps reappearing
Anne Troy - 30 Jun 2005 16:21 GMT
What is the data, please?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

> I hold data in an excel spreadsheet and am merging to word. I'm using windows
> Xp if that matters! Info is appearing in my form letters which shouldn't be
> there, and is not in the corresponding cells in the exce data source. I have
> tried deleting the merge fields and doing it again but it keeps reappearing
Cindy M  -WordMVP- - 30 Jun 2005 16:27 GMT
Hi =?Utf-8?B?bWluaWRyaXZlcnBpcA==?=,

> I hold data in an excel spreadsheet and am merging to word. I'm using windows
> Xp if that matters! Info is appearing in my form letters which shouldn't be
> there, and is not in the corresponding cells in the exce data source. I have
> tried deleting the merge fields and doing it again but it keeps reappearing

Version of Word would be more interesting than the version of Windows...

Could you give us an example or two of what's happening? Including the text
surrounding the merge fields in the document.

If you start with a new document, link to the Excel file, and insert a couple of
the merge fields do you see the same problem when merging this test document to
a new document?

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 :-)
minidriverpip - 30 Jun 2005 17:14 GMT
I am using word 2003. I have similarly named (but NOT the same name) column
headings in excel and the cells hold simple text. I'm using a table in word.
Whilst several of the rows of the table correctly display the right text, two
particular rows should be empty as the cells are empty in excel, but it is
repeating the information from the row above or from the previous excel
cells. I have double checked that I do not have a rogue merge field in, and I
don't, it is correct. I have deleted the row and done it again and it repeats
the mistake. I am using the correct merge field for sure! Think I'm going
crazy! Thanks for your help

> Hi =?Utf-8?B?bWluaWRyaXZlcnBpcA==?=,
>
[quoted text clipped - 19 lines]
> This reply is posted in the Newsgroup; please post any follow question or reply
> in the newsgroup and not by e-mail :-)
Cindy M  -WordMVP- - 01 Jul 2005 16:13 GMT
Hi =?Utf-8?B?bWluaWRyaXZlcnBpcA==?=,

This certainly indicates either a damaged document, or a damaged Excel workbook.
Did you try my suggestion to test linking the data to a new document?

> I am using word 2003. I have similarly named (but NOT the same name) column
> headings in excel and the cells hold simple text. I'm using a table in word.
[quoted text clipped - 4 lines]
> don't, it is correct. I have deleted the row and done it again and it repeats
> the mistake.

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 :-)
 
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.