Re: Some of my merged data is missing

Tech-Archive recommends: Fix windows errors by optimizing your registry

Perhaps using a different connection method will resolve the issue.
You didn't indicate which version of Word and Excel you are using but
I'm presuming the 2003 version?? If that's the case then they changed
the default method to establish a connection for your mail merge data
source.

In Word, go to Tools/Options/General and turn on "Confirm conversions
at open" . Then reopen your data source for your merge document. Prior
to opening you'll see a Select Method dialog box. Use the DDE
connection and see if that gives you the results you are looking for.

Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Office 2007 Preview Site:
http://www.microsoft.com/office/preview/default.mspx
Office 2007 Community Articles/Tutorials:
http://www.microsoft.com/office/preview/community/article_archive.mspx

TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

"shelleyb89" <shelleyb89@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:54D130AD-87D8-40C3-8710-8A2A6406A562@xxxxxxxxxxxxxxxx
I am using excel to create student reports and I am using merging
with word
for printing onto a document set out with various text boxes. The
problem is
that some of the reports cut off mid way through the report
paragraph.

I have looked the excel source *** and checked validation and
formatting
and to the best of my knowledge they seem ok. Have tried to look at
field
codes but not sure what I am looking for. The only common point I
can find
at this moment is this, when I look at the source cells containing
the report
itself under 'format cells', # appears for those records which are
mucking up
in the sample data box. The ones that work, you can see the start
of the
report. I have tried changing the format to text and back again, no
joy and
other articles indicate changing to general can solve the # issue,
so general
seems right.

If I run this merge on a friends older version of word and excel the
merge,
this problem disapears. Can anyone suggest a fix?


.

Quantcast