Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
MaxArk[_8_] MaxArk[_8_] is offline
external usenet poster
 
Posts: 1
Default Merge Field Not Displaying Same Data as In Source


I have a merge field is a document that is not merging the same data
accurately from the source.

I have inserted the merge field in the document exactly as titled from
the Excel data source. Although the data says "Upper" (in the Excel
Source field column), "0" gets merged. It should be "Upper".

Can anyone advise where I should be looking to find why the information
is merging improperly?

Jenn




--
MaxArk
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merge Field Not Displaying Same Data as In Source

In Word, from the Tools menu, select Options and then go to the General tab
and place a check mark against the "Confirm conversions at open" item. Then
when you attach the data source to the mail merge main document, select the
DDE method of attachment.

What is probably happening is that with the default ODBC connection, the
system determines from the first 6 or 8 records what type of data is in each
field and it may thus be determining that the data in that field is numeric
rather than there possibly also being text entries.

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

"MaxArk" wrote in message
...

I have a merge field is a document that is not merging the same data
accurately from the source.

I have inserted the merge field in the document exactly as titled from
the Excel data source. Although the data says "Upper" (in the Excel
Source field column), "0" gets merged. It should be "Upper".

Can anyone advise where I should be looking to find why the information
is merging improperly?

Jenn




--
MaxArk



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
Merge field is not displaying properly gorfinneed Mailmerge 2 April 26th 08 12:50 AM
reversing "Last, first" in mail merge from one data source field Plum3pc Mailmerge 2 August 27th 06 06:51 AM
data in mail merge letter being cut off - data source field size? tgone Mailmerge 1 May 20th 05 02:10 PM
Mail merge field isn't displaying all the text in a field. Can I . mojohubbard Mailmerge 3 March 28th 05 04:45 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 09:31 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"