Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
sbrimley
 
Posts: n/a
Default Help! Merged data is wrong

I am merging information from Excel to Word. The data is either a P (pass) M
(monitor) or a R (Referral). This represents what a child received in a
particular developmental area we screen for. We are trying to merge the
information into a report for each child and even though the cell in Excel
states a P (pass) for Reading, in the merged Word report it is being
displayed as a R (Referral). When I merged the data into the report all R's
become P's and all P's become R's. Any suggestions??

I am using Word & Excel 2003. I realize they changed the way the two
applications communicate with each other in regards to merged data. And I
have tried reverting back to DDE and that has not worked. I have also looked
at the following article and only understand a little bit of what it is
saying and still do not know how to fix the problem.
http://groups.google.ca/group/micros...aa36b6e?hl=en&

Any help would be greatly appreciated.
Suzanne
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
 
Posts: n/a
Default Help! Merged data is wrong

That is one that I would have to see to believe. If you want to send me a
copy of the mailmerge main document and of the data source, I will take a
look to see if I can tell what is going wrong.

You don't happen to have a Next Record field in there somewhere that is
causing the merge to jump prematurely to the next record do you?

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

"sbrimley" wrote in message
...
I am merging information from Excel to Word. The data is either a P (pass)
M
(monitor) or a R (Referral). This represents what a child received in a
particular developmental area we screen for. We are trying to merge the
information into a report for each child and even though the cell in Excel
states a P (pass) for Reading, in the merged Word report it is being
displayed as a R (Referral). When I merged the data into the report all
R's
become P's and all P's become R's. Any suggestions??

I am using Word & Excel 2003. I realize they changed the way the two
applications communicate with each other in regards to merged data. And I
have tried reverting back to DDE and that has not worked. I have also
looked
at the following article and only understand a little bit of what it is
saying and still do not know how to fix the problem.
http://groups.google.ca/group/micros...aa36b6e?hl=en&

Any help would be greatly appreciated.
Suzanne



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
sbrimley
 
Posts: n/a
Default Help! Merged data is wrong

Thank you for your response I have figured out the problem. In my excel
sheet there is a lot of linked data and when a staff person sorted on one
sheet it it was not sorting all the data on the other sheet and that sheet is
the one that the data was being pulled from, therefore all the wrong data.
So frustrating, I will go onto the excel group and post my sorting question.
Thanks again

"Doug Robbins - Word MVP" wrote:

That is one that I would have to see to believe. If you want to send me a
copy of the mailmerge main document and of the data source, I will take a
look to see if I can tell what is going wrong.

You don't happen to have a Next Record field in there somewhere that is
causing the merge to jump prematurely to the next record do you?

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

"sbrimley" wrote in message
...
I am merging information from Excel to Word. The data is either a P (pass)
M
(monitor) or a R (Referral). This represents what a child received in a
particular developmental area we screen for. We are trying to merge the
information into a report for each child and even though the cell in Excel
states a P (pass) for Reading, in the merged Word report it is being
displayed as a R (Referral). When I merged the data into the report all
R's
become P's and all P's become R's. Any suggestions??

I am using Word & Excel 2003. I realize they changed the way the two
applications communicate with each other in regards to merged data. And I
have tried reverting back to DDE and that has not worked. I have also
looked
at the following article and only understand a little bit of what it is
saying and still do not know how to fix the problem.
http://groups.google.ca/group/micros...aa36b6e?hl=en&

Any help would be greatly appreciated.
Suzanne




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
Mailmerge chooses wrong data language jco Mailmerge 1 November 25th 05 02:12 PM
how to allow merged data to expand row in table turneg02 Page Layout 1 July 28th 05 04:36 PM
View Merged Data Button not Working AlanMagppie Mailmerge 2 June 10th 05 07:12 PM
How do I keep merged data from advancing surrounding text in a fo. Don Coffey Microsoft Word Help 0 December 23rd 04 04:03 PM
Merged data that is present in data source is missing in merge mbd_newjersey Mailmerge 1 December 17th 04 10:52 AM


All times are GMT +1. The time now is 07:57 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"