Some of my merged data is missing

S

shelleyb89

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 sheet 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?
 
B

Beth Melton

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/
 
R

Rene Miller

I had this problem also. In Excel I had a room number of B1. It would not
display in my merged document. After I followed Beth's advice it worked!
Thank you!
 
B

Beth Melton

I'm glad to hear you found a solution and it's great to see that past
posts are still helping others out. :)

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

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

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